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

Excel’s charts automatically update when the data changes.

Excel tables automatically include a filter option in each column header.

The Remove Duplicates feature can identify and delete duplicate rows in a table.

You can link data between different worksheets in the same workbook.

The MAX function returns the smallest value in a range.

You cannot sort data in a table by more than one column.

The NPV function calculates the net present value of an investment.

Column width can be adjusted manually or automatically in Excel.

The COUNT function is used to count the number of cells that contain numbers.