Exam 4: Excel: Formulas, Functions, and Formatting

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

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

In the accompanying figure, the value $19.33 in the column labeled Hourly Pay Rate is formatted with a ____ dollar sign.

What is the value when Excel calculate the average of three cells with values of 10, blank, and 8?

Which of the following calculations multiplies 23 by 0.01?

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

You can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.

The Insert Options button lists formatting options.

By default, Excel for Mac uses a ____ year value.

The ____ function determines the lowest number in a range.

You should ____ a function name in the Formula AutoComplete list to select the function.

Which of the following are considered guidelines to use when making decisions about creating a new workbook?

The ____ style assigned using the Format Cells dialog uses a floating dollar sign that appears immediately to the left of the first digit.

Worksheet ____________________ typically contain items analogous to items in a list.

Which of the following is not connoted by the color blue?

You can press the ____________________ key to quit Range Finder.

You cannot format an entire column at once.

Typing =av in a cell displays the ____________________.