Multiple Choice
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
Correct Answer:
Verified
Correct Answer:
Verified
Q25: Ungrouping worksheets is accomplished by either right-clicking
Q26: The Fill Across Worksheets feature of Excel
Q27: All of the following statements are TRUE
Q28: A 3-D range can be defined by
Q29: A worksheet can store only _ consolidation(s).
Q31: Multiple worksheets can be selected at the
Q32: Consolidating by category is more _ than
Q33: Microsoft,through its template site at Office.com,fosters a(n)_
Q34: Consolidate by _ can be used to
Q35: Multiple worksheets can be selected at the