If You Want to Summarize Data from Multiple Places and Want

Multiple Choice

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