If you want to summarize data from multiple places and want to organize the data differently than how it is presented in the separate worksheets,but use the same row and column labels so the consolidated worksheet matches the data,you would use the ________ option.
A)consolidate by position
B)consolidate by formula
C)consolidate by category
D)PivotTable report

Question

Quizplus · Accepted Answer

Consolidating by category allows you to summarize data from multiple worksheets using the same row and column labels, ensuring that the consolidated worksheet matches the data structure.

If You Want to Summarize Data from Multiple Places and Want