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 (=)