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…
Use the _____ function with an IF function to test multiple conditions.
Use Excel’s _____ feature when you know the result but don’t…
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 re…
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 m…
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 mista…
Click the _____ button if you remove duplicate rows by mistake.
What advice does Chapter 5 give regarding creating scenarios…
What advice does Chapter 5 give regarding creating scenarios?
Use the _____ button to work through a formula value by valu…
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 Catego…
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
By default, when a worksheet is protected, you