solution?

Assignment 4 P-4-2. Prepare a variable costing income statement as of December 31, 2019. Compare this statement to the full absorption income statement for the same period (see solution for P-3-2). Explain the difference, if any, between the two approaches. ASSIGNMENT 4 EXCEL OPTION 1. Complete Problems P-4-1 and P-4-2 using the Student Excel Template provided on the Armond Dalton Resources site. Open the worksheet (i.e., tab) that is titled "4-Variable Costing." Use the Excel commands in bold below as appropriate in answering both problems. 2. Copy the Income Statement in worksheet "3-Income Statement" and paste it into worksheet "4-Variable Costing" and label it "Absorption Costing Income Statement." 3. Enter as many numbers into the variable costing income statement as you can by referencing cells in the table from your answer to P-4-1 and the absorption costing income statement. . Start the cell with "=" and follow it by the name of the cell (e.g., "=E4" for relative copying and "=$E$4" for absolute copying). 4. Use an IF statement to check if the fixed column total plus the variable column total in the solution to P-4-1 add up to the grand total. Also use IF to check if the net op- erating income from the variable costing income statement equals the net operating income from the absorption costing income statement. . Entry in Excel formula bar is =IF(C100=D100, "YES","NO")