Please Help me answer this Assigment expalined and how you got the numbers! please show details! Thank You!

Usine Encel for key performance indicatora (KP/s) The US Solar Campamy han data for the four divilans far the year, and wants the resuits for the three specified hey perfermance indicators \{KPi3) Always use cell references and formulas where appropriate to receive full credit. If vou copy/paste from the instructions tab you wili be marked wrong. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. 1. Te create a fable lrom the dira: a. Pace the cuncor anwhere in the dati b. Use cTRL-T to comvert data to a table. Conform the data fange for the tatle (Aternatively, vou cas uae insert > table te create a batle) c. The delault table format appears at Click aniwiture in the table to cavie the Table Tooh Denign Tab to appear. 3 Wath the Iable Jobls Design Tab thewing, dirk on the Table Sryles drop down to select another table style. Table Styles is on the right-hand ilde of the tab. 4 Create formulav rounded to three decimal place A. ithe Net Sales cell for Eatt, and click the Enter bey n Excel table will allow you to create the formula once and have it automatically replicate down the rows of the table. An Excel table has a he 1 To create a table from the data: a. Place the cursor anywhere in the data. b. Use CTRL-T to convert data to a table. Confirm the data range for the table. (Alternatively, you can use Insert > Table to create a table.) c. The default table format appears as Click anywhere in the table to cause the Table Tools Design Tab to appear. 2 Rename the table as Solar_KPI. With the Table Tools Design Tab showing, the table name will be on the left-hand side. You must 3 With the Table Tools Design Tab showing, click on the Table Styles drop-down to select another table style. Table Styles is on the ri 4 Create formulas rounded to three decimal places. In the Profit Margin Ratio cell for the East Division, enter the formula by entering the equals sign (=), then click in the Operatin 3 Wht the Table Tools Design Tab thowing click on the Table Styies drop-down to welect another table syle. Table Styles is on the right hand side of the tab. i4 Create formulas rounded to three decimal placet. In the Profit Marein itatio cell for the East Division, enter the formula by entering the ecuals wign (-), then click in the Operatisg ingeme cell for East, add a division sign (A, then click in a. the Not Salet cell for East, and dick the Enter key. stepgerating income]l/6(Net sales]] The ep iymbol is generated automatically, and refers to a row in a table. That is, the Profit Margin itatio for the East Oivision is equal to the Operatine incorne for East, divided by the Net Sales for fast. instead of using cell references, the formula is usine table referencen. Notice that when you press the enter key, the formula is replicated down the column. To round the formula to three decienal places, add the ROUND function to the equation =ROUNDV[[Operatine Income]Me[(Net Soles)] 3) When you update the foemula, the change is automatically replicated down the column Create an Excel table from the data. a Rename the table as Solar kP b. Select Medium 7 table style for the table 2 Use table arithmetic for the formulas (rounded to three decimal places) for a. Profit Margin Ratio b. Asset Turnower Ratio c. Aeturn on lnvestment (ROI) (Always use cell references and formulas where appropriate to receive full credit. If you copv/gaste from the instructions tab you will be marked wrongh. HINTS 1. To insert and edit Excel table refer to Excel Help section on the Instructions tab. 2. Use the function =ROUNDN) to calculate profit margin ratio, asset turnover ratio, and return on investment: table atithmetic for the focmulas (rounded to theee decimal placei) lor a. Profit Marein Fatio b:Asiet Furnover-fatio. - Hirturn on investment (AD) d eit Ericel rable refer to fxcel Help section on the Insiruations lab tion rhOUND() fer calculafe nrofit margin ratio; aspet tur mower ratio, and return oon imestiment