Test 3
The characters that Excel displays on the screen are a specific ____. A. font B. style C. size D. color
A. Font
An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation. A. True B. False
A. True
Cooler colors tend to pull away from the reader. A. True B. False
A. True
Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key. A. left parenthesis B. right bracket C. right parenthesis D. left bracket
A. left parenthesis
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 information that exists on a physical medium such as paper. A. hard copy B. column C. validation D. printout
A. Hard copy
By default, text is ____ in a cell. A. left-aligned B. centered C. justified D. right-aligned
A. Left-aligned
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
A character with a point size of 10 is about 10/72 of one inch in height. A. True B. False
A. True
A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet. A. True B. False
A. True
A thin red border indicates the active cell. A. True B. False
A. True
Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell. A. True B. False
A. True
Clicking the Create Function box opens the Function Arguments dialog box. A. True B. False
A. True
Excel can display characters in only three font colors: black, red, and blue. A. True B. False
A. True
Excel has more than 400 functions that perform just about every type of calculation you can imagine. A. True B. False
A. True
Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY. A. True B. False
A. True
Using the Excel spell checker, you can ____. A. check the spelling of words in a selected range B. add words to the dictionary
A. check the spelling of words in a selected range
A ____ is text and graphics that print at the bottom of every page. A. footer B. toe C. margin D. stopper
A. footer
A ____ is a prewritten formula that is built into Excel. A. function B. feature C. task D. calculation
A. function
A ____ is text and graphics that print at the top of each page. A. header B. topper C. margin D. crown
A. header
An Excel ____ allows data to be summarized and charted easily. A. worksheet B. workflow C. document D. presentation
A. worksheet
As you type, Excel displays the entry (and the Cancel box and Enter box) in the ____________________.
Formula
A(n) ____________________ is a dot on the screen that contains a color.
Pixel
Careful ____________________ can reduce your effort significantly and result in a worksheet that is accurate, easy to read, flexible, and useful.
Planning
A formula in a cell that contains a reference back to itself is called a(n) ____________________.
Circular reference
A(n) ____________________ conveys a visual representation of data.
Chart
A cell is selected, or ____________________, when a heavy border surrounds the cell, as shown in the accompanying figure
Active Cell
Which of the following actions are provided by the Paste Options button? A. Pastes synonyms or acronyms B. Copy just formulas
B. Copy just formulas
A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names. A. True B. False
B. False
A single point is about 1/32 of one inch in height. A. True B. False
B. False
As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations. A. True B. False
B. False
Best fit means that the width of the column will be increased or decreased by a percentage you specify. A. True B. False
B. False
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. A. True B. False
B. False
Live preview is available on a touch screen. A. True B. False
B. False
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
B. Function dialog box launcher (HOME tab | Calculations group)
If you have multiple Excel workbooks open, to close all open workbooks and exit Excel, ____. A. press ALT+F4 B. press and hold the Excel app button on the taskbar and then tap 'Close all windows' on the shortcut menu
B. press and hold the Excel app button on the taskbar and then tap 'Close all windows' on the shortcut menu
A ____ reference is an adjusted cell reference in a copied and pasted formula. A. revised B. relative C. recycled D. retained
B. relative
Clicking the ____ box completes an entry. A. Cancel B. Formula C. Enter D. Tab
C. Enter
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
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
All of the following are valid Excel arithmetic operators EXCEPT ____. A. ^ B. * C. % D. >
D. >
A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell. A. contiguous B. indexed C. direct D. indirect
D. indirect
Typing =av in a cell displays the ____________________, as shown in the accompanying figure.
formula auto complete
