Excel Practical due in 7 hours

PRACTICAL EXERCISE EXCEL Module 1

Exercise 1

Creating and Graph a Visitors List Worksheet

Problem: You have decided gather information about how many different types of animals

are treated in the clinic in which you work in.by quarter

Instructions:

1. Use the techniques learned to create a worksheet that includes the data provided in

Table E2-1.

2. Bold and center the title across cells A1:E1.

3. Calculate the Grand Totals

4. Look for the Total number of visitors for each quarter

5. Format the table.

 You decide how to format.

 Find and use appropriate fonts and colors to present a well formatted table

6. Include a 3D cluster column chart that shows the Total number of Visitors per month

7. Move the chart underneath the table.

8. Enter your name below the chart in column A. In the cells directly below your name,

enter your course identification, Excel Practical 1, the assignment date, and your

instructor’s name.

9. Rename the worksheet Tab to Visitor

10. Color the tab GREEN

11. Save the workbook as PE-M1-EX1_Yourname, where Yourname is your own name.

12. Change the Document Properties with your name in Author

Clinic Visitors by Month

Animals R’ Us Clinic

Description January February March Total

Cats 32 29 42

Dogs 48 65 63

Hamsters 8 3 9

Rabbits 2 9 5

Guinea Pigs 2 5 7

Snakes 2 7 4

Other 8 4 5

Grand totals

Table E2-1

Exercise 2

Enter the data given below into a worksheet.

A B C D E

1 Stationery Supplies Ltd

2

3 Date Sales Person Item Receipt No Amount

4 21-Nov Carl Toys 1238 1,782.10

5 26-Nov Carl Stationery 1255 4,853.55

6 26-Nov Carl Toys 1395 51.35

7 Carl’s Total

8 21-Nov John Cards 1141 91.15

9 24-Nov John Books 1982 442.60

10 21-Nov John Toys 1885 561.50

11 26-Nov John Toys 1875 62.75

12 John’s Total

13 22-Nov Judy Books 1032 234.50

14 26-Nov Judy Sports goods 1920 472.60

15 Judy’s Total

16 25-Nov Mary Toys 1774 364.15

17 Mary’s Total

18 22-Nov Susan Electronics 1160 52.95

19 23-Nov Susan Cards 1075 81.60

20 23-Nov Susan Others 1745 132.95

21 24-Nov Susan Sports goods 1662 2,580.10

22 Susan’s Total

23

24 Grand Total

(i). Calculate the totals for each salesperson and get the grand total.: (ii). Format the worksheet as follows:

Make all the Totals bold, two decimal places, comma, center the title across columns A-E

and make it size 16, bold and Italic.

(iii). Put a double border round the whole table and a single line border inside the table. (iv). Add a Pie 3D Chart with the Total Sales of each Sales Person (v). Save the worksheet as PE-EX-M1-EX2-YourName