If you want to summarize data from multiple places and want to use formulas with cell references or 3-D references to the other worksheets that you are combining because you do not have a consistent position or category of data to use,you would use the ________ option.
A)consolidate by formula
B)consolidate by position
C)consolidate by category
D)PivotTable report

Question

Quizplus · Accepted Answer

The consolidate by formula option allows you to use formulas with cell references or 3-D references to combine data from multiple worksheets. The consolidate by position and consolidate by category options require a consistent position or category of data. The PivotTable report option is a different method of summarizing data.

If You Want to Summarize Data from Multiple Places and Want