Which query performs calculations such as sum, average, and count, and rearranges the data so it is easier to view and analyze?

A crosstab query summarizes data using calculations such as sum, average, or count, then arranges the results by row and column headings. This makes patterns easier to view and analyze. The correct choice is the crosstab query.

AI-written and checked against the verified answer.