Description

Pts

Your Score

Formulas

*Formula A:  Cell C5: Prior Year’s Expense * (1 + Annual Rate Increase)

15

*Formula B:  Cell B13: Total Expenses for Year * Corresponding Assumption

15

SUM Column F, Row 10, Row 18

30

Print worksheet in Portrait with Fit to One Page selected.

10

*Please note that any cell referred to in your formulas whose reference should not change when the formula is copied, must be determined to be an absolute reference ($)

Also, please note that as you copy formulas, formatting may change.  Keep the original formats in the cells as they are already formatted properly.  Make sure also that your TOTAL Cell Style stays in place throughout the range of cells in the total lines.

Part 2 - Exploded 3-D Pie Charts

Create one exploded 3-D pie chart that compares the total for each expense. Place on a separate chart sheet.  Add labels that show the category and percentage.  Remove the legend.  Add a title, “Expenses” and size to 28 pts. Rename the sheet tab, Expenses Pie Chart.  Print the chart.

50

Create one exploded 3-D pie chart that compares the total for each resource. Place on a separate chart sheet.  Add labels that show the category and percentage.  Remove the legend.  Add a title, “Resources” and size to 28 pts.  Rename the sheet tab, Resources Pie Chart.   Print the chart.

50

Part 3 – Goal Seek Activity

Goal Seek: Determine what the Annual Rate Increase would be in order to have $100,000 in total expenses.

Print Worksheet Only

10

10

E-Mail the exam file to instructor – please !!!

Path & Filename code are correct

10

TOTAL POSSIBLE POINTS:

200