Excel Project 2-(Chapters 813) Perfect Parties, Inc. has several divMsions, one of which provides birthday paries at their facility, and has provided the actual and panning budget results for the month of June. The Controller has asked you prepare the Birthday Party Division Budget Performance Report Use the information ncluded in the Excel Simulation and the Excel functions descibed below to complete the task . Cell Reference: Allows you to refer to data trom another cell in the worksheet From the Excel Simulation besow, if in a blank celEwas entered, the formula would output the result from cell E11, or 80 in this example functions: Allows you to use the basic math symbols to perform mathematical functions You can use the tollowing keys " and / forward slash to ovde) From the Excer Smulation beow. (plus sign to add), -(minus sign to subtracti '(asterisk sign to a blank cell E13+F13" was entered, the formula would add the values from those cells and output the resuit, or 75,560 in this example r using the other math symbols the result would output an e answer for its function SUM function; Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges to uize thes function. From the Excel Smulation below, If in a blank cell SUME16 E17, E18) was entered, the formula would output the resuit of adding those three separate ces, or t3.30?in this example Samiany. If in a blank ce'-SUM(E16 E 18). was entered, the formula woad output the same resuit of adding those cells, except they are expressed as a range in the formula, and the result would be 13,300 in this example ABS function: Alows you to return the absolute value of a number orc You can reference any cell to display its absolute value, or surround another formula with the ABS function, to return the final result as an absolute value. From the Exce see in cel H18 that the ABS function is being used Then, the ABS portion of the formula returns the absolute value of the E18) which first calculates the of F18-E18 that results in-200 you to test a c need to be made when using this function The testcondition argument is an n of the status of a ces, such as if the value of a cel greater than, less than?or equal to another and wate-?tiise arguments will return any speonc resut for each option, such as another celete ence the entire equation, it text is being used in the entered in quotations so that Excel wil recognize the text as a "string of text instead of another function From the valtue true, or value K false arguments then the text itselt should be Revenue is good,"Revenue is bad) was entered, the formula would would be result as true, or in this case the text 'Revenue is good" Excel below, if in a blank cell IF(E13-30000 the esut of the since the test uncion by separating it out into separate parts. First the tan X,000 O ce Exce, determines ?the resuit orthat esLcoooon is TRUE of value is greater PAGE LAYOUT FORMULAS DATAREVIEW VIE Cell Cells Editing Formatting Table Styles