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

Question

Quizplus · Accepted Answer

When changing the layout of a PivotTable, the Value Field Settings dialog box should be used to maintain the number formatting. This dialog box allows you to customize the settings for each individual value field in the PivotTable, including number formatting. The Format Cells dialog box would work as well, but can be more time-consuming as it requires selecting each individual cell to apply formatting. The PivotTable Format dialog box and Value Properties dialog box are not relevant for maintaining number formatting.

Kevin Formatted the Values in a PivotTable by Selecting the Values