Project 2-4Chapters 8-13) Patterson, Inc. has provided details of its actual cost data for the month. The Controlter has asked you to t compute the bac vanances and e variances on unit costs Use the information included in the Excel Simulation and the Excel functions descibed beow to co the task Cell Reference. Allows you to refer to data from another cell in the worksheet From the Excesmuat on beowrnatar* oH" entered, the formula would output the result from cell D4, or 2 75 in this example Bosic Meth functions: Allows you to use the basic math symbois to perform mathematical functions You can use the following keys iplus sign to ado), (minus sign to subtract). (asterisk sign to mutiply), and/orward slash to drvide) From the Excel Smulation berow a blank cel -F4 G5 was entered, the formula would add the values from those cells and output the resuit or 14.70 im ths esampe t usng the other math symbols the resuit would output an appropniate answer for its function SUM tunction: Allows you to refer to multiple cells and adds all the values. You can add Individual cell references or ranges to ut function. From the Excel Simulation b two separate cells, or 5.45 in this example. Simsarty, If in a blank ces -SUMD4 D5 was entered, the formula would output the same result of adding those cells, except they are expressed as a range in the formusia, and the resuit would be 5.45 in thes elow, Iif in a blank cel SUMID4,D5) was entered, the formula would output the result of aaing those . ABS function: Allows you to return the absolute value of a number or calculation You can reference any cell to or surround another formula with the ABS function, to return the tinal resuit as an absolute value From the Excel Simulation below, if in a display its absolute value bianik ceil you entered AB(F7-G8) Excel wias frst calculate the subtraction of F7-G8 that results in -0 20. Then, the ABS portion of the formula returns the absolute value of the subtraction result, which would be o.20 in this example IF function: Allows you to test a condition and return a specitic value is the resuit is true and different value if the resuit is false The syntax of the IF function is iFiftest conditior value It true vatue t falser and specific considerations need to be made when using this function Therese.conditor, argument is an evaluation ofthe status of a cell, such as if the vake of a cell sgreater than, less than, or equal to another number or cell The ?ue_r_true and vaue trase arguments wll return any specinc result for each option. such as another ces reference. a value, or text. Throughout the entare equation, it text is being used in the test concion, vave it true or vaue t fase ar the text itself should be entered in quotations so that Excel wi recognize the text as a "string of text instead of another function From the Excei Simulation below, if in a blank cell FiF13-20, Total Cost Per Unit is good Total Cost Per Unit is bad) was entered, the formula would output the resuit of the vatue t true since the lest.condition would be resut as true, or in thes case the text Total Cost Per Unitis good Excel processes the IF function by separating it out into separate parts. First the test condition- Excel thinks, tind cell F13 and etermine it the value is greater than 20. Once Excel determines if the result of that test condition is TRUE or FALSE, It will return the guments then Basic Variance Analysis and the Impact of Variances on Unit Costs-Excell HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW EW Sign in Formatting Table Styles Stles esz