Using the data for Problem 14 in Chapter 22, The OFFSET function, create a spinner that lets

Question:

Using the data for Problem 14 in Chapter 22, “The OFFSET function,” create a spinner that lets you graph the last few months of sales (ranging from three to eight months).

Data from in problem 14

The file named Yeartodate.xlsx contains a company’s monthly sales from January 2008 through August 2013. Write a formula that returns for a given year and month of a year the year’s cumulative sales to date. For example, if you enter a 6 for the month and 2010 for the year, your formula should compute total sales for the period January through June of 2010.

Step by Step Answer:

Question Posted: