KEY SKILLS
VEHICLE PROJECT - BUYING A VEHICLE
TASK 7. Add a row to your vehicle table and, at the bottom of the List Price column, use Formula from the Table menu to insert a formula to total the prices of all vehicles.
• Produce a hard copy print of the screen showing the formula used.
• Produce a hard copy of the rearranged table showing the total of list prices.
TASK 8. Using MS Excel, list the manufacturers chosen and the number of vehicles from their range to create a pie chart that shows the proportion of vehicles selected from each manufacturer. Print a hard copy. (See Helpsheet – Charts and Graphs )
TASK 9. Using MS Excel:
• Create a line graph showing the list prices of the vehicles researched. (See Helpsheet – Charts and Graphs )
• On the line graph, identify the range of the prices. (Drawing tools can be used for this). Print a hard copy.