Question 7: What is displayed when the range lookup in a lookup function is False and an exact match cannot be located in the table array?

1. Zero
2. #DIV/0!
3. #N/A
4. A blank space

Question 8: The table array in a lookup function must include a defined name.

1. True
2. False

Question 9: A cell reference cannot be included in a defined name.

1. True
2. False

Question 10: Which of these would not appear in the Deduction section of the payroll register?

1. Social security tax
2. Medicare tax
3. Gross pay
4. Federal withholding tax

Question 11: What is displayed in the final column of the payroll register?

1. Net pay
2. Gross pay
3. Regular hours worked
4. Medicare tax