Working with Multiple Worksheets and Workbooks Answers

5 verified answers2 views

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.

Sort & Filter

Connections

Data Tools

Outline

What are the steps for consolidating data from multiple worksheets?

Arrange All

Freeze Panes

New Window

Switch Windows

What are the steps for consolidating data from multiple worksheets?

Consolidate

Data Validation

Sort

Text to Columns

What must be included in an external link to make sure the cell formula does not change?

internal link

workbook name

relative reference

absolute reference

Did you find these answers helpful?

More from this Course