What is true of Grand Totals? They are always highlighted green. They are
always shown as averages. They are required for a PivotTable. They can be
shown for ROWS.
Answer & Explanation
The correct statement about Grand Totals is: "They can be shown for ROWS."
Explanation:
1. They are always highlighted green:
o This is not true. The highlighting of Grand Totals depends on the
formatting applied by the user in a PivotTable. There is no default
color like green that is universally applied to Grand Totals.
2. They are always shown as averages:
o This statement is incorrect. Grand Totals in a PivotTable can
represent various calculations such as sums, averages, counts, etc.,
depending on how the data field settings are configured.