Enter

albert.luna@cengage.com in cell D$5.$ Select the range D$5$:D$16,$ and then use the Flash Fill button $($using the Fill drop$-$down arrow in the Editing group on the Home tab$)$ to automatically enter codes into the remaining cells in the range. $($Hint: You must use the Flash Fill button to properly receive credit for this step.$)$

Change the width of column D to $36\mathrm{.}00.$

Enter the word Total in cell A$17.$

In cell B$17,$ create a formula using the SUM function to determine the total salary paid by Tabula Insurance Agency by totaling the values in the range B$5$:B$16.$ Copy the formula you created in cell B$17$ to cell C$17.$