Hi, this is a student from MIS class. I have problems with those following questions, I cannot figure out what the answer should be of those questions... could anyone help me to get the solutions?

Thanks for any help!

4. We need to determine the taxes owed by the first employee in the Personnel Data table below by consulting the tax rates in the two tables, collectively named TaxRates, and the income brackets in a range named IncomeBrackets. $ 50,000.0015 12 s 9000000 2000% 18 S 140,000.00 30 S 180,000.0038 $ 225 000 00 45 00 10 12.6 15 10 40 00% 20 00 S 50,000.00 10 S 90,000.00 15 140,00000 25 180,000.00 33 $225,000.00 40 17 17 i. Please indicate the range of cells that each of these named ranges should reference TaxRates IncomeBrackets Personnel Data 2 Em 3 Valerie Disabled? FALSE FALSE FALSE nts Annual Income Taxes Owed 01$ 81,350 00 $144,350.00 211,850.00 o 100 95000 2 $ 82,400.00 72,250.00 O 62,025.00 3 82,000.00 40,750.00 1 30,800.00 5 Mark 6 Trevor 7 Jermaine FALSE 9 Maria 10 11 C 2 Sam FALSE FALSE FALSE FALSE