Collingwood and Essendon Scores - Accounting Assignment Help

Assignment Task

Q1 Question 
The following AFL football scores were recorded for round 20 in AFL season 2013.
Team  Goals Points  Total  Vs  Team  Goals  Points  Total 
Collingwood  20 13 133 Vs  Essendon  7 12 54
Adelaide  15 13 103 Vs  Port Adelaide  17 5 107
Bulldogs  15 9 99 Vs  Sydney  11 11 77
Carlton  12 8 80 Vs  Fremantle  17 14 116
West Coast  20 10 130 Vs  Gold Coast  17 11 113
Hawthorn  9 12 66 Vs  Richmond  16 11 107
Greater Western Sydney  19 10 124 Vs  Melbourne  12 15 87
North Melbourne  15 6 96 Vs  Geelong  13 8 86
Each goal is worth six points.
Prepare a spreadsheet to show the results from round 20 of the AFL 2013 season.
Use a formula to calculate the total score for each team and extend that formula to all teams in the column.
Create a main heading for the spreadsheet in merged cells across the page.
Adjust the size of columns and rows so that it prints well on an A4 page. You may choose landscape or portrait printing.
Use cell styles to colour the winning team’s cells green.
Add a comment ‘Winner’ in the cell of the name of each winning team.
Q2 Question 2
You may need to rearrange the data, to have all the data in one column in order to make the following charts:
Present the football scores (total only) as a Bar Chart and a Column Chart.
Make sure the chart looks good and has all the appropriate titles and labels
Q3 Question 3
Use the following Collingwood and Essendon scores as the basis for a Pie Chart.
Team  Goals Points  Total  Vs  Team  Goals  Points  Total 
Collingwood  20 13 133 Vs  Essendon  7 12 54
Present a Pie Chart for the total of each teams score as a percentage of the total score of both teams combined. 
Show a label with the % of the combined score for each team 
Make sure the chart looks good and has all the appropriate titles and labels 
Insert a picture or logo of both football teams in the chart (you will find a logo quite easily in an images search in google) 
Q4 Question 4
Using the same football scores create a spreadsheet and calculate the following information using formula:
The average score of all the teams from that round. 
The total number of goals scored that round. 
Q5 Question 5
Create a sales report for the month of June 2013 for the six hardware stores in you group.
Sales were:
Bankstown                           $78 526
Penrith                                  $96 333
Foster                                    $32 200
Redfern                                 $41 880
Dubbo                                   $102 300
Tamworth                             $36 500
Create a spreadsheet with the sales information. 
Create a Column Chart with the sales of each store.
Create a pie chart to show the sales of each store as a % of the sales of the group as a whole. 
Show the total sales of the group.
Show the average sales of the group.
If new renovations to the Foster store produce a 50% increase in sales. Show the new pie chart to show the sales of each store as a % of the sales of the group as a whole. Assuming all the other sales remained the same. 
Add a footer to the page showing ‘Sales June 2013’ 
Format the document to ensure it looks professional. 
Q6 Question 6
A publisher has the following book sales for July 2013
 

This Management Assignment has been solved by our Management Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
    
Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.