Xan wants to change the number format in a PivotTable as well a PivotChart.To do so,she can right-click on a cell in the value field in the pivot table,then click Value Field Settings,and then the Number Format button in the popup menu,then select the formatting that she wants in the Format Cells dialog box and finally click OK.
Correct Answer:
Verified
Q22: One can rearrange fields in the PivotTable
Q23: To add a calculated field to a
Q24: The score of a student in two
Q25: Salena has created a chart to show
Q26: To add fields to a PivotTable,one can
Q28: To select the Row Labels in a
Q29: Warren creates a table listing the height
Q30: To use more than one filters per
Q31: The score of a student inserted in
Q32: A worksheet has the following data in
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents