Excel Chart - School Sports Equipment Expenses
Create an Excel Chart Showing Sports Equipment Expenses
Instructions: Students shop for sports equipment for their school. Students should spend as much as they can without going over $200.
Students create a spreadsheet using items chosen from the Sports Equipment Price List. Students format the numbers with dollar signs (currency). Students use a simple formula (SUM) to calculate the total cost and create a chart illustrating their expenses. Students may add clipart or related images.
Sports Equipment Expenses Chart - Finished Example:
Sports Equipment Price List Example:
Excel Spreadsheet Rubric for Grading Assignments:
Make a Chart in Excel - A Two Minute Tutorial
This video shows you how to make a chart like the one in this assignment. It shows you how to increase the font size, widen a column, merge and center the title, format numbers with the dollar sign, total a column of numbers with autosum, create the chart, and change the colors of the chart column bars.
This video is available in HD.
For PC's and Microsoft Office