All of the following statements are TRUE regarding grouping in PivotTables EXCEPT:
A) Grouping variables are placed along the top or the left side of the PivotTable.
B) The summary variables are positioned in the VALUES area below the PivotTable Fields list.
C) The grouping variables are positioned in the COLUMNS or ROWS areas at the top of the PivotTable Fields pane.
D) Dates are great for grouping into months, quarters, and years to explore trends over time.
Answer: C
Computer Science & Information Technology
You might also like to view...
Your boss wants you to secure your web server's transactions. Which protocol and port number should you use to accomplish this?
A. POP3–110 B. LDAP–389 C. RDP–3389 D. HTTPS–443
Computer Science & Information Technology
Date values must be entered in the format _____.
A. yyyymmdd B. yymmdd C. yyyy-mm-dd D. yy/mm/dd
Computer Science & Information Technology