In the range B$12$:E$12,$ Benicio wants to display a rating depending on the total sales for each quarter. He the rating criteria in the range A$14$:F$15.$ 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 B$12,$ start to enter a formula using the HLOOKUP function.

b$.$ Use the Total Q$1$ sales $($cell B$8)$ as the value to look up$.$

c$.$ Use the Revenue Amts and Rating information $($range $$B$$$14$:$$F$$$15)$ as the table containing the lookup data, using absolute references to specify the range.

d$.$ Specify that row $2$ contains the value you want to return, which is the performance rating.

e$.$ Specify an approximate match $($TRUE$)$ because the Revenue Amts represent ranges of values.

f$.$ Fill the range C$12$:E$12$ with the formula in cell B$12$ to enter ratings for Quarters $2-4.$

Create a formula using a function.

In the All Locations worksheet, the formula in cell B$12$ should use an absolute reference to the values in the range B$14$:F$15$ as the table$\_$array argument.

Copy a formula into a range.

In the All Locations worksheet, cell B$12$ contains an incorrect formula.