Question

determining how excel will summarize
how will excel summarize the data to create pivottables?
summarize by row but not by column
summarize by column but not by row
summarize by individual cells
summarize by row and by column

Explanation:

In Excel PivotTables, data is summarized by both rows and columns. PivotTables allow grouping and aggregating data based on row categories (like different products) and column categories (like different regions), enabling cross - tabulation and summary of data from both dimensions. The other options are incorrect: summarizing by only row or only column is not how PivotTables work, and summarizing by individual cells is not the way PivotTables summarize data (they aggregate data across cells in rows and columns).

Answer:

D. summarize by row and by column