40 terms

function

A ________ is a prewritten formula that is built into Excel.

ALT+ENTER

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

20xx

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

>

________ is not a valid arithmetic operator.

=23%

Multiplies 23 by 0.01

operations

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

26

When Excel follows the order of operations, for formula, 8*3+2, equals ________.

=G15

Excel assigns the value in cell G15 to the active cell.

select cells for use in a formula using the mouse pointer

Point mode allows you to ________.

relative

The adjusted cell references in a copied and pasted formula are called ________ references.

(Home tab | Clipboard group)

Path to the copy and paste buttons

AutoCorrect Options

You can click the ________ button to undo an automatic correction.

Auto Fill Options

Gives options for filling cells following a fill operation

Trace Error

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

F8

You can select a range using the keyboard by pressing the ________ key and then an ARROW key.

Insert

The ________ Option button lists formatting options following an insertion of cells, rows, or columns.

blank

A ________ cell in Excel has a numerical value of zero.

AVERAGE

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.

Formula

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

right parenthesis

Excel automatically appends the ________ to complete the AVERAGE function with you click the Enter box or press the ENTER key.

(Home tab | Editing group)

Path to the Sum button

double-click

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

MAX

The ________ function displays the highest value in a range.

Insert Function box on the formula bar

Clicking the ________ opens the Insert Function dialog box shown in the accompanying figure.

MIN

The ________ function determines the lowest number in a range.

CTRL+C

To copy cell contents, you can select the cell and the press the ________ keys.

CTRL+V

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

Range Finder

You can use the ________ to check which cells are referenced in the formula assigned to the active cell.

theme

A ________ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.

CTRL+1

You can open the Format Cells dialog box by pressing the ________ keys.

blue

The most popular background color is ________.

Accounting number format

The ________ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.

fixed

In the accompanying figure, the ranges E4:I4 and F13:I13 are formatted with a ________ dollar sign.

(Home tab | Number group)

Path to the Comma Style button

(Home tab | Styles group)

Path to the Conditional Formatting button

8.43

If you do not assign a format to a cell or cells in a column, the column width will remain ________ characters.

0

When you decrease the row height to ________, the row is hidden.

(Review tab | Proofing group)

Path to the Spelling button

Page Layout

________ view allows you to create or modify a worksheet while viewing how it will look in printed format.

Print Selection

To print a range of cells in the active worksheet, click ________ in the Settings area in the Print gallery, as shown in the accompanying figure.