Question 6: What is displayed in the final column of the payroll register? Answer: A. Net Pay B. Gross Pay C. Regular Hours Worked D. Medicare Tax Question 7: What is NOT allowed in a defined name? Answer: A. Text B. Number C. Underscore D. Space Question 8: Which argument is optional for the HLOOKUP function? Answer: A. Lookup value B. Table array C. Column index number D. Range lookup Question 9: Which cell shown here displays an absolute cell reference? Question 9: Which cell shown here displays an absolute cell reference? Question 10: What does NOT appear in the Deduction section of the payroll register? Answer: A. Social Security tax B. Medicare tax C. Gross pay D. Federal withholding tax