Must be in formula form. Having difficulty with this.
Chocolates by Jacki has provided Information relating to its current year. The Controller has asked you to Actvity Cost Pools Use the information included in the Excel Simulation and the Excel functions descnbed below to complete the task complete a First Stage Alocationto Cell Reference: Allows you to refer to data from another cell In the worksheet entered, the formula would output the resuit from cell 87, or 400,000 in this example. Abcolute Reference: Allows you to maintain the original cell reference when a formula is copled to another cell The cell referenceS From the Excel Simulation below, if in a blank cel, B7" was ked" by putting a dollar sign ($) before the column and row references. By default a cell reference is relative, so when formula to another cell the values update based on a relative reference. For exa C2, the mple, if you copy the formula -68 69 from cell C1 to cell formula in cell C2 will relatively update to be -B9+810" since the copied formula moved down one ceil the formula moved down one cell. Conversely, by adding the absolute cell reference "locks" to the equation, the formula will not change when $858 $859 You can also example, t you copy the formula--e$8.69" from celici to cell C2, the formula in cell C2 will update to be "ES8.B"since the coped copled to any other cell. For example, $858+$859" written in cell C1 is copled to cell C2, the formula in cell C2 will remain use a mixed cell reference by only "locking" the column or row only (588 or B$8) which locks that specific column or row and the other reference becomes a relative reference and "moves" with the formula as its copled to another cell. For cell the formula cell relative references also moved down one ceil, but the absolute "locked reference remained the same. Basic Math functions; Allows you to use the basic (plus sign to add), (minus sign to subtract), "(astenisk sign to mutiply), and/ (forward slash to divide) From the Excel Simulation below, if in math symbols to perform mathematical functions. You can use the following keys + formula would add the values from those cels and output the result, or 250,000 in this example you to refer to multiple cells and adds all the values. You can add individual cell references or ranges to utilize this of adding those cells, except they are expressed as a range in the formula, and the resuit would be 375.000 in this example. a blank cell-818-819" was entered, the using the other math symbols the result would output an appropriate answer for its function I n below, if in a blank cell-SUM(B13,814,815 was entered, the formula would output the resuit of adding n this example. Similarly, if in a blank cell SUMB13 815)" was entered, the formula would output the unction. From the Excel Simulatio same result
