Question

a$.$ Which product SKU has the highest gross margin? $($Hint: Use $=$MAX$()$ Excel function to calculate.$)$

b$.$ Which product has the highest gross margin percentage? $($Hint: Use $=$ MAX$()$ Excel function to calculate.$)$

c$.$ Which product has the lowest gross margin? $($Hint: Use $=$MIN$()$ Excel function to calculate.$)$

d$.$ What is the gross margin percentage of the product SKU and description with the lowest gross margin percentage? $($Hint: Use $=$MIN$()$ Excel function to calculate.$)$

e$.$ What is the average gross margin percentage? $($Hint: Use $=$AVERAGE$()$ Excel function to calculate.$)$

e$.$ What is the median gross margin percentage? $($Hint: Use $=$MEDIAN$()$ Excel function to calculate.$)$