The Consolidate tool is used to combine data from multiple worksheets or workbooks.

Querying a table refers to extracting specific data based on criteria.

Formatting cells can change the data stored in those cells.

Excel does not support the use of formulas across different workbooks.

The Watch Window allows you to monitor cells from multiple worksheets.

Excel allows you to hide worksheets within a workbook.

Excel allows you to create custom sort orders for specific data types.

Excel can only create one type of chart per worksheet.

The Goal Seek feature can be used to find an input value that produces a desired result.

A 3-D reference includes references to cells on other worksheets.