Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

EXCEL PROJECT 15E [Protected View] - Excel Unlicensed Product Cislum - File Home Incent Page your Fermules Beiru Viru Hels Tell me what ynu want

image text in transcribed

EXCEL PROJECT 15E [Protected View] - Excel Unlicensed Product Cislum - File Home Incent Page your Fermules Beiru Viru Hels Tell me what ynu want to do PROTECTED VIFW Recarefulfiles from the Internet can contain vies. Inless you need to cit, it's water to stay in Protected View. NOTICE Mont fratres are disabled because your Office product is inactive. To use for free sign in and the Webwin Frable Fating Artiste Loe freet Office.com L M N 0 P P S 1 U w X Y A1 2 EXCEL PROJECI A . 1 1 K 1 EXCEL PROJECT 2 FINANCIAL ACCOUNTING 3 Nama 4 5 Instructions. The worksheel and the firenc alatements Heleen etaited and outlined Where you see the word 6 "FORMULA". Uslis were formule should be typed in. Csal AR in 8 13 and 14 ha teen 7 done for you as an example. Sumetimes the formula is just bringing a number over to the next ales in that case 8 type - followed by the cel number it was in before click on cell F13 to see the fomu a used there. Other times you 9 may have to add or subtract (see the formua in cel F14) When you are adding more than two numbers, use the 10 sum form.la. Complete and save. 11 12 Trial Balance Adjustments Ad. Trial Balance Income Statement Balance Sheet 131 Debit Credit Debt Credit Debit Credit Debit Credit Debit Credit 14 Cash 500D 5.000 5.000 15 AR 1 OUD 1003 2 COU 2000 16 Supplies SUD 200 FORMULA an FORMULA 17 FP Rant 200 100 FORMULA FORMULA 18 FP IS TANCA 300 150 FORMULA FORMULA 19 OTICE 1 500 FORMULA FORMULA 20 Accum Cep 200 2001 FORMULA FORMULA 21 Ar 500 FORMULA FORMULA 22 Salaries 400 FORMULA FORMULA 23 Uneamed Fees 1,200 1000 FORMULA FORMULA 24 Retained Eamings 2.000 FORMULA FORMULA 25 Common Stock 3.000 FORMULA FORMULA 20 Cmdends 600 FORMULA FORMULA 27 Fees Larned 3.000 20001 FORMULA FORMULA 20 Salery Exp 200 TORMULA FORMULA 29 Rent Exp 400 100 FORMULA FORMULA 30 Supplies Lxp U 2001 FORMULA FORMULA 31 cep Exp 0 200 FORMULA FORMULA 3 Insurance Exp 0 150 FORMULA FORMULA 33 Mike Exp 300 FORMULA FORMULA 34 36 Total 10,300 10.300 2.770 2.770 FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA 36 Net Income FORMULAI FORMULA 37 Total FORMULA FORMULA FORMULA FORMULA 39 39 40 * Cucte Consulting 41 Income Statement 42 For month orded June 30, 200x Instructions: 43 Use = followed by the call number where 44 F Farned FORMULA last appeared in the worksheet to bring numbers 45 Operating Fxpans down Cal C51 wil naad Anmomile adding 16 Baley Exp FORMULA al expenses CH 052 wil need Sheet1 Shetta Sheet3 100% Type here to search O 24 1:33 PM 9/25/20120 13

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

Students also viewed these Accounting questions