Question

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 variances on unit costs. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, -D4" was entered, the formula would output the result from cell D4, or 2.75 in this example. ing keys: +(plus sign to add), (minus sign to " ic11.isaj. Iin?,"il? low, if in a blank cell"-F4+ SUM function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges to utilize this function. From the Excel . elow, if in a blank cell "-SUM(D4,D5)" was entered, the formula w ing those two separate cells, or 5.45 in this exa enteredt adding those cells, ex t they are expressed as a range in the formula, a nd the resul would be 5.45 in this example ABS function: Allows you to return the absolute value of a number or calculation. You can reference any cell to display its absolute value, or surround another formula with , to return the final result as an ab value. From the Excel Sin ow, if in a blank cell you entered ABS(F7-G8)" Excel will first ca on of F7-G8 that results in -0.20 e formula returns the absolut e value of the subtraction result, whi be 0.20 in this example

Answer 1

Answer 2