CLAIT (level 1): Spreadsheets & Graphs

Exercise 7 - Miles Author: Tom Whitehouse

Part 1

1. Open a new workbook in Microsoft Excel

2. Make sure you are working in the worksheet Sheet1

3. Add the following data which contains data on distances travelled by various salesmen from January to June

	JAN	FEB	MAR	APR	MAY	JUN
Harrison	876	456	987	546	573	676
Roberts	123	646	345	956	453	768
Whitehouse	1235	1453	1465	1657	1435	989
Barclay	573	456	956	362	786	354
Catermole	676	467	895	1453	352	156

4. Save the workbook with the filename Miles in the folder GRAPHS on your floppy disk

5. Create a pie chart to display the JAN data for all the salesmen

6. Give the chart the heading MILES IN JANUARY

7. Ensure that each segment can be clearly identified when printed

8. Each sector of the chart must be labelled clearly with the percentage of miles travelled

9. Include a legend to identify the salesmen

10. Print one copy of the pie chart

11. Close the workbook Miles and exit the system securely making sure all files are saved

Part 2

1. Using Microsoft Excel, open the workbook Miles from the folder GRAPHS on your floppy disk

2. Select Sheet1 to show the data if this is necessary

3. Produce a bar chart showing the mileage figures for Barclay from MAR to JUN

4. Display the months on the category axis

5. Give the bar chart the heading BARCLAY MILES

6. Label the category axis MONTH

7. Label the value axis MILES

8. Set the value axis to display the range 0 to 1000 (you may have to do this later so don’t forget to return to complete it)

9. Do not show a legend

10. Print one copy of the bar chart

11. Close the workbook Miles and exit the system securely making sure all files are saved

Part 3

1. Using Microsoft Excel, open the workbook Miles from the folder GRAPHS on your floppy disk

2. Select Sheet1 to show the data if this is necessary

3. Produce a line graph comparing the data for the two salesmen Harrison and Roberts for JAN to JUN

4. Display the months along the category axis

5. Set the value axis to display the range 100 to 1000 (you may have to do this later so don’t forget to return to complete it)

6. Give the graph the heading COMPARISON OF HARRISON AND ROBERTS

7. Label the category axis MONTH

8. Label the value axis MILES TRAVELLED

9. Use a legend to identify each line

10. Make sure that the lines can be identified when printed

11. Display the values (numbers) on each data point

12. Print one copy of the line graph

13. Close the workbook Miles and exit the system securely making sure all files are saved