$1.$ In the range B$12$:E$12,$ Fiona wants you to display a rating depending on the total sales for each quarter. She listed 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 XLOOKUP function.

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

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

d$.$Specify an exact match or next smaller item $(-1)$ as the match mode.

e$.$Fill the range C$12$:E$12$ with the formula in cell B$12$ to enter ratings for Quarters $24.$