Question

llyanna.Rosario001 toSave om 8 - Excel Chap2 Assignment_V3 (1) - Protected View Search Home Insert Draw Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View Enable Editing - Xe B C D A E F G H I J K L M N O P o Problem 6 Instructions Create a dynamic range name that averages the past five years (Not including the present year) of sales data **Hint 1"* Use example Last year.xlsx for reference **Hint 2** You need to have s previous years to start your computation Year Sales Average of Last 5 Years 10 2010 2013 2014 2015 2016 2017 2018 Stock Red City distances Sharedata Lasts Type here to search

Answer 1

Average of Last 5 year’s computed as follows.

Year	Sale	Average of Last 5 Years
2008	10
2009	20
2010	30
2011	40
2012	50
2013	45	30.0
2014	73	37.0
2015	87	47.6
2016	43	59.0
2017	54	59.6
2018	65	60.4

Computations:

For 2013 = Average Sales from 2008 to 2012 (Last 5 years)

                = (10+20+30+40+50)/5 = 30

For 2014 = Average Sales from 2009 to 2013 (Last 5 years)

                = (20+30+40+50+45)/5 = 37

For 2015 = Average Sales from 2010 to 2014 (Last 5 years)

                = (30+40+50+45+73)/5 = 47.6

For 2016 = Average Sales from 2011 to 2015 (Last 5 years)

                = (40+50+45+73+87)/5 = 59

For 2017 = Average Sales from 2012 to 2016 (Last 5 years)

                = (50+45+73+87+43)/5 = 59.6

For 2018 = Average Sales from 2013 to 2017 (Last 5 years)

                = (45+73+87+43+54)/5 = 60.4