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.

Using data tables provides a means of analyzing various outcomes in a calculation without

Workbook properties can be viewed and edited at the

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

Which of these steps should be performed first when creating a table?

Excel’s Lookup & Reference functions provide a way to

The _____ function contains these arguments: (logical_test,value_if_true,value_if_false).

In a tab delimited text file, Excel _____ at each tab.

Text file formats usually use _____ to separate data fields.