The term _____ refers to descriptive information about data.

How can you tell that a filter has been defined for a column?

Removing the connection between the source file and the destination file allows which of the following?

The method of formatting even-numbered rows in a table differently from odd-numbered rows is called

Use the _____ function with an IF function to test multiple conditions.

Use Excel’s _____ feature when you know the result but don’t know what input value will achieve that result.

Before creating subtotals for a range of data, be sure to remove any _____ within the range to be grouped and subtotaled.

When you send a worksheet as a PDF document, the recipient must have _____ on his or her computer to use the file.

Click the _____ button if you remove duplicate rows by mistake.

What advice does Chapter 5 give regarding creating scenarios?