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.

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.