I need the formula for each year

Hyanna. Rosario001 toSave 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 x x A B C D E F G H I J K L M N O P a 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 2013 2014 2015 2016 2017 2018 Stock Red City distances Sharedata Last Type here to search Hyanna. Rosario001 toSave 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 x x A B C D E F G H I J K L M N O P a 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 2013 2014 2015 2016 2017 2018 Stock Red City distances Sharedata Last Type here to search