Imagine that the PTO wants to buy a gaming system to use at the Teen Canteens. They will need the following:
- A large screen flat TV between 40-52 inches
- A gaming system such as Xbox, Wii or Play Station
- 3 different games – they need to be school appropriate games.
- Any necessary accessories such as controllers, remotes, etc.
Your total budget will be $1800
Create a spreadsheet in Excel so that it is like the following table:
Name your File "Video Game Budget - Your Name"
Save your file to the desktop !
|
A |
B |
C |
D |
E |
F |
1 |
Name of Item
|
Name of Online Store
|
Cost of item
|
Total Budget Allowed
|
Total Amount spent so far
|
Total Amount left to spend
|
2 |
TV
|
|
|
1800
|
Sum(c12)
|
Sum(d2-e2)
|
3 |
Gaming System
|
|
|
|
|
|
4 |
Game #1
|
|
|
|
|
|
5 |
Game #2
|
|
|
|
|
|
6 |
Game #3
|
|
|
|
|
|
7 |
Other Stuff #1
|
|
|
|
|
|
8 |
Other Stuff #2 |
|
|
|
|
|
9 |
Other Stuff #3 |
|
|
|
|
|
10 |
Other Stuff #4 |
|
|
|
|
|
11 |
Other Stuff #5 |
|
|
|
|
|
12 |
|
|
Sum(c2:c11) |
|
|
|
All of the items above in Red will require you to insert a number or formula into that cell.
You can use the following websites to research the prices of items.
Bestbuy.com
Amazon.com
Toysrus.com
Gamestop.com
Are the words at the top of your Excel spreadsheet columns not appearing correctly?
Try one of these solutions:
Wrap the Text
Highight the cells that you want to wrap the text in:
1. Go to VIEW>FORMATTING PALETTE
2. In the Formatting Palette, go to ALLIGNMENT AND SPACING
3. Put a Check next to WRAP TEXT
You can also try this: Adjust the Width of the Columns
Comments (0)
You don't have permission to comment on this page.