excel

Excel Practical 1 Creating and Chart a Visitors List Worksheet

Instructions:

1. Copy the following information to a new Excel Worksheet. The letters and numbers in Gray represent the Excel Worksheet. DO NOT copy them.

2. Save the workbook as yourname_P1, where yourname is your own name.

3. Enter the title: Clinic Visitors by Month at cell A1 4. Enter the subtitle: We Care Animal Clinic at cell A2 5. Bold and center the title and subtitle across the table. 6. Enter the row title Grand Total at cell A11 7. Enter the column title Total at cell E3 8. Calculate the Grand Totals 9. Calculate the number of visitors for each month 10. Format the table.

a. You decide how to format. b. Find and use appropriate fonts and colors to present a well formatted

table 11. Include a 3D cluster column chart that shows the Total number of

Visitors per month 12. Move the chart underneath the table 13. Rename the worksheet: Visitors

a. Color the tab GREEN 14. Change the Document Properties

15. Add your name 16. Add the subject 17. Add TAGS (Use a minimum of 3, separated by commas)

A B C D 1 2

3 Description January February March

4 Cats 35 44 48 5 Dogs 56 65 58 6 Hamsters 24 22 21 7 Rabbits 14 12 10 8 Guinea Pigs 14 5 16 9 Snakes 8 9 4

10 Other 3 4 6