CVP Analysis using Excel's Basic Math Functions $[$LO$1,$ LO$3,$ LO$5,$ LO$7,$ LO$8)$

JPh$.$ Inc has prowided its sales and expense dota for the most recent period. The Controller has asked you prepare o spreadsheet that shows the related CVP Anblysis computations Use the information included in the Excel Simulation and the Excel functions described below to complese the tosk.

Cell Reference; Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below. if in a blank cell. $"$ab$\text{'}$ was entered. the formula would output the result from cell B$5,$ or $75$ in this example

Bosic Math functions: Alows you to use the basic math symbols to perform mathemetical functions. You can use the following keys $($plus sign to add$),-[$minus sign to subtroct$)."($asterisk sign to muluiply$).$ and $/$ forward slosh to divide$).$ From the Excel Simulation below, if in a blank cell $"B5+B6"$ was entered. the formula would odd the values from those cells and output the result, or $120$ in this example. if using the other math symbols the resut would output an oppropriate answer for ins function