Excel exercises

profilenathaly20
Excel-P4-18FA1.docx

EXCEL PRACTICAL EXERCISE – 4

Formulas and Charting

Instructions:

1. Copy the following data into a new Excel spreadsheet. Be sure to keep the cell data the same.

A

B

C

D

E

1

Items

Batman

The Hulk

Captain America

Thor

2

Capes

17

0

0

12

3

Suits/Body Armor

6

0

13

5

4

Masks

6

0

5

0

5

Other Articles of Clothing

5

18

4

9

2. Save the workbook as yourname_P4

3. Beginning with cell A10 add the following information:

a. Capes (cell A10) $ 9.32 (cell B10)

b. Suits/Body Armor (cell A11) $ 14.43 (cell B11)

c. Masks (cell A12) $ 3.68 (cell B12)

d. Other Articles of clothing (cell A13) $ 4.81 (cell B13)

e. Tax: (A14) 8.23% (cell b14)

4. In Column F (F1) add the column title No. of Items

5. In Row 6 (A6) add the row title Item Costs

6. In Row 7 (A7) add the row title Tax

7. In Row 8 (A8) add the row title Total Due

8. In column F

a. Calculate the total number of items brought in for laundry service

9. In Row 6 calculate the total amount due for all items

a. use the information from step 3

b. Be sure to use ABSOLUTE REFERENCE to calculate the Item Totals

i. Use the Fill Handle to copy the formulas

10. In Row 7 calculate the tax amount that is due for all items

11. In Row 8 calculate the Total Due for items and tax

12. Insert 2 rows above the table

13. In cell A1 add the title Superhero Dry Cleaners

14. Change the Font, Font Size and Color of your Title

a. Size 20

b. Font: Ravie

c. Color: (You Choose)

15. Center the Title across the table

16. Change the font of table cells

a. Font: (You choose)

b. Size: 20pt

c. Color: (You Choose)

17. Place a Border around all the cells in the table

a. Format the rest of the table to your liking

18. Center all of the data except for column A

19. Adjust column widths as needed

20. Change the name of the worksheet to Dry Cleaners and color the tab RED

GRAPH

21. Create a Column Chart showing the Total Due by each of the Superheroes

22. Move the Graph underneath the Table

FINISHING TOUCHES

23. Change the page orientation to landscape

24. Enter your name, Course ID, Date and Instructor Name underneath the chart

25. Complete the Document Properties with your name, subject and Tags (use a minimum of 3 key words, separate with commas)