add gradient fill blue data bars to the range a$14$:a$19$ add conditional formatting to the range g$14$:g$19$ so that the cells witj text hat contain the word order are formatted with bold and italic sort the table by item # from smallest to largest $14$ Add Gradient Fill Blue Data Bars to the range A$14$:A$19/$ Add conditional formatting to the range G$14$:G$19$ so that the cells with text that contain the word Order are formatted with Bold and Italic. Sort the table by Item # from Smallest to Largest. $15$ Display the Inventory Summary sheet. In cell B$4,$ enter a formula that references cell B$4$ in the Seattle Inventory sheet so that the Seattle Total Items in Stock displays in cell B$4.$ In cell B$5,$ enter a formula that references cell B$5$ in the Seattle Inventory sheet so that the Seattle Average Price displays in cell B$5.$ In cells B$6,$ B$7,$ and B$8,$ enter similar formulas to reference the Median Price, Lowest Price, and Highest price in the Seattle Inventory sheet. $16$ In cell C$4,$ enter a formula that references cell B$4$ in the Denver Inventory sheet so that the Denver Total Items in Stock displays in cell C$4.$ In cells C$5,$ C$6,$ C$7,$ and C$8,$ enter similar formulas to reference the Average Price, Median Price, Lowest Price, and Highest price in the Denver Inventory sheet. Apply Accounting Number format to the range B$5$:C$8.$Seattle Facility: Inventory Status of AppareI As of December $31$ otal Items in Stock $271$ Iverage Price $ $24\mathrm{.}77$ Tedian Price $ $17\mathrm{.}45$ owest Price $ $2\mathrm{.}99$ Highest Price $ $69\mathrm{.}52$