In a 3-D cell reference, which symbol is used to separate a worksheet name from a cell number?
Use the drop-down menus to explain how to locate the Consolidate dialog box.
What are the steps for consolidating data from multiple worksheets?
Did you find these answers helpful?
Working with Multiple Worksheets and Workbooks
Lookup Functions and Formula Auditing
Topic Test