Question

Can someone help? My professor attached the first picture as an example and the second one is the assignment. I'm very new to excel and she isn't answering since its the weekend so I have no idea what she means with the example.
to center the heading rows 1 - 3 highlight columns A-G then choose Merge & Center Great Value Cabinet Store Balance Sheet As of December 31, 2019 $ Assets Current Assets Cash Supplies Total Current Assets Equipment 12,963 2,231 15,194 210,000 Italicize by highlighting Current Assets and click I in Font group Choose the $ sign in the Number group then click the right arrow in that group twice to get rid of the zeros Choose the "," in the number group and then click the right arrow in that group twice to get rid of the zeros enter the formula = sum(G7:58) Excel will add the numbers in the column for you Total Assets $ 225,194 enter the formula = sum(G9:611) Liabilities and Stockholder's Equity Current Liabilities Accounts Payable Notes Payable Total Current Liabilities $ 2,653 10,250 12,903 Choose the $ sign in the Number group then click the right arrow in that group twice to get rid of the zeros Choose the "," in the number group and then click the right arrow in that group twice to get rid of the zeros enter the formula =sum(G17:618) $ Stockholders' Equity Common Stock Retained Earnings Total Stockholders' Equity 100,000 112,291 212,291 Choose the "," in the number group and then click the right arrow in that group twice to get rid of the zeros Choose the "," in the number group and then click the right arrow in that group twice to get rid of the zeros enter the formula sum(G22:G23) Total Liabilities and Stockholders' Equity $ 225,194 enter G19 + G24

Answer 1

As per the example, you need to complete the balance sheet and apply formulas that have been given in the right side. Just follow the steps as mentioned and you will be able to complete the whole sheet

B E A 1 GREAT VALUE CABINET STORE 2 BALANCE SHEET 3 As of 31 December, 2019 4 5 Assets 6 Current Assets 7 12963 12963 Cash Supplies 8 2231 Total current Assets 15194 9 10 Equipment 11 2231 =+SUM(F7:F8) 210000 210000 12 Total Assets 225194 =+F9+F10 13 14 Liabilities and Stockholder's equity 15 Current Liabilities 16 2653 2653 Accounts payable Notes payable 17 10250 10250 18 Total current liab 12903 =+F16+F17 19 20 Stockholder's equity 21 22 23 Total stockholdr's equity 24 25 Total Liabilities and Stockholder's equity Common stock Retained earnings 100000 112291 212291 100000 112291 =+SUM(F21:F22) 225194 =+F18+F23 IN boottoc chant 100 be +1 10 Choot 111 not11 chaottt bet boot11 bo+1