The Subtotal function can only be used in data that is formatted as a table.

The RATE function is used to calculate the interest rate required to reach a specific future value.

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.