$1.$ Use Excel$$s SUM$()$ function and create formulas in Row $13$ to calculate total items sold for each order source $$ retail, drive$-$thru, and delivery$/$online$.$

$2.$ Assign Cell$/$Range Names

a$.$ Assign cell names for the prices per unit and Cost of Goods Sold $($COGS$)$ for each category.

i$.$ Example, use a range name such as A$\_$price for the avg price per unit for category A items to use in subsequent formulas.

b$.$ Assign a Range name, Cat$\_$prices$\_$cogs, only including the price and GOGS values for each category $($C$17$:E$20$ in current worksheet$).$

$3.$ Using your range names in your formula, add columns and formula to calculate the gross revenues and net dollars sold $($Net $=$ Gross Sales $$ COGS$)$ for each item group.

$4.$ Compare and contrast the formatting of any currency $($$$)$ values in the data table as US currency and as $$accounting$$ formats. How does the $$currency$$ formatting differ from the $$accounting$$ formatting of the values in the spreadsheet?

$5.$ Format the data table appropriately for a business audience.

a$.$ Remove any existing formatting and format the data with the new totals row and columns using Excel$$s $$Format as Table$$ function.

b$.$ Format the summary table containing units and net $s sold by category with headers, shading, and fonts to focus audience attention on the areas with insights to the above business questions.I believe I have done $1$ and $2$A and $2$B correctly.