Question

ABC Sports expects its sales figures for 2015 to exceed the sales in 2014 by 10%. Create the following spreadsheet:
ABC Sports Yearly Sales Report 2015 Sales Increase 10%
2014 2015
Football 102,078
Basketball 202,090
Tennis 20,034
Netball 50,234
Golf 12,211
Total
a) Enter a formula in C54 that will calculate the amount of the sales for 2015.
Use an absolute reference in order that the manager can change the rate of the
expected increase to be able to view likely sales figures for 2015.
b) Change the rate of the sales increase to 20% and then 25% and see what
happens to the 2015 figures.
c) Total the sales for the year 2014 and 2015

Answer 1

Answer:

Clear your question

It is not understood by you..

Answer 2

You must click the photo of question