Excel Part 2
The adjusted cell references in a copied and pasted formula are called _____ cell references. A. Alternative B. Related C. Relative D. Pasted
Relative
Which of the following patterns extends the fill series to 757,550,525? A. 680, 580 B. 650, 600 C. 625, 600 D. 500, 475
625, 600
All of the following are valid excel arithmetic operators except _____. A. ^ B. * C. % D. >
>
Which of the following Auto Fill options is the same as the fill series option? A. Fill Months B. Copy Cells C. Fill Without Formatting D. Fill Formatting Only
Fill Months
A _____ is a prewritten formula that is built into excel. A. Calculation B. Feature C. Task D. Function
Function
The _____ function determines the lowest number in a range. A. LOW B. BASE C. LEAST D. MIN
MIN
To print a range of cells in the active worksheet, click _____ in the settings area in the print gallery. A. Print active sheets B. Print selection C. Print entire workbook D. None
Print Selection
A company or department may standardize with a specific _____ so that all of their documents have a similar appearance. A. gallery B. style C. theme D. scheme
Theme
When you decrease the row height to _____, the row is hidden. A. 3 B. 2 C. 1 D. 0
0
If you do not assign a format to a cell or cells in a column, the column width will remain _____ characters. A. 9.43 B. 11.65 C. 8.43 D. 7.52
8.43
Which of the following calculations multiplies 23 by .01? A. =23 + .01 B. =23% C. =23 D. 24-.01
=23%
Which of the following is the path to the copy and paste buttons? A. (HOME tab | Clipboard group) B. (HOME tab | Formulas group) C. (HOME tab | Copy group) D. (HOME tab | Paste group)
(HOME tab | Clipboard group)
Which of the following is the path to the conditional formatting button? A. (STYLES tab | Formatting group) B. (FORMATTING tab | Styles group) C. (HOME tab | Editing group) D. (HOME tab | Styles group)
(HOME tab | Styles group)
Which of the following is the path to the Zoom button? A. (ZOOM tab | View group) B. ( HOME tab | Zoom group) C. (VIEW tab | Zoom group) D. (INSERT tab | Zoom group)
(VIEW tab | Zoom group)
The _____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell. A. Currency style format B. Comma Style format C. Accounting number format D. Percent style format
Accounting number format
You can click the _____ button to undo an automatic correction. A. Paste Options B. Auto Fill Option C. AutoCorrect Options D. Trace Error
AutoCorrect Options
To copy cell contents, you can select the cell and then press the _____ keys. A. CTRL+ C B. CTRL+ X C. CTRL+ B D. CTRL+ V
CTRL+ C
You can open the format cells dialog box by pressing the _____ keys. A. SHIFT +TAB B. CTRL +1 C. ALT+1 D. SHIFT+F1
CTRL+1
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. ALT B. ENTER C. SHIFT D. CTRL
ENTER
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. Indirect B. Contiguous C. Indexed D. Direct
Indirect
The default view in Excel is called _____ view. A. Basic B. Values C. Standard D. Normal
Normal
When more than one arithmetic operators is involved in a formula, Excel follows the same basic order of _____ that you use in algebra. A. Operations B. Positioning C. Placement D. Selections
Operations
_____ view allows you to create or modify a worksheet while viewing how it will look in printed format. A. Page break preview B. Normal C. Full screen D. Page Layout
Page Layout
You can use the _____ to check which cells are referenced in the formula assigned to the active cell. A. Function Finder B. Range Finder C. Formula Finder D. Calculation Finder
Range Finder