Format the data as follows:

a$.$ Apply the Title cell style to cell $A1.$

b Apply the Blue fill color to cell A$1.$ Use t$/$h third color from the right in the row of Standard colors.

c$.$ Apply the White, Background $1$ font color to cell A$1.$ 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$.$ Apply the Heading $1$ cell style to cell B$2.$

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

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

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

i$.$ Autofit columns A:E$.$

Calculate total sales for each of the truck locations.

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