Which of the following is not a valid method to remove a field from a PivotTable?
A) Click the field name in the Drag fields between areas below section and select Remove Field.
B) Click the check box next to the field name to deselect it in the Choose fields to add to report section.
C) Select the field to be removed in the PivotTable and press DELETE.
D) Drag a field name in the Drag fields between areas below section outside the PivotTable Fields List.
Correct Answer:
Verified
Q13: A(n)_ is an interactive table which uses
Q14: Which is an effective way to change
Q15: A subtotal row must contain at least
Q16: You are analyzing sales data and eating
Q17: Which function is not a Subtotal function?
A)MAX
B)SUM
C)AGGREGATE
D)AVERAGE
Q19: What dictates the order of hierarchy of
Q20: Grouping is _.
A)using a VLOOKUP function to
Q21: Using the % of Grand Total Calculation
Q22: A(n)_ is the association between tables where
Q23: What is the best option for a
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