Spreadsheet Practice - Fishing

Directions: The tables below represents the number of fish caught by several young men for the month of May. Illustrate this information in the table into a bar-graph using a spreadsheet program.

 

Number of Fish Caught in May
 
Catfish
Crappie
Carp
Bass
Total
Sydney          
Morgan          
Hunter          
Seth          
Jaclyn          
Kris          
Sam          
Haley R          
Haley S          
Kayden          
Addison          
Total          

 

  1. Start your spreadsheet program.
  2. Save the assignment in your Excel folder as: Excel_practice_fishing
  3. Enter the information from the table above into your spreadsheet.
  4. You are to add a totals column and row to show how many total fish each person caught as well as the total number of each type of fish caught. Be sure and use formulas.
  5. Use your chart program to convert the data into a bar graph.
  6. Insert a header on your page which includes your name, date and assignment.
  7. Save as pdf with your paper landscape fit to one page.
Catfish
Balck Crappie
Carp
Largemouth Bass
Catfish
Black Crappie
Carp
Largemouth Bass