Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.image text in transcribedimage text in transcribed

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 Great Value Cabinet Store Balance Sheet As of December 31, 2019 Assets Current Assets Cash Supplies 12963 2231 Total Current Assets Equipment 210000 cal Assets Liabilities and Stockholder's Equity Current Liabilities Accounts Payable Notes Payable Total Current Liabilities 2653 10250 100000 Stockholders' Equity Common Stock Retained Earnings Total Stockholders' Equity 112291 Total Liabilities and Stockholders' Equity

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

CPA Comprehensive Exam Review Auditing And Attestation

Authors: Nathan M. Bisk

43rd Edition

088128095X, 978-0881280951

More Books

Students also viewed these Accounting questions