This exercise introduces several features in Excel that aid in developing revenue projections using trend analysis and a moving average. The first task involves correcting the historical data on sales tax collections for inflation. The dataset is actual sales tax collections by month from October FY01 through February FY22. The corresponding consumer price index (CPI) for each month is provided. The data can be used to evaluate current-year trends as well as to project revenue for the next budget year. The assignment is to develop a moving average trend for the inflation-adjusted sales tax collections, compute the month-to-month percentage change in collections, and graphically display those percentage changes. Download detailed instructions, data set, and trendline interpretation tutorial for this exercise.