Week 6 Practical Exercise

Week 6 Practical Exercise

Excel Practical – Exercise 4

Insert the following table into Sheet1 of an Excel spreadsheet, keeping the

cell references consistent.

1. Copy the data from the table (3rd page) into an new Excel Spreadsheet.

Keep the data as indicated on the columns and rows. 2. Save your work as: yourname_P4

3. Add the column title (D1): Humor Rating (out of 10)

CALCULATIONS

4. Calculate the Humor Rating based on the scores on the 2nd set of numbers (table starts in cell A10)

a. Format these numbers to only 1 decimal point

CHARTING 5. Create a 3-D Column Chart. Chart the Humor Rating and Muppet Name

a. Place the chart in a new worksheet title: Humor Rating b. Color the tab Blue

c. Show the Muppets Names and Humor Rating on the chart

a. Use data labels

FORMATTING 6. Insert 2 rows at the top of the worksheet

7. Add the title (A1): The Muppets – Vital Statistics a. Center the title across the table

b. Make it bold and underline it c. Chose the color and size font that is appropriate

8. Color each row with the color indicated in column C for each muppet. 9. Format the rest of the table to your liking.

a. Choose appropriate fonts b. Choose appropriate border

10. Format the Humor Rating table to your liking a. Place borders around all of the cells

b. Center the Scores

11. Bold the Column title in Row 3 and center them 12. Change the Tab Name and color to: Muppets and color it purple

13. Use Conditional Formatting to color the Humor Rating of 7.3 and higher to Bold White Font with a Dark Blue Background

14. Fix the column widths so that you can see all of the data 15. Change the worksheets to Landscape orientation

FINISHING TOUCHES 16. Insert a header in the center section.

a. Type your name and <enter> b. Type the course ID (CGS1030)

17. Insert an image of the Muppets to the right of the table 18. Change the Document Properties

a. Include your name b. Subject

c. Tags (minimum of 3 – separate by commas)

A B C D E F G H I J K

1 Muppet Name Creature

Type

Color

2 Kermit Frog Green

3 Miss Piggy Swine Pink

4 Waldorf &

Statler

Grumpy Men Pink

5 Gonzo Unknown Blue/Gray

6 Animal Percussionist Red

7 Swedish Chef Swede Tan

8 Fozzie Bear Brown

9

10 Humor Rating

11 Score 1 Score 2 Score 3 Score 4 Score 5 Score 6 Score 7 Score 8 Score 9 Score 10

12 Kermit 6 5.8 6.3 8.122 8.3 7.55 7.6 8.5 7.1 6.6

13 Miss Piggy 4.3 5.6 3.8 7.53 8.4 6.8 4.9 8.1 9.1 7.7

14 Waldorf &

Statler

4.9 4.9 9.2 8.4 7.5 9.64 8.3 4.5 9.64 9.62

15 Gonzo 8.2 5.7 5.79 7.5 8 7.2 9.4 5.9 8.32 8.4

16 Animal 7.6 3.9 6.8 9.26 4.68 7.9 7.2 6.1 6.9 5.66

17 Swedish Chef 7.6 4.8 4.82 4.9 6.8 8.22 6.8 7.9 7.28 8.3

18 Fozzie 6.7 8.9 3.2 8.3 8.34 7.5 9.12 8.45 7.88 8.12