Youtube News chap 12 energy en Hels Seved CEL SIM-CH 70 Activity Cost Pools using Excel's Absolute Cell Referencing and Basic Math Functions 1 Chocolates by Jack has provided information relating to its current year. The Controller has asked you to complete a First-Stage Allocation to Activity Cost Pools. Use the information included in the Excel Simulation and the Excel functions described below to complete the task 5 points 014023 Shoped Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below. If in a blank coll, "-et was entered the formula would output the result from cell 07.400,000 in this example Absolute Reference: Allows you to maintain the original cell reference when a formula is copied to another cell. The coll references "locked by putting a doller sig (5) before the column and row references. By default acell reference is relative, so when you copy formule to another cell the values update based on a relative reference For example, if you copy the formula 88.89" from cell C to coll C2 the formula in coll 2 will lively update to be-39-810 since the copied formula moved down one cell the formula cell references also moved down one cell Conversely, by adding the absolute cell reference 'locks to the equation, the formula will not change when copied to any other cell For example-5058-$859" wiitto in cell is copied to cell C2. the formula in cell C2 will remain 5058 59$9" You can also use a mixed coll reference by only locking the column or row only (508or $8) which locks that specific column or tow and the other reference becomes a relative reference and moves with the formula as its copied to another coll For example, if you copy the form $8.00 from cell Ctto col the form in coll 2 will update to be $8-10 since the copied formulamoved down one cell, the formula cell relative references to moved down one coll, but the absolute "locked reference remained the same Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys plus sign to add minus sign to subtract. Isterisk sign to mupy), and/orward stash to divide). From the Decal Simulaton below, itin blanco-18-899 was entered the formula would add the voies from those cells and Output the result, 250.000 in this example, using the other math symbols the result would output on appropriate answer for it function SUM function: Allows you to refer to multiple cells and adds at the vehics You can add individual coloferences or ranges to utilize this function. From the Excel Simulation below.ifin blank cellSUMIDT 014 015) was colored the formula would output the result of adding those three separate cells, or 375.000 in this example Similarly, if in a blank cell SUMRU 815) was tored, the formula would output the serveresult of adding those cells, except they are expressed as a range in the formule, and the result would be 375.000 in this example fence 7 TRI HOM Foto location Act Control GLAVOUT TOMAAS DAIA VIEW VIW Stan INGER 200m 1004 room to Windon More Culoare hout MC Prev 11 Noxt . Gridlines Headings