Week 6 Practical Exercise

Introduction to Information Technology CGS1030 – Intro to IT

Insert the following table into Sheet1 of an Excel spreadsheet, keeping the cell references consistent.

1. Copy the data below into an Excel Spreadsheet. Keep the data as indicated on the columns and rows.

2. Save your work as yourname_P3

CALCULATIONS

3. Calculate the Total Score for the Home and Away Teams a. The Total Score is 4 points for each goal plus the Points b. These are for columns D and I

4. Enter the Row Title: TOTALS in cell A7 5. Calculate the following totals:

a. Find the total goals and points b. These are for columns B, C, G and H ONLY

FORMATTING 6. Insert 2 lines above the column titles 7. Title the worksheet as “British Football League Round 3 (Soccer)”

a. Center the title across the table b. Use the font Algeria size 16 points

8. Center all of the column titles except for column A and F 9. Bold the column titles 10. Use conditional formatting for the TOTAL SCORE for the Home team.

a. Format the cells that show 20 points and greater to a BOLD white font with a Dark Blue Background

i. NOTE: This is only for the specific column, not the entire table. 11. Name the worksheet tab RESULTS. 12. Color the tab Purple 13. Format the rest of the table to your liking

a. Add borders around the cells b. Apply different colors, etc…

14. Insert an image appropriate to the data on the worksheet to the right of the table.

A B C D E F G H I J

1 Home Team Goals Points Total Score Away Team Goals Points

Total Score Winner

2 Liverpool 3 11 vs Wimbledon 4 14 3 Mansfield 2 6 vs Hayes 7 13 4 Stoneham 4 16 vs Sudbury 3 9 5 Darwen 1 11 vs Manchester 2 11 6 Blackpool 2 4 vs Bamsley 4 6

CHARTING 15. Graph the Home Team and their corresponding Total Score

a. Use a 3d Column Cluster Chart b. Move the chart to a new sheet called Home Team c. Make sure you can see the data labels and make sure the title says

TOTAL SCORE FINAL TOUCHES

16. Change the page orientation to landscape 17. Change the Document Properties

i. Add your name ii. Add the subject iii. Add TAGS (Use a minimum of 3, separated by commas)