Multiple Choice
Kevin formatted the values in a PivotTable by selecting the values and then clicking the Accounting Number Format button on the Home tab. When he changed the layout of the PivotTable, he lost the number formatting. Which dialog box should he use instead?
A) Format Cells dialog box
B) Value Field Settings dialog box
C) PivotTable Format dialog box
D) Value Properties dialog box
Correct Answer:

Verified
Correct Answer:
Verified
Q21: To change the color of cell content,you
Q46: A predesigned combination of formats, such as
Q159: Jin wants to insert a recommended PivotTable.
Q160: The three PivotTable layouts differ in how
Q161: To access data from an external data
Q162: To return a true value if any
Q163: AutoComplete can extend any data pattern involving
Q165: You use the Evaluate Formula dialog box
Q168: Which of the following is an unacceptable
Q169: A(n) hierarchy is an organization of fields