please include the formulas that is jessacry for each cell using excell thabk you and will also rate !!!

1 Create ariencel table from the eata. a. fename the table sisolar_xPl. b. Select Wedium ? table strile for the table. 2 Use tabie anthmetic for the formulas (rounded te the ee decimal ciates) fer 4. Frotit Markin fatio b. Asset Turnover Racle c. Return on investment inon) The US Solar Company has data for the four divisions for the year, and wants the results for the three specified key performance indicators (KPIs). Create an Excel table from the data. (3 pts) a. Rename the table as Solar_KPI. b. Select Medium 7 table style for the table. Use table arithmetic for the formulas (rounded to three decimal places) for the following: (12 pts) a. Profit Margin Ratio b. Asset Tumover Ratio c. Return on Investment (ROI) (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.) 4. A 1 . (c) D E hespensibility Accountine asd Ferformance traluation 3 3. 6. 1. 1 9 19 11) (1) 14 11. I Tatel sain