pls answer 1 and 2 in excel formulas

Lester and Forrest Scruggs have presented you with the following information for Scruggs, Inc. For 2021 they would like for you to complete a(n) 1 adjusted Trial Balance (prepare this on a separate sheet tab). 2 multi step income statement (prepare this on a separate sheet tab). 3 statement of retained earnings (prepare this on a separate sheet tab) 4 classified balance sheet (prepare this on a separate sheet tab) determine the gross profit margin, operating margin and profit margin as percentages (put these on the income statement 5 next to their respective amounts) Lester Scruggs indicated that Lester and Forrest Scruggs have presented you with the following information for Scruggs, Inc. For 2021 they would like for you to complete a(n) 1 adjusted Trial Balance (prepare this on a separate sheet tab). 2 multi step income statement (prepare this on a separate sheet tab). 3 statement of retained earnings (prepare this on a separate sheet tab) 4 classified balance sheet (prepare this on a separate sheet tab) determine the gross profit margin, operating margin and profit margin as percentages (put these on the income statement 5 next to their respective amounts) Lester Scruggs indicated that