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

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

Rating:
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

Download and open the file named exploring_e06_grader_h1.xlsx, and then save the file asexploring_e06c1Dance_LastFirst, replacing LastFirst with your name.

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)
See 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.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 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 20 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