Introduction to Information Technology DQ

Introduction to Information Technology DQ
Introduction to Information Technology DQ
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.

 
A
B
C
D
E
F
G
H
I

1
Home Team
Goals
Points
Total Score
 
Away Team
Goals
Points
Total Score

2
Liverpool
5
11
 
vs
Wimbeldon
7
16
 

3
Mansfield
4
10
 
vs
Hayes
2
12
 

4
Stoneham
2
12
 
vs
Sudbury
5
11
 

5
Darwen
5
13
 
vs
Manchester
1
15
 

6
Blackpool
3
12
 
vs
Bamsley
2
9
 

 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 

 
2. Save your work as yourname_P3
ORDER NOW FOR CUSTOMIZED, PLAGIARISM-FREE PAPERS
CALCULATIONS
3. Calculate the Total Score for the Home and Away Teams
a. The Total Score is 3 points for each goal plus the Points
b. These are for columns D and I
4. Add the word TOTALS in cell A7
a. Find the total goals and points
b. These are for columns B, C, G and H
5. Add the word Winner to column J
a. Use the IF function
b. Use the Goals scored by each team to determine which team is the winner. Enter the winning team Name in column J
FORMATTING
6. Insert 2 lines above the column titles
7. Title the worksheet as “British Football League Round 5 (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 columns 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
11. Name the worksheet RESULTS. Color the tab Purple
12. Format the rest of the table to your liking
a. Add borders around the cells
b. 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 worksheet
 
 
Introduction to Information Technology DQ
CHARTING
14. Graph the Home Teams and their corresponding Total Scores
a. Use a 3d Column Cluster Chart
b. Move the chart to a new sheet called Scores
i. Make sure you can see the data labels
ii. make sure the title says TOTAL SCORE
c. Add a title to both Axis’
 
FINAL TOUCHES
15. Change the page orientation to both the table and chart to landscape
16. Complete the document properties with your name, subject and tags (use a minimum of 3 words – separated by commas)
You must proofread your paper. But do not strictly rely on your computer’s spell-checker and grammar-checker; failure to do so indicates a lack of effort on your part and you can expect your grade to suffer accordingly. Papers with numerous misspelled words and grammatical mistakes will be penalized. Read over your paper – in silence and then aloud – before handing it in and make corrections as necessary. Often it is advantageous to have a friend proofread your paper for obvious errors. Handwritten corrections are preferable to uncorrected mistakes.
Use a standard 10 to 12 point (10 to 12 characters per inch) typeface. Smaller or compressed type and papers with small margins or single-spacing are hard to read. It is better to let your essay run over the recommended number of pages than to try to compress it into fewer pages.
Likewise, large type, large margins, large indentations, triple-spacing, increased leading (space between lines), increased kerning (space between letters), and any other such attempts at “padding” to increase the length of a paper are unacceptable, wasteful of trees, and will not fool your professor.
The paper must be neatly formatted, double-spaced with a one-inch margin on the top, bottom, and sides of each page. When submitting hard copy, be sure to use white paper and print out using dark ink. If it is hard to read your essay, it will also be hard to follow your argument.
Get a 10 % discount on an order above $ 100 Use the following coupon code : NURSING10