Using the Final$-$Exam$-$Excel$-$Your name.xlsm

In Tab $"$Q$1-$D$"$ format the two columns' values as numbers with $2$ decimal places and after the blank line Calculate:

Total Sales for Sales and COGS for Year $4$

Lower Sales for Sales and COGS for Year $4$

How many Sales $>200000$ for Sales and COGS for Year $4$

Write a label in the highlighted blue of Column B and formulas in columns C and D