EXCEL Test 3

The _____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled

Fill Formatting Only

Typing =av in a cell displays the _____, as shown in the accompanying figure

Formula AutoComplete list

Pressing the _____ keyboard shortcut key(s) selects cell A1

HOME

The _____ function is useful when you want to assign a value to a cell based on a logical test

IF

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

Insert

Clicking the _____ opens the Insert Function dialog box

Insert Function box in the formula bar

The ____ function determines the lowest number in a range

MIN

Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY

True

The date you change a file is an example of a(n) _____ property

automatically updated

In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the _____ key

enter

The _____ preceding a formula alerts Excel that you are entering a formula or function and not text

equal sign(=)

A pie chart with one or more slices offset is referred to as a(n) _____ pie chart

exploded

A cell reference with only one dollar sign before either the column or the row is called an absolute reference

false

A thin red border indicates the active cell

false

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

false

Excel can display characters in only three font colors: black, red, and blue.

false

The _____ is a blinking vertical line that indicates where the next typed character will appear

insertion point

The person or persons requesting the worksheet should supply their requirements in a _____ document

requirements

The Copy button copies the contents and format of the source area to the Office _____, a temporary storage area in the computer's memory

Clipboard

The type of chart shown in the accompanying figure is a(n) _____ chart

Clustered column

Excel includes four types of sparkline charts: line, column, win/loss, and stock

False

A company or department may standardize with a specific _____ so that all of their documents have a similar appearance

theme

A character with a point size of 10 is about 10/72 of one inch in height

true

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function

true

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

true

Excel has more than 400 functions that perform just about every type of calculation you can imagine

true

A _____ is text and graphics that print at the top of each page

header

If you do not assign a format to a cell or cells, in a column, the column within will remain _____ characters

8.43

Error messages begin with the _____ symbol

#

The path to the Format Painter button is _____

(Home tab | Clipboard group)

The _____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry

AutoCorrect

Press _____ to select the entire worksheet

CTRL + A

If you wish to sign out of your Microsoft account, tap or click _____ on the ribbon to open the Backstage view and then tap or click the Account tab to display the Account gallery, and tap or click the Sign out link.

FILE

A cell is selected, or _____, when a heavy border surrounds the cell as shown in the accompanying figure

active

In Excel, a number can contain the characters

all of the above

In a clustered column chart, the names of each column are part of the _____ series

data

A _____ is text and graphics that print at the bottom of every page

footer

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

formula

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

formula

In the accompanying figure, the split double arrow mouse pointer _____

is the result of moving the mouse pointer to the boundary between column heading A and column heading B indicates the proposed width of column A

Combining two or more selected cells into one cell is called _____ cells

merging

A(n) _____ IF function is one I which the action to be taken for the true or false case includes yet another IF function

nested

The default view in Excel is called _____ view

normal

If you enter 90 in the Degrees box in the _____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell.

orientation

A _____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure

range

A _____ reference is an adjusted cell reference in a copied and pasted formula

relative

The adjusted cell reference in a copied and pasted formula are called _____ cell references

relative

Point mode allows you to _____, as shown in the accompanying figure

select cells for use in a formula using the mouse pointer

The Increase Indent button indents the content of a cell to the right by _____ spaces each time you click it

two

first step in crating an effective worksheet is to make sure you _____

understand what is required