Question

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

Answer 1

Formulaes to be put are -

А B с D E F H J K L 1 G EXCEL PROJECT FINANCIAL ACCOUNTING 2 Income Statement Credit Balance Sheet Credit Debit Debit =F14 =F15 |=F16 =F17 =F18 =F19 3 Name 4 5 6 7 8 9 10 11 12 13 14 Cash 15 AR 16 Supplies 17 PP Rent 18 PP Insurance 19 Office Equipment 20 Accum Dep. 21 AP 22 Salaries Pay. 23 Unearned Fees 24 Retained Earnings 25 Common Stock 26 Dividends 27 Fees Earned 28 Salary Exp. 29 Rent Exp. 30 Sipplies Exp. 31 Dep. Exp 32 Insurance Exp 33 Misc. Exp 34 35 36 Net Income 37 Total 38 Trial Balance Adjustment Adj. Trial Balance Debit Credit Debit Credit Debit Credit 5000 =B14 1000 1000 =B15+D15 500 200 =B16-E16 200 100 =B17-E17 300 150 =B18-E18 1500 =B19 200 200 =C20+E20 500 =C21 400 120 =C224E22 1200 1000 =C23-E23 2000 =C24 3000 =C25 600 =B26 3000 2000 1=C27+E27 500 120 =B28+028 400 100 =B29+D29 0 200 =B30+D30 0 200 =B31+D31 0 150 =B32D32 300 =B33 =G20 =G21 =G22 =G23 =G24 =G25 =F26 =G27 =F28 =F29 =F30 =F31 =F32 =F33 10300 10300 2770 2770 -SUM(F14:F33) =SUM(G14:G33) =SUM(H14:H33) =SUM(114:133) =SUM(J14:33) =SUM(K14:33) =135-H35 =H36 =H35+H36 =135 = 235 =K35+K36 Excel sort Excel IF Excelif, AND OR Excel type Excel pivot Sheet1 +

Value/Figures after putting formulaes are -

A G H J K L 1 B C D E F EXCEL PROJECT FINANCIAL ACCOUNTING 2 3 Name 4 5 6 7 9 10 11 12 13 14 Cash 15 AR 16 Supplies 17 PP Rent 18 PP Insurance 19 Office Equipment 20 Accum Dep. 21 AP 22 Salaries Pay. 23 Unearned Fees 24 Retained Earnings 25 Common Stock 26 Dividends 27 Fees Earned 28 Salary Exp. 29 Rent Exp. 30 Sipplies Exp. 31 Dep. Exp 32 Insurance Exp 33 Misc. Exp 34 35 36 Net Income 37 Total 38 Trial Balance Adjustment Adj. Trial Balancebome StatemBalance Sheet Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit 5000 5000 5000 1000 1000 2000 2000 500 200 300 300 200 100 100 100 300 150 150 150 1500 1500 1500 200 200 400 400 500 500 500 400 120 520 520 1200 1000 1200 1200 2000 2000 2000 3000 3000 3000 600 600 600 3000 2000 5000 5000 500 120 620 620 400 100 500 500 0 200 200 200 0 200 200 200 0 150 150 150 300 300 300 10300 10300 2770 2770 11620 12620 1970 5000 9650 7620 3030 3030 5000 5000 9650 10650

.