Has to be done in excel

ou are owner of a and the data 211 Employees FederatIncome Tax Payable 310 501 Purchases and AMowanoes 510 650 Miscellaneous Expense 660 Salaries Expense DATA FORADJUSTMENTS Ending merchandise inventory 24,188 Ending inventory 1,049 Federal income tax expense 675 the month 3,827 for Lawled below 1,172 (65 marks) ou are owner of a and the data 211 Employees FederatIncome Tax Payable 310 501 Purchases and AMowanoes 510 650 Miscellaneous Expense 660 Salaries Expense DATA FORADJUSTMENTS Ending merchandise inventory 24,188 Ending inventory 1,049 Federal income tax expense 675 the month 3,827 for Lawled below 1,172 (65 marks)