Excel Mod 2 Quiz
When Excel follows the order of operations, the formula, 8*3+2 equals _____. a. 48 b. 13 c. 26 d. 40
26
A _____ is text and graphics that print at the bottom of every page. a. footer b. toe c. margin d. stopper
Footer
A _____ is text and graphics that print at the top of each page. a. crown b. margin c. header d. topper
Header
All of the following are valid Excel arithmetic operations EXCEPT _____. a. * b. > c. % d. ^
I think it is %...
The _____function displays the highest value in range. a. MIN b. AVERAGE c. SUM d. MAX
MAX
The _____ function determines the lowest number in a range. a. LOW b. MIN c. LEAST d. BASE
MIN
The adjusted cell references in a copied and pasted formula are called _____ cell references. a. alternative b. relative c. pasted d. related
relative
When you decrease the row height to _____, the row is hidden. a. 0 b. 1 c. 2 d. 3
0
A _____ is a prewritten formula that is built into Excel. a. function b. feature c. calculation d. task
function
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. 7.52 c. 11.65 d. 8.43
8.43
Which of the following calculations multiplies 23 by 0.01? a. =24-.01 b. =23 c. =23% d. =23+.01
=23%
The _____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range. a. AVERAGE b. DIVSUM c. RANGEAVG d. MAX
AVERAGE
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. Percent style format c. Comma style format d. Accounting number format
Accounting number format
Which of the following Option buttons gives options for filling cells following a fill operation? a. insert options b. paste options c. auto fill options d. auto correct options
Auto Fill Options
You can click the _____ button to undo an automatic correction. a. Auto Fill options b. Paste Options c. AutoCorrect Options d. Trace Error
AutoCorrect Options
A(n) _____ circular reference occurs with a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell. a. direct b. indirect c. contiguous d. indexed
Indirect
The default view in Excel is called _____ view. a. Standard b. Values c. Normal d. Basic
Normal
_____ view allows you to create or modify a worksheet while viewing how it will look in printed format. a. Page Layout b. Full Screen c. Page Break Preview d. Normal
Page Layout
You can use the _____ to check which cells are referenced in the formula assigned to the active cell. a. Function Finder b. Formula Finder c. Calculation Finder d. Range Finder
Range Finder
Excel automatically appends the _____ to complete the AVERAGE function when you click the Enter box or press the ENTER key. a. right bracket b. right parenthesis c. left bracket d. left parenthesis
Right parenthesis