File Home Insert Draw Formulas Data Review View Help ) Calibri (Body) 11 B General A1 1 B C D E Maple Moving Company has provided you their unadjusted account balances to before year-end adjustments. 2 The Controller has asked you to prepare the Adjusted Trial Balance and has provided you with further year-end information. File Home Insert Draw Formulas Data Review View Help A1 B Required: Use the above account balances and the following year end data to determine adjusted account balances and prepare an adjusted trial balance. 28 29 One month of rent used: One month of insurance used: Interest owed but not yet paid: Supplies on hand: Truck depreciation expense Upaid wages earned by employees: Unearned revenue that has been earned: 1,00025010,80015,00035,2003,5002,000 36 37 Here are some tips for using Excel: Cell Reference: 38 Basic Math Functions: Allows you to refer to data from another cell in the worksheet. If you entered "=B5" into a blank cell, the formula would output the value from cell B5. Allow you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add), - (minus sign to subtract), * (asterisk sign to multiply), and / (forward slash to divide). For example, if you entered "=B4+B5" in a blank cell, the formula would add the values from those cells and output the result. SUM Function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges. If you entered "=SUM (C4,C5,C6) " into a blank cell, the formula would output the result of adding those three separate cells. Similarly, if you entered "=SUM(C4:C6)", the formula would output the same result of adding those cells. 41 Note: Use cells A4 to B35 from the given information to complete this question. If nothing belongs in a cell, leave it blank