Spreadsheet Practice Problems
Spreadsheet Problem #1
A few of Mrs. Smith's Marine Biology students will be going to Key West for a snorkeling trip during Spring Break. The total cost of the trip is $200.00 per student which can be paid in four payments. Enter the following data into a spreadsheet with a column indicating the total each student has paid. Also include a total of money collected. Print this list.

Joe Jones $50.00 $ 50.00 $100.00
Cindy Todd $200.00
Jose Ramos $100.00 $50.00 $50.00
Sue Chen $100.00 $100.00
Sam Polk $50.00 $50.00 $50.00 $50.00

SUM formula example: =SUM(b2..b5) OR =SUM(b2+b3+b4+b5)

Finally,  make a bar chart of the final spreadsheet information. The bar chart should show how much each student has paid. Print the bar chart.
ANSWER


Spreadsheet Problem #2

Mr. Gonzalez, the Science Department chairperson, is responsible for keeping an account of the funds spent by some of his department at a recent science conference they attended. Enter the following data into a spreadsheet with a column indicating the total spent by each person and a group total.

Nights/motel - cost per night - food/gas
Mr. Williams 3 nights motel at  $87.00 per night, food and gas  $125.00
Mrs. Adams 2 nights motel at  $87.00 per night, food and gas $79.00
Ms. Bennett 2 nights motel at $87.00 per night, food and gas $92.00
Mr. Kim 3 nights motel at $87.00 per night, food and gas  $118.00

Mrs. Adams has not been paid for the trip. You need to give the office the total for her trip so that she can get paid. Print the cost of her trip so that you can give this information to the office.

Hint: Select Mrs. Adams information and print. You do not want the other information to print.
ANSWER


Spreadsheet Problem #3
Mrs. Richardson is the sponsor for the National Honor Society and is responsible for keeping track of the students' community service hours. Make a spreadsheet of the following data with a column for total hours
per student and a group total.

Richard Andrews 2 8 1 1 2 2
Susan Wright 3 3 8 1 1 4
Lisa Baggett 2 2 1 1 3 8
Bob Ross 3 3 2 8 2 2

You want to show your principal how many hours the students have worked. Make a bar or stacked chart of the students' hours and the group total.
ANSWER


Spreadsheet Problem #4
Mr. Matthews gives his PE students 100 points at the beginning of each six weeks. At the end of 15 days, he gives a progress report to each student. During these 15 days, he has deleted 1 point for not dressing out and deleted 2 points for not participating. Make a spreadsheet of the following data.

(choose a day to mark the deletion of each of these points)

Andy -3 -1 -2
Patty -1 -1 -1 -1 -1 -3
Lisa -3 -3 -3 -3 -3
Beth -2 -2 -3 -3

Subtraction formula:    =(b1-b5)   subtracts the value in b1 from the value in b5
Using this data, make a bar chart for Andy showing him his grade at the end of
the 15 days. Print the chart.
ANSWER

Back to Basic Competencies