On the Seattle Inventory worksheet, in cell B$5,$ enter a function that will display the average retail price. In cell B$6,$ enter a function that will display the median retail price. In cell B$7,$ enter a function that will calculate the lowest retail price. In cell B$8,$ enter a function that will calculate the highest retail price. Format the range $B5$:$B8$ with Accounting Number Format.

Seattle Facility: Inventory Status of Apparel

As of December $3$I

$3$

$4$ Total Items in Stock

$5$ Average Price

$6$ Median Price

$7$ Lowest Price

$8$ Highest Price

$9$

$10$ Ski Products

II Ski Quantity in Stock

$12$

$\backslash$table$[[13,$Quantity in Stock,Item #$,$Item Name,Retail Price,Category,Sport$],[14,32,115689,$Deluxe Biking Shorts,$69\mathrm{.}52,$Pants,Siking$],[15,78,114568,$Vented Explorer,$34\mathrm{.}78,$Hats,Hiking$],[16,28,456897,$Wicked Heavy Socks,$9\mathrm{.}35,$Socks and Gloves,Skiing$],[17,58,465899,$Gripper Gloves,$25\mathrm{.}55,$Socks and Gloves,Skiing$],[18,57,465888,$Airflow Hat,$2\mathrm{.}99,$Hats,Hiking$],[19,18,165332,$Mini Crew Socks,$6\mathrm{.}45,$Socks and Gloves,Fitness$],[20,,,,,,]]$