Spreadsheet 2 Instructions

Spreadsheet 2 Instructions - ACIS 1504 Spreadsheet #2...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
ACIS 1504 – Spreadsheet #2 Project Instructions Overview 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 Excel help. 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 on campus. 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. Detailed Instructions Your solution will be graded on how well you achieve the design goals studied from SimText. Therefore, simply including a component may not earn credit. The component must be included in the most simple, clear, accurate, efficient and verifiable manner. Your solution should include the following components : 1. 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 workbook. Before you can add to that workbook, you’ll need to turn protection off. You’ll need to turn protection off for each sheet in which you previously turned it on. (See Appendix Section E1.5.) I have already graded protection so there is no need to turn protection back on when you are finished. 2. 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. a. 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. b. 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 month. ACIS 1504 - 07d88427c9fd0912eb46dee13f4198b2d3fc657d.doc Page: 1 of 6
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
c. Enter a function, not a formula, to total each revenue category for the semester. For example, if your parents gave you $50 each month, to total for the semester would be $250. You would include this calculation once for each source of revenue. d.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

Spreadsheet 2 Instructions - ACIS 1504 Spreadsheet #2...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online