Display the Excel workbook Student$\_$Excel$\_$Microsofi$365\_$CH$07\_$New$\_$Feature:xlsx downloaded with this project.

Merge & Center the worksheet title in cell A$1$ in the range A$1$:E$1,$ and then apply the Title cell style.

In row $2,$ select the column titles, apply Center, and then apply the Heading $3$ cell style.

In cell A$12,$ type Third Quarter Sales and then apply the $40\%-$ Accent$1$ cell style to cell A$12.$

Select the range B$3$:D$12$ and then on the Home tab, in the Ediling group, select or press AutoSum to sum the three columns. To the three totals, apply the Total cell style.

Jesse Jewelers pays a quarterty bonus to sales representatives based on the average quarterly sales of each representative as shown in the range A$14$:B$16.$

To compute the Bonus for each sales representative based on their average quarterly sales, you could build a nested If statement as follows:

$=1$F$($AVERACE$($B$3$:B$5)>25000,$"Gold", IF$($AVERAGE$($B$3$:B$5)>=22000,$ "Silver" and so on$.$

However, using that approach would require you to repeat the AVERAGE function three times. Instead, in this formula, you can assign a name to the AVERAGE function and replace the function with the name you assign. By doing so$,$ an average is calculated only one time.

Let's use the name avg to replace the AVERAGE function. Select cell E$3,$ and then type:

$=$ LET$($avg$,$AVERAGE $($B$3$:D$3),$IF$($avg$>25000,$"Gold",IF$($avg$>22000,$"Silver",IF$($avg$>20000,"$ Bronze","NO$\_$BONUS"$))))$

Press ENTER. Your first result, Bronze, displays in cell E$3.$

Copy the formula down through cell E$11.$ Select cell A$1.$

Save and close the file, and then submit for grading.