ACIS 1504 – Spreadsheet #2 Project Instructions
The purpose of this project is to demonstrate your mastery of spreadsheet calculations, chart
development and a few more advanced spreadsheet skills.
In this assignment, you will add to
your budget created in the previous project.
Detailed instructions for completing this workbook are included on the following pages.
If you need help with this assignment, please contact your instructor or one of the tutors at the
Center for Academic Enrichment and Excellence.
You may also use your SimText, SimNet and
You should use Microsoft Excel 2007 to complete this assignment.
If you do not have access to
Excel 2007, you can find the application installed on computers in Pamplin 2010 and other labs
This assignment is due by the start of class on the date specified in the tentative course schedule
found on the class website.
All homework grading policies can be found in the course website.
Save your work frequently.
Your solution will be graded on how well you achieve the design goals studied from
Therefore, simply including a component may not earn credit.
must be included in the most simple, clear, accurate, efficient and verifiable manner.
solution should include the following components :
Open the copy of the workbook you created for Spreadsheet #1 Project.
If you did not
complete that assignment, you should do so now.
The following instructions will add to that
Before you can add to that workbook, you’ll need to turn protection off.
need to turn protection off for each sheet in which you previously turned it on.
I have already graded protection so there is no need to turn protection back on
when you are finished.
On the second worksheet containing your forecasted figures and the third worksheet
containing your actual figures, add the following calculations.
(See SimNet Lesson D –
Creating Formulas Using the SUM Function, Excel Appendix E2.2
& SimText Chapter 6.)
Remember, to save time, you can add these calculates with the worksheets grouped.
Enter a function, not a formula, to total each month’s revenues.
For example, if you got
$50 from your parents and $100 from your job in the first month, the total for the month
would be $150.
You would include this calculation five times, once for each month.
Enter a function, not a formula, to total each month’s expenses.
For example, if you
spent $10 on food, $20 on clothing and $30 on gas in the first month, the total for the
month would be $60.
You would include this calculation five times, once for each
ACIS 1504 - 07d88427c9fd0912eb46dee13f4198b2d3fc657d.doc
1 of 6