Reference no: EM13943842
Insert the following table into Sheet1 of an Excel spreadsheet, keeping the cell references consistent. ( The Sheet is already created in the second file)
A B C D E F G H I J
1
2 Irish Football League Round 3 (Soccer)
3
4 Home Team Goals Points Total Score Away Team Goals Points Total Score Winner
5 Clare 2 12 vs Kerry 3 11
6 Cork 2 13 vs Limerick 1 12
7 Roscommon 0 12 vs Sligo 1 15
8 Meath 1 20 vs Derry 2 12
9 Down 1 10 vs Dublin 0 14
10 Totals
11
12 Home Team Name Score
13
1. Rename Sheet 1 as Results. Color the tab Blue.
2. Merge and center cells A2:J2. Font: Algerian, Size: 16
3. Bold Titles in Row 4 and Row 12. Bold Totals in cell A10.
4. Place a double line border around every cell in the table. Place your name as a comment in cell A2.
5. Center all columns except column A and column F
6. Change the format of the cell A5 to Blue Font with a Light Green Background
7. Calculate the following
a. Total Score for both teams (3 points for every goal), include points
b. Totals - A total of all the goals and points scored
8. In the winner column, insert a formula that will show the winner (showing either Home or Away based on whichever of the two teams Total Score is larger).
9. Sort the table in alphabetical order of Home Team.
10. Insert a clipart image to the right of the table.
11. Graph the Home Team and their corresponding Total Score. Use a column chart and ensure that there are data labels on the chart. Place the graph under the table.
12. Insert a formula (use VLOOKUP) in cell B13, so that the Total Score of the Home Team will appear once the user types the team name in cell A13.
13. Change Page Setup to Landscape, with all Margins set to 0.5 inch.
Attachment:- Final practice (2).zip
|
Relationship with the community
: Task Mr Jack testified of his blood sugar level being under control, his relationship with the community is civil. He complied with his medication and his spiritual needs are met. How would you analyse the care given to Mr Jack in terms of the hol..
|
|
How to compute each of the cash inflows and cash outflows
: How to compute each of the cash inflows and cash outflows from operating activities under the direct method. Why is depreciation expense not generally reported on the statement of cash flows when using the direct method?
|
|
The mass flow rate of cold fluid
: In a 1-1 shell and tube heat exchanger , steam is condensing on the shell side at Tso c and the cold fluid is being heated on the tube side from t1 oc to t2 oc . the following equation relates t2 to the other vari..
|
|
Describe a process to recruit and select new employees
: Describe a process to recruit and select new employees who are aligned with the organization's vision and goals. Your description must demonstrate a nuanced understanding of the relationship between recruiting and the organization's vision and go..
|
|
Insert a clipart image to the right of the table.
: Insert the following table into Sheet1 of an Excel spreadsheet, keeping the cell references consistent
|
|
Critical analysis of a criminological theory
: Critical analysis of a criminological theory - Locate a newspaper article on an Australian criminal event. In the essay, you will provide a synopsis of the criminal event and explain the causes of the incident using three criminological theories of..
|
|
Write a report on airline industry and companies in india
: Write a report on Airline Industry & Companies in India describing General Trends in Growth, Profitability and Forecast. What are the key Constraints of the Airline Industry? Describe Porter's Five Forces Model. Also include Aviation Industry Cluster..
|
|
Do we know whether the ideas work or not
: Do we know whether the ideas work or not? Are there any practical "strategic" recommendations for leaders based on that theory?
|
|
What review process does facebook data scientists
: 1.What review process does Facebook data scientists have to go through in order to launch a psychological study?Thousands of Facebook Inc. users received an unsettling message two years ago: They were being locked out of the social network because Fa..
|