Excel Ch 7
Which of these represents an absolute cell reference? $D$7 D7 $D7 D$7
$D$7
How will the mixed cell reference $H8 appear in the new cell if the formula containing the cell reference is dragged one cell to the right? $H9 $G8 $H8 $G9
$H8
What CANNOT be entered in the num_digits argument of the ROUND function? The number zero A text entry A positive number A negative number
A text entry
The VLOOKUP and HLOOKUP functions must be used together to work properly
F
The Value_If_False argument is optional in the IF function.
F
When a formula is copied, any absolute cell reference in it will change based on the distance between the original and the copied formula.
F
What is entered in the range lookup argument of the VLOOKUP function to require an exact match in the lookup table? FALSE EXACT TRUE " " (a blank space
FALSE
. The IF function is found in the _____ category of the Insert Function dialog box. Logical Statistical Math & Trig Financial
Logical
What is the final column in the payroll register? Regular Hours Check Number Total Earnings Net Pay
Net Pay
Which of these is NOT an argument within the IF function? Value_If_True Logical_Test Number Value_If_False
Number
Which of these does NOT appear in a standard payroll register? Net Pay Overtime Hours Worked Pay Date State Withholding Allowances
State Withholding Allowances
A mixed cell reference contains a dollar sign in front of the column or row reference, but not both.
T
A nested IF function contains at least two standard IF functions.
T
The Logical_Test must be entered as the first argument in an IF function
T
The ROUND function requires the insertion of two arguments in a formula.
T
The lookup table must be established before the HLOOKUP function can provide a result.
T
The range lookup argument in the VLOOKUP function is optional.
T
You can use [F4] to toggle the dollar sign in front of one, both, or no column/row references in a cell reference
T
Which statement is accurate for when the range lookup argument in the VLOOKUP function is TRUE? The second column of the table array must be sorted from lowest to highest. The second column of the table array must be sorted from highest to lowest. The first column of the table array must be sorted from lowest to highest The first column of the table array must be sorted from highest to lowest.
The first column of the table array must be sorted from lowest to highest
Which of these is NOT an argument in the VLOOKUP function? lookup value logical test table array column index number
logical test
