Excel Ch. 2

Created by SidneyLouise 

Upgrade to
remove ads

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.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

NEW! Voice Recording

Click the mic to start.

Create Set