Question 17: A payroll register should be created for each pay period.

1. True
2. False

Question 18: Which of these is an optional argument in the HLOOKUP function?

1. Lookup value
2. Table array
3. Column index number
4. Range lookup

Question 19: A defined name can be assigned in the Name box.

1. True
2. False

Question 20: Which of these best describes the purpose of a lookup function?

1. To combine multiple entries in other cells of the worksheet
2. To retrieve a piece of data from a table
3. To modify a formula in an adjacent cell
4. To correct a previously incomplete formula in the worksheet

Question 21: Which of these is a nested function?

1. =IF(A4>2, 43, IF(B7=2, 86, 0))
2. =SUM(B6:B14)-SUM(C6:C14)
3. =AVERAGE(A6:C6, B12)
4. =MAX(A1:A30)+MIN(B1:B28)

Question 22: All fifty states collect state income tax.

1. True
2. False