with cell references please

Perfect Partes, Inc has severai divisions, one of which provides birthday parties at their facaity, and nas provided the actual and pianning budget resuls for the month of June. The Controller has asked you prepare the Birthday Party Division Budget Performance Report Use the intormation Included in the Exce simulation and the Exce functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simubanon below, if in a biank cell, El1" was entered, the formula would output the recult from cell El1, or 80 in this example Bosic Moth functions: Alowf you to use the basic math symbols to perform mathematical functions You can use the following keys + (plus sign to add), - (mirus sign to subtract). "(astertsk sign to muttiply, and ( (forward slasti to divide). From the Excel Simulation below, if in a blank cell "=E13+FI3" was entered, the formula would add the values from those cells and output the result, or 75,560 in this example if using the other math symbols the result would output an appropriate answer for its function. SUM function: Allows you to refer to multiple cells and adds al the values. You can add andividuar cell references or ranges to utalze this function. From the Excel Simulation below, if in a blank cell "isUM(E16, E17,18)" was entered, the formula woud output the result of acding those three separate cells, or 13,300 in this example. Simiarly, if in a blank cell "SUM(Ei6E18)" was entered, the formua would output the same fesuit of adding those cells, except they are expressed os a range in the formula, and the iesult woula be 13,300 in this example. ABS function: Allows you to retum the absolute volue of a number or casculation. You can reference any cell to display its absolute value. or surround another formua with the ABS function, to return the firat resuit as an absolute value. From the Excel Simulation below, you can see in cell H18 that the ABS function is being used, "=ABS(F18-E189" which first calculates the subtraction of F18-E18 that results in -200. Then, the ABS portion of the formula returns the absolute value of the subtraction resut which would be 200 in this example IF function: Allows you to tect a condition and retim a specific value is the resut is tue and different value if the resut is false. The syntax of the if function is "-ififtest conditionvalue. if truevzlue it fasker and spectic considerations need to be made when using this function. The test concotion argument 10 an evauabion of the status of a cell, such as if the value of a cell us greoter than, less than, or equai to another number or cell The vatoe. it. true and value. if. faise arguments wal return any specifc result for each opton, such as another celt reference, a value, of text. Throughout the entre equation, if text is being used in the test concition, vake. It thue, or valie. It fase arguments then the text itseif should be entered in quotations so that Excel will recognize the text as a "string of text instead of another function. From the Excel Simuiation since the testconawion would be result as true, of in this case the text 'Revenue is good Excel processes the if function by separateng it out into separate parts. First the tesL. condition - Excel thinks, find cell E13 and determine if the value is greater than 30,000. Once Excel determines if the result of that test condinanis TRUE of FALSE, it will feturn the vadie- If Irue or valie.-if favse FL.E HOME INSERT PAGELAYOUT FOPMULAS DATA REVIEW VEW fx -1 Culculate Now