please show the excel function, cannot enter straight numbers!

Patterson, Inc has provided details of its actual cost data for the month. The Controller has asked you to compute the basic variances and the impact of those vatiances on unit costs. Use the intormation inctuded in the Excet simulation and the Excel functions described below to complete the tosk - Cell Reference; Allows you to refer to dafa from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "D D4" was entered, the formula would output the result from cell D4, or 275 in this example - Basic Math functions; Alows you to use the basic math symbols to petform mothematical functions You can use the following keys + (plus sign to add). - (minus sign to subtraci), "(asterisk sign to multiply), and / (forward slash to divide) From the Excel 5imu/ation below, it in a blank cell "=F4.G5" was entered, the formula would odd the values from those cells and output the result of 1470 in this example if using the other moth symbols the result would output an eppropriate answer for its function - SUM function: Allows you to refer to multiple cels and odds ali the volues rou can odid individual cell references or fanges to utilize this two separate celis, of 545 in this oxample Similaily. if in a blank cell "oSUM(D4 D5)" wos entered, the formila would output the same result of adding those cells, except they ate expressed as a range in the formula, and the tesuit would be 5.45 in this exomple - ABs function; Alows you to return the absolkte value of a numbel or calculation You can reference any cell to display its absolute value. foamuia returns the absolute volise of the subtraction result, which would be 020 in this example - If function: Anows you to this a condition and return a specific value is the cesitit is true and different valie if the resuit is false. The syntax of The tesc condition migument is an evaluation of the statis of a cell, such as t the vilue of a ced is greater than, lens than or equal to another number of cell The vilite. it true and value, it fatse arguments wit return any specific result for each option, such as another call reference. the test aself should be emered in quotations so that fricel will recognize the text as a "string of text" instead of another function. From the would outpat the result of the value- if trive since the lest. condibon would be result as tree. or in this case the text "Total Cout Per. Unit is good" Excel processes the If tiatction by separating it out into seperate parts Firct the test condition - bcel thiniks, find cel F13 end determine st the volue is gieater than 20 Once Excel determiness if the result of that test_condifin is TRUE of FALSE. it wall return the valive it trie or value if false F30 \begin{tabular}{|l|l|} \hline & A \\ \hline 2 & \\ 3 & Direct materials: \\ \hline 4 & Standadd \end{tabular} \begin{tabular}{|llr} \hline 4 & Standard & 2.4 \\ \hline 5 & Actual \\ 6 & Direct labor: \\ 7 & Standard & 0.6 \\ 8 & Actual & 0.5 \\ 9 & Variable overhead: \end{tabular} 0.6 hours (1) $7.00 per hour 0.5 hours @ $7.10 per hour F $2.75 per yard $6.60 $2.70 per yard $8.10 15 Excess of actual cost over standard cost per unit $21.60 18 Variable overhead is assigned to products based on direct labor hours. There 19 was no beginning or ending inventory of materials for the month. 20 Using formulas, compute the following. input all numbers as positive amounts. 22 indicate whether the variances are F or U. Write if statements for variance cells F30 to F47. Use cell references (formulas) for cells D53- D60. Enter an F or U to indicate the correct variance in cells F54 to F62. 23 Variable overhead efficiency variance Variable overhead rate variance Using formulas, compute the amount of the unit cost difference 50 that is traceable to each of the variances computed above. 51 52 Materials: 53 Quantity variance 54 Price variance 55 Labor: 56 Efficiency variance 57 Rate variance 58 Variable overhead: 59 Etficiency variance 60 Rate variance 62 Excess of actual over standard cost per unit 63 64 65 66