Exam 2: Formulas,Functions,and Formatting

Using the Excel spell checker,you can ____.

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

Which of the following is the path to the Comma Style button?

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

The default font for the Basis theme is different than the default font for the Office theme.

When designing a worksheet,which steps should be taken to ensure that functional considerations supersede visual aesthetics?

To start a new line in a cell,press the ____ keys.

An asterisk (*)following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

____________________ view shows the worksheet divided into pages.

The function,or ____________________,of a worksheet is to provide a user with direct ways to accomplish tasks.

The AVERAGE function requires that the argument be included within parentheses following the function name.

The arithmetic operator,^,directs Excel to perform the division operation.

Excel includes a(n)____________________ you can use to check a worksheet for spelling errors.

The ____ button assigns a fixed dollar sign to the numbers in a selected range,with the dollar sign to the far left with spaces between it and the first digit in the cell.

To paste copied cell contents,you can press the ____ keys.

When you enter a two-digit year that is less than 30,Excel changes the year to ____.

In the order of operations,the last operation Excel performs is ____________________.

One of the reasons Excel is such a valuable tool is that you can assign a(n)____________________ to a cell,and Excel will calculate the result.

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

Clicking the ____ opens the Insert Function dialog box.