Why are text files useful for sharing data with others?

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

In a _____, Excel copies the formula from the first cell to the remaining cells in the column immediately after the formula is entered.

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.

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?