Test #3

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

True

If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters. A. 8.43 B. 7.52 C. 11.65 D. 9.43

A. 8.43

Pressing the ____ keyboard shortcut key(s) selects cell A1. A. CTRL+HOME B. CTRL+END C. HOME D. END

A. CTRL+HOME

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. A. ENTER B. ALT C. CTRL D. SHIFT

A. ENTER

A ____ is text and graphics that print at the top of each page. A. header B. topper C. margin D. crown

A. Header

Clicking the ____ opens the Insert Function dialog box. A. Insert Function box in the formula bar B. Function dialog box launcher (HOME tab | Calculations group) C. Function button (HOME tab | Function group) D. Functions & Formulas button on the status bar

A. Insert Function box in the formula bar

Combining two or more selected cells into one cell is called______ cells. A. Merging B. Mixing C. Combining D. Spanning

A. Merging

The default view in Excel is called ____ view. A. Normal B. Standard C. Basic D. Values

A. Normal

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. A. range B. bunch C. nearby cell D. neighbor

A. Range

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it. A. two B. three C. four D. five

A. Two

The date you change a file is an example of a(n) ____ property. A. automatically updated B. baseline C. standard D. indexed

A. automatically updated

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart. A. exploded B. outer C. offset D. rasterized

A. exploded

A ____ is text and graphics that print at the bottom of every page. A. footer B. toe C. margin D. stopper

A. footer

A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function. A. included B. other C. nested D. duplicate

C. Nested

The person or persons requesting the worksheet should supply their requirements in a ____ document. A. blank B. test issues C. requirements D. certified

C. Requirements

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance. A. scheme B. gallery C. theme D. style

C. Theme

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

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

Formula AutoComplete List

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

IF

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 False

True

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

True

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. A. ACCESS B. TOOLS C. EXIT D. FILE

D. FILE

The ____ function determines the lowest number in a range. A. LOW B. BASE C. LEAST D. MIN

D. MIN

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

False

A thin red border indicates the active cell. True False

False

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

Clustered Column

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

False

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

False

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

False

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

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 False

True

The ____ is a blinking vertical line that indicates where the next typed character will appear. A. scroll box B. sheet tab C. insertion point D. split bar

. C. Insertion point

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

Active

The path to the Format Painter button is ____. A. (HOME tab | Number group) B. (HOME tab | Clipboard group) C. (HOME tab | Painting group) D. (HOME tab | Font group)

B. (HOME tab | Clipboard group)

The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. A. AutoComplete B. Auto Correct C. Auto Format D. Auto Typing

B. Auto Correct

Press ____ to select the entire worksheet. A. F1 B. CTRL+A C. ALT+A D. F4

B. CTRL+A

The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory. Ribbon Clipboard Folder File

B. Clipboard

In a clustered column chart, the names of each column are part of the ____ series. A. category B. data C. label D. legend

B. Data

The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled. A. Copy Cells B. Fill Formatting Only C. Fill Without Formatting D. none of the above

B. Fill Formatting Only

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign. A. Function B. Formula C. Equal D. Calculate

B. Formula

The ____ Option button lists formatting options following an insertion of cells, rows, or columns. A. AutoCorrect B. Insert C. Auto Fill D. Paste

B. Insert

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. A. Position B. Orientation C. Slope D. Incline

B. Orientation

A ____ reference is an adjusted cell reference in a copied and pasted formula. A. revised B. relative C. recycled D. retained

B. relative

The adjusted cell references in a copied and pasted formula are called ____ cell references. A. related B. relative C. pasted D. alternative

B. relative

The first step in creating an effective worksheet is to make sure you ____. A. apply font formatting B. understand what is required C. insert a chart D. enter the data

B. understand what is required

In the accompanying figure, the split double arrow mouse pointer ____. A. indicates a hidden column B. allows text to be entered at that location C. is the result of moving the mouse pointer to the boundary between column heading A and column heading B D. indicates the proposed width of column A

C. is the result of moving the mouse pointer to the boundary between column heading A and column heading B

Point mode allows you to ____, as shown in the accompanying figure. A. select cells for use in a formula using the keyboard B. select a function from the Sum button list C. select cells for use in a formula using the mouse pointer D. edit cell contents directly in the cell

C. select cells for use in a formula using the mouse pointer

Error messages begin with the ____ symbol. A. ? B. = C. ! D. #

D. #

In Excel, a number can contain the characters ____. A. 0 1 2 3 4 5 6 7 8 9 B. + - ( ) , / C. . $ % E e D. all of the above

D. All of the above

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text. A. quotation mark (") B. colon (:) C. plus (+) D. equal sign (=)

D. equal sign (=)