Question

Which of the following statements accurately describe pivot tables? Select all that apply.



The values in a pivot table are used to calculate and count data.



Any changes made to the data summarization within a pivot table, such as applying filters or grouping fields, directly modify and overwrite the original source data.



The rows of a pivot table organize and group data horizontally.



A pivot table is a data summarization tool.


1 point

Answer 1

Correct answers:
- The values in a pivot table are used to calculate and count data.
- A pivot table is a data summarization tool.

Notes: Pivot tables aggregate (sum, count, average, etc.) data without overwriting the original source. Rows group data vertically (not horizontally).