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:
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted: