please provide the excel functions when giving the answer.

AB Formula: Subtract; Cell Referencing K L M N Using Excel to Record Adjusting Entries PROBLEM Lahey Advertising Company's maintains a general ledger account for Supplies. A count on December 31 determined the company has supplies on hand. The following information is rom the company's trial balance January 1, Supplies on hand $ 8.800 Supplies expense December 31, Supplies on hand 1,100 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 12/31 Supplies Expense Supplies Debit 7,700 Credit 27700 T-accounts 21 Supplies 3.800 12/31 1.100 12/31 7,200 Supplies Expense 3.300 12/31B 8.800