FORMATTING
6. Insert 2 lines above the column titles
7. Title the worksheet as “British Football League Round 4 (Soccer)”
a. Center the title across the table
b. Use the any font you wish with a size of 16 points or larger
8. Center all of the column titles
a. DO NOT center 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 25 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…
c. Insert an image underneath the table.
i. Make sure it is appropriate to the subject
CHARTING
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 Arundel 4 15 vs Aveley 3 13
3 Mansfield 2 12 vs Hayes 5 14
4 Stoneham 3 10 vs Brimsdown 4 17
5 Totton 7 16 vs Manchester 3 15
6 Blackpool 4 12 vs Binfield 1 10
13. 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 SCORES
c. Add data labels
d. Title the chart: HOME TEAM TOTALS
FINAL TOUCHES
14. Change the page orientation to landscape
1. Complete the document properties:
a. enter your name
b. subject
c. Tags (use a minimum of 3 words – separated with commas)
i. Tags are NOT your initials, the words: Excel, exercise or practical .
They should be about the subject.
Hi there,
I think I am the right person who can take the responsibility for your project and can complete it according to your REQUIREMENTS, As I got all the skills that you need for this project.
Best Regards
Ibrahim H.
$10 USD in 1 day
0.0 (1 review)
0.0
0.0
8 freelancers are bidding on average $16 USD for this job
hi,
I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel.
I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me.
Thanks.
Excelente manejo de entrada de datos, puedo completar su hoja en el menor tiempo posible.
Excellent data entry handling, I can complete your sheet in the shortest time possible.
Hello,
Greetings,
I am a data entry expert. I have 7 years of experience in this field. I want to do this project and make you believe that you chose the right man for the right job. looking forward to your kind reply.
Jamal Ahmed
Hi there;
I am electrical engineer , I have a experience in engineering programs and microsoft package software included the excel , I have a perfect ability to do your project carefully. In addition I am sure you will be glad from my work.
I will take 10$ and I will finish it in 3 day.
I am a new here in freelancer website , I believe you will trust me from my work.
Thank you ;
Regards;