Answered step by step
Verified Expert Solution
Question
1 Approved Answer
All the parts need to be answered Funberry Amusements is an owner/operator of several amusement parks. Following is a performance report that a Funberry manager
All the parts need to be answered
Funberry Amusements is an owner/operator of several amusement parks. Following is a performance report that a Funberry manager built in Excel. (Click the icon to view the performance report.) Read the requirements. 1. What formula would be entered in Cell D3 to calculate the difference between the ACTUAL total in Cell B3 and the BUDGET total in Cell C3? 2. How would the formula in Question 1 be modified to make the result in Cell D3 an absolute value? 3. What steps would be performed in Cell E3 to display an "F" if the variance in Cell D3 is favorable and a "U" if the variance is unfavorable? A. Select Cell E3. Click on the Formulas tab on the Ribbon, then click the drop-down arrow below Logical and select TRUE. Type D3>0 in the Logical Test field, Type F in the Value if True field, and Type U in the Value if False field. B. Select Cell E3. Click on the Formulas tab on the Ribbon, then click the drop-down arrow below Text and select VALUE. Type B3>=C3 in the Logical Test field, Type F in the Value if True field, and Type U in the Value if False field. C. Select Cell E3. Click on the Formulas tab on the Ribbon, then click the drop-down arrow below Logical and select IF. Type B3>=C3 in the Logical Test field, Type F in the Value if True field, and Type U in the Value if False field. Performance report Performance report Requirements Using the performance report shown, answer the following questions. 1. What formula would be entered in Cell D3 to calculate the difference between the ACTUAL total in Cell B3 and the BUDGET total in Cell C3? 2. How would the formula in Question 1 be modified to make the result in Cell D3 an absolute value? 3. What steps would be performed in Cell E3 to display an "F" if the variance in Cell D3 is favorable and a "U" if the variance is unfavorable? 4. How could the contents of Cells D3 and E3 be copied to the remaining rows containing revenues? 5. How would the steps for calculating the "F" or "U" for expenses differ from the steps for "F" or "U" for revenues? 6. Specify the formula that would be entered in each of the following cells: a. Cell B9 to calculate ACTUAL total sales revenue b. Cell C9 to calculate BUDGET total sales revenue c. Cell D9 to calculate VARIANCE for total sales revenue d. Cell B23 to calculate ACTUAL operating income e. Cell C23 to calculate BUDGET operating incomes f. Cell D23 to calculate the VARIANCE for operating income 7. What steps would be performed in cell E23 to display an "F" if the variance in cell D23 is favorable and a "U" if the variance is unfavorableStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started