A$.$ Datum CorporationTech$4$ Adventure WorksTravel$5$ Blue Yonder AirlinesTraveloCy rower& wentUtilities$7$ Coho VineyardBeverage$8$ Contoso, LtdMisc$9$ Contoso Pharmaceuticals$10$ Consolidated MessengerMedical$11$ Fabrikam, Inc.Tech$12$ Fourth CoffeeUtilities beverage$13$ Graphic Design InstituteEducation$14$ Humongous Insurance$15$ Litware, Inc.Financial$16$ Lucerne PublishingTechMISC$17$ Margie's TravelTravel$1954491431211934763299293228783239219311570579825639630876740788390682545902264905906289570$XYZ Company$02$ Sales$03$ Sales$746907733396|621219246554|607929355179674295251962659385287989580453287714644368419728448359434008635474512745567216540282620646|627910577599716073$LU$0551443552679940843834290953671833$Total Sales for XYZ CompanyUsing thGCF vid$22$ Inserta new row $1.$ Name it XYZ Company$\mathrm{.}23$ Merge and Center row $1$ cell A $1$ through cell i$\mathrm{.}24$ Make background color in some shade of blue for row $1($make sure you can see the text$)\mathrm{.}25$ Change the font size and and type$\mathrm{.}26$ Wrap textin cells F$2$ and $12\mathrm{.}27$ Format value $($cells with numbers$)$ cells to Accounting, no decimals$\mathrm{.}28$ Insert a function to add the Q$1,$ Q$2,$ and Q$3$ sales under Total Sales$\mathrm{.}29$ In D$18$ and D$19,$ type MIN and MAX respectively. In column E$,$ use a function to show the MIN and MAX sales for Q$3./30$ In G$2,$ type Company Commission $($wrap text $-$ adjust cell width if necessary$).$ Then, in A$19$ type Commission Rate and in B$19$ type $\mathrm{.}02\mathrm{.}31$ Using the information in Total Sales and the commission in B$19,$ calculate the commission amount in column G$.$Be sure to use ABSOLUTE VALUE$\mathrm{.}33$ In cell $12,$ type Subtraction Column. Then, in $13($and subsequent rows$)$ subtract the $3$rd quarter from the Total Sales.$**$Example $-$ when you ear $$100$ this week and have $$65$ in expenses, you subtract the expenses from the eamings to know how much you have left to spend on fun things. It is the same as taking Eamings $-$ Expenses$\mathrm{.}36$ In your Documents folder, save the file as Your Name $-$ Excel.