Please include the correct formulas for the answers in Excel

Excel File Edit View Insert Format Tools Data Window Help ExcelAssignment2_Question4 AutoSave OFF Home Insert Draw Page Layout Formulas Data Review View Tell me IAS Liberation Sans v 12 ' % Conditional Formatting Format as Table Cell Styles O Paste B I U V AM Number N 30 Cells > Editing Analyze Data Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? K L X Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. A1 Xfx Function: IF, Formula: Subtract, Multiply; Cell Referencing D E G H 1 Function: IF; Formula: Subtract, Multiply: Cell Referencing 2. HO 3 Using Excel to Determine Overhead Variances Student Work Area 4 PROBLEM Required: Provide input into cells shaded in yellow in this template. Use cel 5 In October, Pine Company was determining its overhead variance. Its references to the Problem area with mathematical formulas in the input cells. 6 predetermined overhead rate is based on direct labor hours. The following In the last input field, Input an IF function with cell references to your work 7 information was provided. area. 8 9 Manufacturing overhead costs incurred $ 118,000 10 Actual direct labor hours 21,000 Compute the amount of the total overhead variance and designate if the 11 Standard hours allowed for work done 20,600 variance is favorable or unfavorable using Excel's IF function. 12 Predetermined overhead rate $ 6.00 13 Actual overhead 14 Overhead applied 15 Total overhead variance 16 Nature of variance 17 18 19 20 21 22 23 Enter Answer + @