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?

Use the _____ button to work through a formula value by value to determine where an error exists.

To create your own number format, select _____ in the Category list box at the Format Cells dialog box with the Number tab selected.

By default, when a worksheet is protected, you