| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

Video Game Budget

Page history last edited by mdeblock@... 14 years, 1 month ago

 

Imagine that the PTO wants to buy a gaming system to use at the Teen Canteens.  They will need the following: 

 

  1. A large screen flat TV between 40-52 inches
  2. A gaming system such as Xbox, Wii or Play Station
  3. 3 different games – they need to be school appropriate games.
  4. 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.