In an Excel workbook, spreadsheet 1 contains a listing of names, social security numbers, and taxable income for wage earners. An income tax table is on spreadsheet 2 in the same workbook. A tax accountant would like to write a formula to look up the correct income tax amount in spreadsheet 2 using the taxable income amount in spreadsheet 1. What formula can they use to do so? O a. XLOOKUP O b. CHOOSE OC. MATCH O d. RTD

In an Exrel workbook, spreadsheet 1 contains a listing of names, social security mumbers, and tavable income for wage earnern. An income tax table is on speadsheet 2 in the same workbook. A tax acoountant would hike to write a formuls to look up the correct income tax amount in spreadsheet 2 using the taxable income amorint in spreadsheet 1 . What formula can they use to do so? a. XLOOKUP b. CHOOSE c. MATCH d. RTD