### Free Educational Resources

• > Exploring Excel Ch. 06 - H1 Project What-If Ana...
+

# Exploring Excel Ch. 06 - H1 Project What-If Analysis

##### Rating:
(0)
Author: matthew stock
##### Description:

http://homework.plus/exploring-excel-ch-06-h1-project-what-if-analysis/

What-If Analysis

Project Description:
In the following project, you will perform What-IF Analysis to calculate budget information for your University’s Valentine’s Day formal.

Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step

Instructions

Points Possible

1

0

2

Use Goal Seek to achieve a \$0 balance by changing the Ticket Price per Person.

6

3

Beginning in cell E3, complete the series of substitution values ranging from 200 to 500 at increments of 20 students vertically down column E

3

4

Enter cell references to the Total Income, Total Expenses, and Balance formulas (in that order) for a one-variable data table in cells F2, G2, and H2 respectively.

3

5

Apply custom number formats to make the formula references appear as the following: F2- Revenue, G2 –Expenses, H2 – Balance.

3

6

Create a one-variable data table for the range E2:H18 using the Number of Attendees as the column input cell. Format the results with Accounting Number Format with two decimal places.

7

7

Copy the Number of Attendees substitution values from the one-variable data table (in cells E3:E18), and then paste the values starting in cell E22.

4

8

Type \$50 in cell F21 and complete the series of substitution values from \$50 to \$100 at \$10 increments.

2

(more)

### Analyze this: Our Intro to Psych Course is only \$329.

Sophia college courses cost up to 80% less than traditional courses*. Start a free trial now.

Tutorial