FCA Technology and Computer Class 2013
Mr. Caldwell
sean@firstchristianacademy.com
Introduction to Spreadsheets, part 2
January 2013
January 2013
Last week we learned how to setup a basic spreadsheet to track a household budget. This week we want to add on to that spreadsheet so that we can see the percentages that each category contains. In class we saw how to find the percentage by dividing each category by the monthly total.
For example:
Rent 1000
Taxes 400
Electricity 200
Phones 200
Entertainment 100
Food 100
Total: $2000 per month.
What percentage is electricity? 200 divided by 2000 is .1 = 10%.
What percentage is food? 100 / 2000 = .05 = 5%
Each time we divide, we want to divide BY the same bottom number (in this case it’s 2000).
We need to set up the spreadsheet so each number also has a percentage next to it, like the example below. Remember, use the numbers you used from last week, not my numbers. Also, remember how important it is to reference the ABSOLUTE cell for the monthly total by putting “$” in front of the cell column and row identifier, for example the formula might look like this: =SUM(C1/$C$15), then you can copy the formula down and it will do all the computations for you like we saw in class.
You’ll need to format that column as percentage by highlighting the numbers and clicking the % sign in the toolbar or highlighting the column and selecting format, number, percentage.
Item Amount percentage
Electricity 200 3.58%
Water 75 1.34%
Car 500 8.96%
Rent 1500 26.88%
insurance 500 8.96%
Phone Bill 300 5.38%
Food 300 5.38%
Clothing 200 3.58%
Cable TV 250 4.48%
Education 700 12.54%
Pool service 55 0.99%
Cleaning 300 5.38%
Property Taxes700 12.54%
Monthly Total 5580
Yearly Total 66960
Your assignment should look similar to this when you're done:
Assignment is due: Wednesday, January 30, 2013. 10 points deducted for each late day. Please turn it in on time and get full credit.
How to turn in your assignment: Show me your assignment in class.
No comments:
Post a Comment