5. In the range B12:E12, Benicio wants to display a rating depending on the total sales for each quarter. He listed the rating criteria in the range A14:F15. For example, if total sales in Quarter 1 are between $5900 and $5999, the Performance rating is Good. Enter the performance ratings as follows: a. In cell B12, start to enter a formula using the HLOOKUP function.

Trey morgan is an employee who is paid monthly. for the month of january of the current year, he earned a total of $4,538. the fica tax for social security is 6.2% of the first $118,500 earned each calendar year, and the fica tax rate for medicare is 1.45% of all earnings for both the employee and the employer. the amount of federal income tax withheld from his earnings was $680.70. his net pay for the month is .