1
AssignmentMultiple Choice

Visualizing Data with Charts

Question 1 • Computer Applications - Office 2016 - EL3520 A

How will Excel summarize the data to create PivotTables?

Answer
A
summarize by row but not by column
B
summarize by column but not by row
C
summarize by individual cells
D
summarize by row and by column

Explanation

A PivotTable organizes data by placing fields in row and column areas, then summarizes the values at their intersections. So Excel summarizes the data by both row and column. The correct choice is “summarize by row and by column.”

AI-written and checked against the verified answer.

Next