Question: For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells,



For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. Example: =B3+C3 Lantana Company has provided you with the transactions that occurred during its first month of operations. The Controller has already recorded the transactions to the T.Accounts and has asked you to prepare the classified balance sheet based on the T-Account balances. 45 Required: 46 Using the T-account BALANCES and the information in the transactions, prepare a classified balance sheet for Lantana Company. 48 Here are some tips for using Excel: If you entered "mSUM(C4,CS,C6)" into a blank cell, the formula would output the result of adding those three separate cells. Similarly, if you entered "=\$UM(C4:C6)", the formula would output the same result of adding those cells. Note: Use cell references to the T-account titles to complete columns B and G. Use cell references to the T-account balances 53 and formulas to complete columns C and H. 54 55 56 LANTANA COMPANY Balance Sheet Note: Use cell references to the T-account titles to complete columns B and G. Use cell references to the T-account balances and formulas to complete columns C and H
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
