Cell Referencing

Using Excel to Record Adjusting Entries

PROBLEM

The bookkeeper for Tran Company asks you to prepare three accrual adjusting entries at December $31.$

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Use cell references to respective account names and amounts in the Problem area.

a$.$ Interest on notes payable should be accrued

b$.$ Services performed but unbilled

c$.$ Salaries earned by employees have not been recorded or paid

$$300$

$1,700$

$780$

$\backslash$table$[[$Date$,,,],[$Dec$.31,$Interest Expense,Debit,Credit$],[,$Interest Payable,,$]]$

All in red are shown as inncorrect.