Multiple Choice
All of the following statements are TRUE regarding PivotTable and PivotChart best practices EXCEPT:
A) Format the PivotTable or PivotChart so it is easy to read and your audience understands what it is you are trying to communicate.
B) Once you have selected your data, ensure the source data are arranged in an area with column headings representing each field and the rows representing each record.
C) Distinguish fields as either grouping variables or slicer variables.
D) Know who your audience is prior to developing your PivotTable or PivotChart. It could make a difference in how much detail you display.
Correct Answer:

Verified
Correct Answer:
Verified
Q1: A(n)_ of original data should be made
Q2: When using the _ Filter feature,filtering criteria
Q4: Users can change the look of an
Q5: To _ data means to consolidate or
Q6: All of the following statements are TRUE
Q7: Which of the following statements about filtering
Q8: A PivotTable can be created on a
Q9: The _ function will run calculations on
Q10: By default,PivotTables show a _ for both
Q11: If the criteria range for the Advanced