Introduction to Information Technology

Introduction to Information Technology

CGS1030 – Fall A

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
CALCULATIONS3. Calculate the Total Score for the Home and Away Teamsa. The Total Score is 3 points for each goal plus the Pointsb. These are for columns D and I4. Add the word TOTALS in cell A7a. Find the total goals and pointsb. These are for columns B, C, G and H5. Add the word Winner to column Ja. Use the IF functionb. Use the Goals scored by each team to determine which team is the winner. Enter the winning team Name in column JFORMATTING6. Insert 2 lines above the column titles7. Title the worksheet as “British Football League Round 5 (Soccer)”a. Center the title across the tableb. Use the font Algeria size 16 points8. Center all of the column titles except for columns A and F9. Bold the column titles10. 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 Background11. Name the worksheet RESULTS. Color the tab Purple12. Format the rest of the table to your likinga. Add borders around the cellsb. Apply different colors, etc…13. Insert a clipart image to the right of the table.a. Be sure the image is appropriate to the data on the worksheetCHARTING14. Graph the Home Teams and their corresponding Total Scoresa. Use a 3d Column Cluster Chartb. Move the chart to a new sheet called Scoresi. Make sure you can see the data labelsii. make sure the title says TOTAL SCOREc. Add a title to both Axis’
FINAL TOUCHES15. Change the page orientation to both the table and chart to landscape16. Complete the document properties with your name, subject and tags (use a minimum of 3 words – separated by commas)