Excel 2 Quiz
Which of the following is an absolute cell reference?
$B$2
Which of the following provides an example of a mixed reference and a relative reference?
$D21+E21
Which of the following cell addresses does not change when copied?
$F$2
Which of the following cell addresses contains a column reference that is absolute and a row reference that will change when copied?
$F2
Which of the following is a valid 3D cell reference?
'Inventory#'!$B2
Which of the following reference cells located in another worksheet in the same workbook?
3D cell reference
Which of the following is the constant in the formula =D5*85%?
85%
Which of the following characters always starts a formula?
=
Which of the following includes an absolute reference and a constant?
=$D$21+21
Which of the following formulas includes only relative references?
=D21+E21
Which of the following formulas correctly adds the values in cells E4 and E5?
=E4+E5
Which of the following shows the correct syntax for the IF function?
=IF(C5<=20,7,10)
which of the following shows the correct syntax for the ROUND function?
=ROUND(number,num_digits)
Which of the following functions adds all the values and divides the result by the number of values?
AVERAGE
Which of the following options enables you to assign a name to existing formulas that refer to the cells identified in range names?
Apply names command
Which of the following features displays mathematical results such as SUM, AVERAGE, and COUNT on the status bar for selected cells?
AutoCalculate
Which of the following is a mixed cell reference?
B$2
Which of the following is a relative cell reference?
B2
Which of the following functions counts cells that meet the criteria arguments within a range?
COUNTIF
Which of the following occurs when a formula includes the cell address of a formula?
Circular references
Which of the following keystroke combos completes a formula?
Ctrl+Enter
Which of the following tools steps through each part of a formula and displays an outcome for each part so that an error can be isolated?
Evaluate Formula
Which of the following cell addresses will change when it is copied?
F2
Once you have selected a cell address, which of the following keys inserts dollar signs quickly?
F4
Which of the following functions evaluates a specified condition and returns one value if the condition is True and another value if the condition is False?
IF
Which of the following functions finds the largest value in a range?
MAX
Which of the following statements about circular references is false?
NOT*** when you open a workbook w a circular reference, you will see a message box.
Which of the following functions can be formatted to show the current date?
NOW
Which of the following is true about the TODAY and NOW functions?
No arguments are required
Which of the following functions calculates a constant loan payment amount for a period of time at a stated interest rate?
PMT
Which of the following functions adjusts a value to a specified number of decimal places or whole number?
ROUND
Which of the following is a color-coded editing tool that applies different colors to each cell range within a formula?
Range finder
Which of the following functions combines the SUM function with the logical criteria component of the IF function?
SUMIF
Which of the following functions multiples the cells identified in its array arguments and then total those individual products?
SUMPRODUCT
Which of the following mathematical operations is preformed last?
Subtraction
Which of the following statements about arrays is false?
The max number of arrays in a formula is two
Which of the following formula auditing tools displays lines with arrows to identify all cells referenced in the formula in the active cell?
Trace Precedents
Which of the following formula auditing tools displays lines with arrows to all cells that use the active cell directly or indirectly in a formula/
Trace dependents
To cancel a formula before it is complete, press esc.
True
Which of the following functions uses a lookup table that is organized in columns?
VLOOKUP
If the formula in cell D10 is =D8+D9+D10, which of the following terms describes the error?
circular reference error
Which of the following contains one relative reference (either the row number or column letter) and one absolute reference (the remaining row number or column letter)?
mixed reference
Which of the following criteria sums sales for all items that begin with the letter P?
p*
