Multiple Choice
Horatio wants to hide field headers in a Pivot table to increase the display of the screen.He clicks on a cell in the pivot table,then clicks on ANALYZE in the ribbon.What should he do next to complete the procedure?
A) Click on Clear in the Actions group.
B) Click on +/- Buttons in the Show group.
C) Click on Field Headers in the Show group.
D) Click on Fields,Items & Sets in the Calculations group.
Correct Answer:

Verified
Correct Answer:
Verified
Q15: Right-click the pivot item,then click Collapse to
Q16: Which of these is the default layout
Q17: One can use the areas section (at
Q18: To remove a field,in the PivotTable Field
Q19: Luca wants to insert a pivot table.He
Q21: One can rearrange fields in the PivotTable
Q22: To filter data in a PivotTable,follow the
Q23: Ingrid wants to change the name associated
Q24: Izzy wants to move a pivot table
Q25: To add a calculated field to a