Format the data as follows:

a$.$ Apply the Accent$1$ cell style to cell A$1.$

b$.$ Apply the Light Green fill color to cell B$2.$ Use the fifth color from the left in the row of Standard colors.

c$.$ Apply the White, Background $1$ font color to cell B$2.$ Use the first color at the left in the first row of Theme colors.

d$.$ Merge and center the worksheet title across cells A$1$:E$1.$

e$.$ Merge and center cells B$2$:E$2.$

f$.$ Bold cells B$3$:E$3.$

g$.$ Apply the Accounting Number Format with $0$ digits after the decimal to cells B$4$:E$6.$

h$.$ AutoFit columns A:E$.$

Calculate total sales for each of the truck locations.

a$.$ Enter the word Total in cell A$7.$

b$.$ Enter a SUM function in cell B$7$ to calculate the total of cells B$4$:B$6.$

c$.$ Use AutoFill to copy the formula to cells C$7$:E$7.$

d$.$ Apply the Total cell style to cells A$7$:E$7.$

Insert a pie chart $(2-$D Pie$)$ to show the Old Bay sales for the month by location. Each piece of the pie should represent the Old Bay sales for a single location.

Note: You must complete this step correctly in order to receive points for completing the next step. Check your work carefully.

Modify the pie chart as follows:

a$.$ Apply the Layout $6$ Quick Layout.

Reset Progress

b$.$ Move the chart so it appears below the sales data.