A rolling (or running total) is the sum of a sequence of numbers that is updated when a new number is added to the sequence. For example, a three-month rolling sales total captures the sales total from the three most recent months and a six-month rolling sales total captures the sales total from the six most recent months.

State	Nov-19	Dec-19	Jan-20
Massachusetts	3,879	9,590	261

Using the information above, the rolling sales for the three-months ended January 2020 for the state of Massachusetts are $13,730, which equals $3,879 + $9,590 + $261; the rolling sales for the two-months ended January 2020 for the state of Massachusetts are $9,851, which equals $9,590 + $261.

Your assignment is to:

• Correct spelling errors, in the spreadsheet, if any.
• Create two named ranges: one for the 2019 sales data and one for the 2020 sales data.
• Make any necessary print set-up adjustments so that I will be able to print all the 2019 sales data (with titles) on one page and all the 2020 sales data (with titles) on a second page via a single print command.
• Enable me to enter a number of months between 1 to 12 in cell B31. Using that number of months, calculate the rolling sales for each month in 2020 in cells N31 to Y31 using the offset command based on the number of months. For example, if 3 is entered into cell B31, the formula in cell N31 should capture the total sales for November 2019, December 2019, and January 2020.

 

Rolling Sales Report Homework State Massachusetts New Yorc Nebraska Florida Illinois Iowa Alaskai Texaa Georgai Nevada Arizona Californai Michigan Maine North Carolina Delawaer Washengton Hawaii New Jersey Oklahoma Oregon New Hampshire Connecticut Total Rolling sales months Jan-19 1,009 998 6,419 7,080 1,350 9,661 3,830 2,605 7,895 2,687 8,794 5,757 2,066 5,743 1,434 1,831 2,630 7,928 6,838 5,940 8,499 6,003 8,799 115,796 Feb-19 Mar-19 Apr-19 May-19 Jun-19 4,915 9,175 1,233 9,316 6,862 9,287 7,776 6,549 5,816 5,627 7,924 1,290 7,577 5,988 9,824 782 8,131 7,617 6,246 6,237 2,165 5,381 1,501 7,536 508 2,322 9,775 421 574 7,490 8,254 4,817 1,829 4,450 753 5,273 5,860 5,320 1,320 7,614 687 1,288 1,966 346 8,023 6,191 2,281 7,157 1,362 9,081 704 92,640 7,758 1,320 6,256 281 1,797 3,757 9,383 9,636 1,922 909 8,062 1,659 7,585 1,158 8,485 8,321 9,982 5,441 9,367 5,742 4,715 194 5,437 6,202 5,110 2,256 5,402 1,440 4,054 5,560 6,991 8,405 3,164 9,470 127,436 139,094 111,176 135,239 7,675 9,270 4,390 8,271 9,024 770 2,805 1,763 9,066 3,729 3,979 8,067 3,760 7,767 4,799 7,785 8,962 3,414 7,587 459 7,928 7,089 6,248 4,571 7,575 3,039 6,526 7,176 6,175 8,274 Jul-19 Aug-19 Sep-19 Oct-19 2,643 7,926 9,573 5,922 4,782 1,139 8,272 4,798 7,057 9,060 6,488 3,381 9,431 7,029 1,011 5,632 5,844 9,094 880 5,943 5,835 2,796 4,905 6,732 3,478 5,232 4,621 9,930 3,708 6,569 2,563 3,111 8,970 6,598 3,603 3,496 9,733 5,826 6,042 727 1,720 272 4,056 8,266 2,810 5,801 9,765 4,681 4,065 6,781 5,612 1,748 136 4,160 4,053 9,961 1,239 4,416 8,359 6,786 9,014 1,713 6,967 9,097 5,803 7,972 6,997 8,268 2,855 6,195 6,763 4,461 1,639 3,192 3,470 3,433 3,134 6,192 8,389 7,759 4,331 4,563 4,685 1,482 6,813 7,008 2,502 127,441 103,646 137,688 123,675 6,604 7,189 7,314 4,488 3,374 2,146 9,444 9,462 2,715 2,453 8,063 8,518 118,675 Nov-19 3,879 1,839 2,586 9,394 441 3,796 7,827 6,075 7,232 7,872 7,771 5,243 5,667 4,697 1,206 4,066 Dec-19 9,590 4,438 9,511 4,010 4,518 6,543 9,005 7,232 9,327 2,192 7,047 7,156 3,989 3,911 6,925 938 8,709 1,284 8,604 8,299 1,686 7,139 1,785 133,838 Jan-20 261 2,722 3,539 9,135 6,785 3,177 2,249 5,434 4,755 7,332 4,113 9,569 405 252 2,145 9,366 9,819 14 8,454 6,038 2,038 4,041 7,945 109,588 Mar-20 Apr-20 2,031 3,626 7,410 2,957 225 6,856 8,928 8,604 6,599 3,373 561 2,454 8,016 1,779 2,322 2,316 7,015 3,309 547 1,071 4,900 5,745 4,944 7,601 8,242 7,805 9,284 178 220 4,248 5,026 6,882 8,571 3,914 630 28 5,984 2,603 2,954 4,789 7,690 90,822 106,041 Feb-20 777 2,302 1,635 4,836 1,706 9,866 3,908 943 7,332 2,360 198 883 5,589 3,727 1,665 4,831 9,652 9,864 1,355 2,476 7,525 8,215 Nov-20 Dec-20 6,254 3,180 8,241 2,235 12 6,060 3,595 1,780 8,099 May-20 Jun-20 Jul-20 Aug-20 Sep-20 2,389 3,359 462 1,472 1,032 9,961 4,281 2,579 7,008 5,919 2,250 8,356 104 2,836 2,443 984 4,317 2,319 2,831 9,796 2,021 1,815 3,461 5,162 4,790 1,218 712 2,882 3,761 6,443 3,791 907 4,694 3,777 3,303 9,466 5,568 1,450 3,348 2,072 2,953 2,561 910 9,325 6,376 1,232 4,285 5,547 5,296 2,363 2,704 2,298 9,842 9,900 8,593 138 6,814 4,036 6,927 5,738 798 2,037 7,573 6,940 8,196 8,905 8,095 5,809 4,983 8,556 3,590 2,226 3,652 7,647 5,889 9,598 8,689 8,706 1,480 9,195 9,598 6,680 5,833 307 6,116 3,244 5,946 4,542 1,618 8,053 8,927 3,385 6,537 907 9,470 856 1,817 5,446 823 464 9,456 10 6,196 7,838 1,099 2,726 881 9,297 9,811 4,810 120 1,856 268 8,638 8,981 797 3,248 3,517 6,299 7,894 1,370 107,495 107,881 105,736 72,148 114,895 120,635 112,219 117,713 Oct-20 7,740 2,461 5,768 4,797 9,344 6,855 9,208 9,995 1,198 8,793 1,986 2,184 5,133 485 6,114 5,005 8,395 529 213 4,537 1,488 2,828 471 1,450 1,071 8,091 9,585 7,208 7,468 4,384 5,996 9,267 232 1,169 9,445 6,243 3,165 600 7,163 9,302 6,020 6,608 1,536 9,817 2,232 9,626 8,143 7,453 5,107 9,743 7,824 2,338 2,097 9,166 4,672 2,239 2,040 6,329 3,567 5,118 118,216 Rolling Sales Report Homework State Massachusetts New Yorc Nebraska Florida Illinois Iowa Alaskai Texaa Georgai Nevada Arizona Californai Michigan Maine North Carolina Delawaer Washengton Hawaii New Jersey Oklahoma Oregon New Hampshire Connecticut Total Rolling sales months Jan-19 1,009 998 6,419 7,080 1,350 9,661 3,830 2,605 7,895 2,687 8,794 5,757 2,066 5,743 1,434 1,831 2,630 7,928 6,838 5,940 8,499 6,003 8,799 115,796 Feb-19 Mar-19 Apr-19 May-19 Jun-19 4,915 9,175 1,233 9,316 6,862 9,287 7,776 6,549 5,816 5,627 7,924 1,290 7,577 5,988 9,824 782 8,131 7,617 6,246 6,237 2,165 5,381 1,501 7,536 508 2,322 9,775 421 574 7,490 8,254 4,817 1,829 4,450 753 5,273 5,860 5,320 1,320 7,614 687 1,288 1,966 346 8,023 6,191 2,281 7,157 1,362 9,081 704 92,640 7,758 1,320 6,256 281 1,797 3,757 9,383 9,636 1,922 909 8,062 1,659 7,585 1,158 8,485 8,321 9,982 5,441 9,367 5,742 4,715 194 5,437 6,202 5,110 2,256 5,402 1,440 4,054 5,560 6,991 8,405 3,164 9,470 127,436 139,094 111,176 135,239 7,675 9,270 4,390 8,271 9,024 770 2,805 1,763 9,066 3,729 3,979 8,067 3,760 7,767 4,799 7,785 8,962 3,414 7,587 459 7,928 7,089 6,248 4,571 7,575 3,039 6,526 7,176 6,175 8,274 Jul-19 Aug-19 Sep-19 Oct-19 2,643 7,926 9,573 5,922 4,782 1,139 8,272 4,798 7,057 9,060 6,488 3,381 9,431 7,029 1,011 5,632 5,844 9,094 880 5,943 5,835 2,796 4,905 6,732 3,478 5,232 4,621 9,930 3,708 6,569 2,563 3,111 8,970 6,598 3,603 3,496 9,733 5,826 6,042 727 1,720 272 4,056 8,266 2,810 5,801 9,765 4,681 4,065 6,781 5,612 1,748 136 4,160 4,053 9,961 1,239 4,416 8,359 6,786 9,014 1,713 6,967 9,097 5,803 7,972 6,997 8,268 2,855 6,195 6,763 4,461 1,639 3,192 3,470 3,433 3,134 6,192 8,389 7,759 4,331 4,563 4,685 1,482 6,813 7,008 2,502 127,441 103,646 137,688 123,675 6,604 7,189 7,314 4,488 3,374 2,146 9,444 9,462 2,715 2,453 8,063 8,518 118,675 Nov-19 3,879 1,839 2,586 9,394 441 3,796 7,827 6,075 7,232 7,872 7,771 5,243 5,667 4,697 1,206 4,066 Dec-19 9,590 4,438 9,511 4,010 4,518 6,543 9,005 7,232 9,327 2,192 7,047 7,156 3,989 3,911 6,925 938 8,709 1,284 8,604 8,299 1,686 7,139 1,785 133,838 Jan-20 261 2,722 3,539 9,135 6,785 3,177 2,249 5,434 4,755 7,332 4,113 9,569 405 252 2,145 9,366 9,819 14 8,454 6,038 2,038 4,041 7,945 109,588 Mar-20 Apr-20 2,031 3,626 7,410 2,957 225 6,856 8,928 8,604 6,599 3,373 561 2,454 8,016 1,779 2,322 2,316 7,015 3,309 547 1,071 4,900 5,745 4,944 7,601 8,242 7,805 9,284 178 220 4,248 5,026 6,882 8,571 3,914 630 28 5,984 2,603 2,954 4,789 7,690 90,822 106,041 Feb-20 777 2,302 1,635 4,836 1,706 9,866 3,908 943 7,332 2,360 198 883 5,589 3,727 1,665 4,831 9,652 9,864 1,355 2,476 7,525 8,215 Nov-20 Dec-20 6,254 3,180 8,241 2,235 12 6,060 3,595 1,780 8,099 May-20 Jun-20 Jul-20 Aug-20 Sep-20 2,389 3,359 462 1,472 1,032 9,961 4,281 2,579 7,008 5,919 2,250 8,356 104 2,836 2,443 984 4,317 2,319 2,831 9,796 2,021 1,815 3,461 5,162 4,790 1,218 712 2,882 3,761 6,443 3,791 907 4,694 3,777 3,303 9,466 5,568 1,450 3,348 2,072 2,953 2,561 910 9,325 6,376 1,232 4,285 5,547 5,296 2,363 2,704 2,298 9,842 9,900 8,593 138 6,814 4,036 6,927 5,738 798 2,037 7,573 6,940 8,196 8,905 8,095 5,809 4,983 8,556 3,590 2,226 3,652 7,647 5,889 9,598 8,689 8,706 1,480 9,195 9,598 6,680 5,833 307 6,116 3,244 5,946 4,542 1,618 8,053 8,927 3,385 6,537 907 9,470 856 1,817 5,446 823 464 9,456 10 6,196 7,838 1,099 2,726 881 9,297 9,811 4,810 120 1,856 268 8,638 8,981 797 3,248 3,517 6,299 7,894 1,370 107,495 107,881 105,736 72,148 114,895 120,635 112,219 117,713 Oct-20 7,740 2,461 5,768 4,797 9,344 6,855 9,208 9,995 1,198 8,793 1,986 2,184 5,133 485 6,114 5,005 8,395 529 213 4,537 1,488 2,828 471 1,450 1,071 8,091 9,585 7,208 7,468 4,384 5,996 9,267 232 1,169 9,445 6,243 3,165 600 7,163 9,302 6,020 6,608 1,536 9,817 2,232 9,626 8,143 7,453 5,107 9,743 7,824 2,338 2,097 9,166 4,672 2,239 2,040 6,329 3,567 5,118 118,216