Multiple Choice
Izzy wants to move a pivot table to a new worksheet.Which of these should she select after the following clicks to do so: PivotTable > Analyze tab > PivotTable tools > Move PivotTable > Move PivotTable dialog box > Choose where you want the PivotTable to be placed?
A) New Worksheet
B) Blank Worksheet
C) Fresh Worksheet
D) Create Worksheet
Correct Answer:
Verified
Correct Answer:
Verified
Q19: Luca wants to insert a pivot table.He
Q20: Horatio wants to hide field headers in
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
Q25: To add a calculated field to a
Q26: Barry creates a table showing ranks and
Q27: To display the PivotTable Field list,right-click any
Q28: The score of a student in two
Q29: Which of these functions will you use