Answer fast please !
6 9 1 Harriet Tubman Company 2 Balance Sheet 3 December 31 4 Assets 5 Current assets Cash $20,700 7 Short-term investments 15,700 B Accounts receivable net 29,000 Supplies 7,300 10 Prepaid expenses 5,800 11 Total current assets $78,500 12 Long-term investments 13 Long-term notes receivable $ 33,000 14 Investments in stocks and bonds 26,000 15 Total long-term investments 59.000 16 Plant assets 17 Equipment 46,800 18 Accumulated Depreciation (9,400) 19 Equipment, net 37 400 Land 37,000 21 Total plant assets 74,400 22 Intangible assets 23 Copyrights 8,000 24 Total assets $219.900 Which formula in cell F11 would NOT accurately compute the value of total current assets? 20 - Multiple Choice =-F6+F7-F8-F9-F10 =SUM(F6 F10) =SUMF6 F10) N -F24-F23-F21-F15 2 Applying Excel 4: Total Current Assets 1 point book Wences D E A Harriet Tubman Company 1 Balance Sheet 3 December 31 Assets 4 5 Current assets $20.700 Cash Short-term investments 15700 Accounts receivable net 29 000 9 Supplies 7.300 10 Prepaid expenses 5,800 11 Total current assets $78,500 12 Long term investments 13 Long-term notes receivable $ 33 000 Investments in socks and bonds 25,000 Total long-term investments 59.000 16 Plant assets 17 Equipment 48 800 1 Accumulated Depreciation 19 Equipment ne 9.400) 20 Land 37 400 21 Total plant assets 37 000 Intangible assets 74.400 Cornight Total assets 8 000 Which formula in cell Fit would NOT accurately compute the value of total current assets? $219.900 Deferences Muhiple Choice O --F6-F7-F8-F9-F10 O =SUMF6 F10 SUMF6F10) F24F23-F2-F15 3 Applying Excel 4: Total Plant Assets E A 1 1 D Harriet Tubman Company Balance Sheet December 31 Assets 2 3 hoe Pire 9 References 4 $20,700 5 Current assets Cash 15.700 6 7 Short-term investments 29,000 8 Accounts receivable, nel 7300 Supplies 5,800 10 Prepaid expenses $78,500 11 Total current assets 12 Long-term investments 13 Long-term notes receivable 33,000 14 Investments in stocks and bonds 26.000 15 Total long-term investments 59,000 16 Plant assets 17 Equipment 46,800 Accumulated Depreciation (9.400) 19 Equipment, net 37,400 20 Land 37,000 21 Total plant assets 22 Intangible assets 74.400 23 Copyrights 24 Total assets 8,000 Which formula in cell F21 accurately computes the value of total plant assets? $219.900 10 Multiple Choice +E17.E18-F19 SUM(E17E18.F20 -SUME17.E18. F19) -E17-E18-F20 4. Applying Excel 4: Total Assets A Book Print rences E D Harriet Tubman Company 1 Balance Sheet 2 December 31 3 Assets 4 3 Current assets $20,700 6 Cash 15,700 7 Short-term investments 29,000 8 Accounts receivable net 9 Supplies 7,300 10 Prepaid expenses. 5,800 11 Total current assets $78,500 12 Long term investments 13 Long-term notes receivable $ 33,000 14 Investments in stocks and bonds 26,000 15 Total long-term investments 59,000 16 Plant assets 17 Equipment 46 800 18 Accumulated Depreciation (9,400) 19 Equipment, net 20 Land 37400 21 Total plant assets 37,000 22 Intangible assets 74.400 23 Copyrights 24 Total assets 8,000 Which formula in cell F24 DOES NOT accurately compute the value of total assets? $219.900 1 Multiple Choice O --F6-F7-F8-F9-F10-E13-E14-E17E18-F20-F23 --F1-F15-17-18-F23 -F1-F15-F21+F23 -F11-F15-17-18-F20-F23 5 Applying Excel 4: Total Revenues A D E Harriet Tubman Company Income Statement For the Year Ended December 31 73 74 75 70 17 78 79 30 69,600 3,500 $ 73,100 Revenues Services revenue Interest revenue Total revenues Expenses Salaries expense Rent expense Miscellaneous expenses Depreciation expense Total expenses Net income $ 0 27 800 8.400 5,570 4680 46.450 26,650 Which formula in cell F79 will remain accurate if a new row is inserted between rows 77 and 78? Multiple Choice O E77-E78 SUME77,E78) SUME77F79) SUME71 E78) 6 Applying Excel 4: Net income 1 74 75 76 77 78 boo C D E Harriet Tubman Company Income Statement For the Year Ended December 31 Revenues Services revenue $ 69,600 Interest revenue 3500 Total revenues $ Expenses Salaries expense $ 27 800 Rent expense 8.400 Miscellaneous expenses 5570 Depreciation expense 4,680 Total expenses Net income $ 73.100 80 1 32 33 Weferences 46,450 26,650 Which formula in cell F86 does NOT accurately compute net income? Multiple Choice SUM[E71 E78-SUM[E81 E84) =SUMET7 E78) SUME81 E84) O -F79-F85 --F79 SUME81 E84
