CGS1060 Assignment 3: Microsoft surpass 2010
Purpose
The purpose of this identification is for students to depict proficiency in Microsoft pass by by creating a spreadsheet that allow for be used to manage their own personal budget. enrapture note that you do not have to imply material values for your income and expenses; you can make up values, but they should be realistic.
Before attempting to design the spreadsheet in Microsoft Excel, students should search the Web for adjudicate personal budgets to learn how they might be organized in a spreadsheet. We will not provide samples of what the finished proceeds will look like. A main objective of this assignment is to demonstrate how to properly organize data in an Excel spreadsheet. Microsoft Office Help, online resources, and your instructors can help to provide proper guidance.
bailiwick Requirements
The spreadsheet should contain, in a logical format, the following information:
1. The commencement ceremony part of the spreadsheet should show your income each month, for a 12-month period, that comes from all income sources. An exemplification is below:
Income| Jan.| Feb.| Mar.| Apr.| May| June| July| Aug.| Sep.| Oct.| Nov.| Dec.
|
Employer| $440| $400| $500| $560| $440| $550| $250| $390| $500| $440| $550| $ccc|
Interest| $2| $2| $2| $2| $2| $2| $2| $2| $2| $2| $2| $2|
Parental Assistance| $ one hundred| $ deoxycytidine monophosphate| $100| $100| $100| $100| $100| $100| $100| $100| $100| $100|
2. In a forward-looking form at the bottom of your income information, include a row that displays the total income per month. To receive credit for this step, you essential use an Excel formula or function to reckon the total
3. In a new column on the right side of your income information, include a column that displays the total income per category. To receive credit for this step, you must use an Excel formula or function to calculate the total. Where the total row and total column...If you want to get a full essay, order it on our website: Orderessay
If you want to get a full essay, wisit our page: write my essay .
No comments:
Post a Comment