### Free Educational Resources

• > Excel Project Excel–CH6-CH9-Ch12: Project
+

# Excel Project Excel–CH6-CH9-Ch12: Project

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

http://homework.plus/excel-project-excel-ch6-ch9-ch12-project/

Excel–CH6-CH9-Ch12: Project
*Hi Aown,Would you be able to help me redo this assignment from ground up? I did it before but it was full of errors. Thanks.Offered Price: \$100Due Date: 19/04/2016
Please confirm ASAP #O.K, will turn the ans. by Monday 18 Apr, 2016.
Project Description:
We have combined three chapters in Excel for this project: Excel - CH06: What-If Analysis, Excel - CH09: Multiple-Sheet Workbook Management, and Excel – CH12: Templates, Styles and Macros.  Steps 1 through 19 include features from Excel Chapter 6, with Step 1 providing a description of the worksheets related to Chapter 6.  Steps 20 through 30 include features from Excel Chapter 9, with Step 20 providing a description of the worksheets related to Chapter 9.  Steps 31 to 40 include features from Excel Chapter 12, with Step 31 providing a description of the worksheets related to Chapter 12.

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

Instructions

Points Possible

1

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

0.000

2

Download and open the file named Excel-6-9-12_Start.Save the file as:  Excel-6-9-12_LastName (replacing your last name with the text LastName).

0.000

3

On the Budget worksheet, use Goal Seek to achieve a \$0 balance by changing the Ticket Price per Person.

3.000

4

Beginning in cell E3, complete a series of substitution values vertically in column E, ranging from 200 to 500 at increments of 20 attendees.

3.000

5

Enter cell references to the Total Revenue, Total Expenses, and Balance formulas (in that order) for a one-variable data table in cells F2, G2, and H2, respectively.  Apply custom number formats to make the formula references display as follows:          F2 – text to display:   Revenue          G2 – text to display:   Expenses          H2 – text to display:   Balance

3.000

6

Create a one-variable data table for the range E2:H18 using the Number of Attendees as the appropriate input cell.  Format the results with Accounting Number Format with two decimal places.Type #Attend in cell E2 and align right the cell contents.

3.000

(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