G N N O Q R Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem and work areas as indicated Prepare the adjusting entry at December 31, and using T-accounts, enter the balances in the accounts, post the adjusting entry, and indicate the adjusted balance in each account. Adjusting entry Date Debit Credit 1 Formula: Subtract; Cell Referencing 2 3 Using Excel to Record Adjusting Entries 4 PROBLEM 5 Lahey Advertising Company's maintains a general ledger 6 account for Supplies. A count on December 31 determined 7 the company has supplies on hand. The following 8 information is from the company's trial balance. 9 10 January 1, Supplies on hand $ 8.800 11 Supplies expense 12 December 31, Supplies on hand 1,100 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 T-accounts Supplies Supplies Expense