The term _____ refers to descriptive information about data.
How can you tell that a filter has been defined for a column…
How can you tell that a filter has been defined for a column?
Removing the connection between the source file and the dest…
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 diffe…
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?