Excel Project Excel–CH6-CH9-Ch12: Project

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

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

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

Type **$50** in cell
F21 and complete the series of substitution values for Ticket Price
per Person from $50 to **$100** at **$10**increments.

3.000

**8**

In cell E21, enter the cell reference to the Balance formula
(C33).

Complete the two-variable data table for the
range E21:K37, using Number of Attendees and Ticket Price per
Person as the appropriate input cells.

Format the
results with Accounting Number Format with two decimal places.

5.000

**9**

Select the 3 cells in the two-variable data table that are closest
to break even without creating a deficit.

Apply a Light
Blue fill color and Dark Red text to the 3 selected cells.

Apply custom number format to cell E21 to display **#Attend**.

3.000

**10**

Create a scenario named **500 Attend** using the
Number of Attendees, Caterer’s Meal Cost per Person, Ticket Price
per Person, and Ballroom Rental variables as the changing cells.

Enter these values for the scenario:
**500**, **15.95**, **75**,
and **12500**.

2.000

**11**

Create a second scenario named **400 Attend**, using
the same changing cells.

Enter these values for the
scenario: **400**, **17.95**,
**85**, and **12500**.

2.000

**12**

Create a third scenario named **300 Attend**, using
the same changing cells.

Enter these values for the
scenario: **300**, **19.95**,
**90**, and **11995**, respectively.

2.000

**13**

Create a fourth scenario named **200 Attend**, using
the same changing cells.

Enter these values for the
scenario: **200**, **22.95**,
**95**, and **11995**, respectively.

2.000

**14**

Generate a scenario summary report using the Total Revenue, Total
Expenses, and Balance as the result cells.

On the
Scenario Summary worksheet, replace existing text as follows:

C6 – No. of Attendees

C7 – Caterer’s Meal Cost per
Person

C8 – Ticket Price per Person

C9 – Ballroom
Rental

C11 – Total Revenue

C12 – Total Expenses

C13
– Balance

AutoFit the contents of column C.

Delete column A.

5.000

**15**

Load the Solver add-in if it is not already loaded.

Click the Budget worksheet, activate Solver, and set the
objective to calculate the highest balance possible.

Use the Number of Attendees and the Ticket Price per Person as
changing variable cells.

3.000

**16**

Set a constraint so that the Number of Attendees entered in the
Input Section of the workbook does not exceed the specified limitation
in cell B11.

Set an appropriate integer constraint.

3.000

**17**

Set constraints so that the Ticket Price per Person entered in the Input Section meets the requirements set in the range A13:B14.

3.000

**18**

Set a constraint that ensures the Valet Parking expense is less than or equal to the product of the Maximum Parking Stalls and the Valet Parking per Vehicle.

3.000

**19**

Solve the problem, but restore original values in the Budget
worksheet.

Generate the Answer Report.

3.000

**20**

**CH09 - Project Description:**

*You have volunteered to be the statistician for your high
school* *’* *s football team. As part of your
assignment you will organize, and present statistics to the
coach. Currently the information is stored in three different
Excel workbooks: offense, defense, and special teams. You will
standardize the worksheets into a summary document as well as
correcting errors, and safe guarding against future issues.*

0.000

**21**

Group the Offense and Defense worksheets.

Click
cell A1:A2 and fill contents and formatting across the grouped worksheets.

3.000

**22**

With the sheets still grouped, select the range A3:F3.

Add borders to all cells.

Center the text in the
cells.

Fill the cells with the color Blue, Accent 1,
Lighter 60%.

Ungroup the worksheets.

Click
the Defense worksheet and modify cell A2 to display the text **Defense**.

4.000

**23**

Click the Offense worksheet.

Trace the error in the
cell that contains the #DIV/0 error.

Enter an IFERROR
function that returns **0** in cell D6 for the existing
value, C14/B14.

3.000

**24**

In cell A4 on the Offense-Defense Totals worksheet, insert a
function that will total the number of touchdowns from passing,
rushing, and receiving.

Take care to reference any
relevant worksheets and relevant cells to calculate this total.

3.000

**25**

In cell B4 on the Offense-Defense Totals worksheet, insert a
function that will total the number of yards from passing, rushing,
and receiving.

Take care to reference any relevant
worksheets and relevant cells to calculate this total.

3.000

**26**

In cell C4 on the Offense-Defense Totals worksheet,