### 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)
##### Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

No credit card required

25 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial