Please help me understand the above step.

Offered Price: $ 15.00 Posted on: 05/17/2019 11:20 PM Due on: 05/24/2019
Question # 00724848 Subject Computer Science Topic General Computer Science Tutorials: 0
Question Purchase it

I'm having problem with the following step it is in Module 3 Performing Calculations with Formulas and Functions The text book is New Perspectives Microsoft Office 365 & amp: Excel 2016: Comprehensive: Pages Ex183

The instructions states in cell B17, calculate the amount of federal tax by multiplying the Total Pay value in cell B14 by the appropriate federal tax rate for an employee with the martial status in cell B7 and withholding allowances in cell B9. (Hint: Use the VLOOKUP function with an exact match lookup for the table in the range L6:W8. For the Col_index_num argument, use the value of cell B9 plus 2.