Purpose:

• Learn to organize data in a spreadsheet.
• Learn to enter formulas in a spreadsheet.
• Learn to create a pie graph, label the graph, and change the fill colors.

To Do:

• Download the following document: Sport Store.

Timeline:

• 1 day
  

Requirements:

• Change name of sports store.
• Set up a formula for "Selling Price" and fill down formula.
  • Here is a possible formula "=(B3*C3)+B3"
• Set up a formula for "Total Sales" and fill down formula.
  • Here is a possible formula "=D3*E3"
• Set up a formula for "Total Markup" and fill down formula.
  • Here is a possible formula "=(D3-B3)*E3"
• Set up a pie graph using "Total Sales" column.
• Proper title for graph.
• Pick different colors for each slice and explode slices.
• Include percentage for each item in legend.
• Change "Page Set-up" to landscape.
• Adjust spreadsheet data and graph so it fits on one to two pages.
• Add a header with your name on it.
• Save spreadsheet in "Spreadsheet" folder as "Sports Store."

Evaluation:

• Please do the Sports Store Rubric with a person of the opposite gender.

Final Steps:

• Name the document "Sports Store"
• Save a copy in your "Public" folder and save a copy in your "Spreadsheets" folder.
• Go to the next project.