Question: Show me the steps to solve pplying Excel 1 : Calculating total equity A spreadsheet has 3 columns and 1 9 rows. The spreadsheet has

Show me the steps to solve pplying Excel 1: Calculating total equity
A spreadsheet has 3 columns and 19 rows. The spreadsheet has a two-line heading for Trail Balance in rows 1 and 2, with columns 1 to 3 merged. Row 3 is titled Debit and Credit in columns 2 and 3, respectively. Column 1 lists account names in rows 4 to 18, without a header. Column 2 lists dollar amounts in rows 4 to 8,12, and 15 to 18. Column 3 lists dollar amounts in rows 9 to 11,13,14, and 18.
Which formula does NOT correctly calculate total equity?
Multiple Choice
=+C11+C13+C14-B12-B15-B16-B17
=+B4+B5+B6+B7+B8-C9-C10
=+C13+C14+C11-B15-B16-B17
=SUM(B4:B8)-SUM(C9:C10)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!