The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

What does the expression x %= 10 do?

a. Adds 10 to the value of x, and stores the result in x. b. Divides x by 10 and stores the remainder in x. c. Divides x by 10 and stores the integer result in x. d. None of the above.

Critical Thinking Case-Based Questions ? Case 5-3 As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job. ? ? Ted wants to use his PivotTable to show the total value of the motorcycles for a series of motorcycle dealerships but he wants to filter the display to show only those dealers whose total stock of motorcycle is greater than $1 million. How would he accomplish this?

A. He would develop a PivotTable using the aggregate filter. B. He would develop a PivotTable using the report filter. C. He would develop a PivotTable using the category filter. D. He would develop a PivotTable using the value filter.