If you want to summarize data from multiple places and want to arrange the data in all the worksheets in identical order and location,you would use the ________ option.
A)consolidate by category
B)consolidate by formula
C)PivotTable report
D)consolidate by position

Question

Quizplus · Accepted Answer

The option "consolidate by position" allows data from multiple worksheets to be arranged in the identical order and location. The other options (consolidate by category, consolidate by formula, and PivotTable report) do not have this specific capability.

If You Want to Summarize Data from Multiple Places and Want