Which of the following characters always starts a formula?
=
(
$
@
If the formula in cell D10 is =D8+D9+D10. Which of the following terms describes the error?
value error
numeric error
circular reference error
reference error
Which of the following has an answer of 11?
2+4*3
(2+4)*3
3+2*4
(2+3)*4
Which of the following mathematical operations is performed last?
exponent
multiplication
parenthesis
subtraction
Which of the following functions counts cells that contain any data type within a range?
COUNTA
COUNTBLANK
COUNTIF
DCOUNT
Which of the following occurs when a formula includes the cell address of a formula?
absolute reference
relative reference
circular reference
mixed reference
Which of the following options is not used to copy a formula with a relative reference?
Use the Copy button on the Home tab.
Press F2.
Press Ctrl+C.
Click and drag the Fill pointer if the copies are adjacent to the original formula(s).
Which of the following is the constant in the formula =D5*85%?
D5
*
85%
Which of the following functions displays a value from a range of cells located in another area of the workbook?
PMT
IF
LOOKUP
ROUND
Which of the following cell addresses will change when it is copied?
F2
$F$2
$F2
F$2
Which of the following has an answer of 14?
Which of the following shows the correct syntax for the ROUND function?
=ROUND(num_digits)
=ROUND(number)
=ROUND(num_digits,number)
=ROUND(number,num_digits)
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 Precedents
Trace Dependents
Error Checking
Evaluate Formula
Which of the following functions counts the cells that contain values within a range?
AVERAGE
COUNT
MAX
MIN
Which of the following functions uses a lookup table that is organized in columns?
HLOOKUP
VLOOKUP
HVLOOKUP
Which of the following has an answer of 4?
10-(3*2)
(10-3)*2
10-4/2
(10-4)/2
Which of the following functions finds the largest value in a range?
Which of the following functions calculates a constant loan payment amount for a period of time at a stated interest rate?
NPER
Which of the following functions combines the SUM function with the logical criteria component of the IF function?
SUMIF
SUMPRODUCT
Which of the following is a relative cell reference?
B2
$B$2
B$2
Sheet2!B2
