Question

Monthly net sales are given in Table 8, compute cumulative sales using Formula with appropriate cell references. (a) Write a formula in cell D86 to calculate "Year to Date Cumulative Net Sales" based on the Monthly Net Sales amounts in Table 8 (C86:C97) Apply the "Monthly Net Sales" (B86) to determine the "Year To Date Cumulative Net Sales" in cell D86 and copy over and down through to cell D97. You should write a formula such that when the Formula is copied, it computes the "Year To Date Cumulative Net Sales" amount correctly. Hint: Please go through Learning Exercise 8.6, a similar exercise was solved. Table 8 : Cumulative Net sales Month Monthly Net sales Year to Date Cumulative Net sales January $ 73,700 February $ 93,500 March $ 100,050 April $ 86,400 May $ 82,000 June $ 96,800 July $ 103,050 August $ 94,450 September $ 96,100 October $ 130,000 November $ 141,000 December $ 120,950

          Monthly net sales are given in Table 8, compute cumulative sales using Formula with appropriate cell references.
(a) Write a formula in cell D86 to calculate "Year to Date Cumulative Net Sales" based on the Monthly Net Sales amounts in Table 8 (C86:C97)
Apply the "Monthly Net Sales" (B86) to determine the "Year To Date Cumulative Net Sales" in cell D86 and copy over and down through to cell D97.
You should write a formula such that when the Formula is copied, it computes the "Year To Date Cumulative Net Sales" amount correctly.
Hint: Please go through Learning Exercise 8.6, a similar exercise was solved.
Table 8 : Cumulative Net sales
Month	Monthly Net sales	Year to Date Cumulative Net sales
January	$	73,700
February	$	93,500
March	$	100,050
April	$	86,400
May	$	82,000
June	$	96,800
July	$	103,050
August	$	94,450
September	$	96,100
October	$	130,000
November	$	141,000
December	$	120,950

Monthly net sales are given in Table 8, compute cumulative sales using Formula with appropriate cell references.
(a) Write a formula in cell D86 to calculate "Year to Date Cumulative Net Sales" based on the Monthly Net Sales amounts in Table 8 (C86:C97)
Apply the "Monthly Net Sales" (B86) to determine the "Year To Date Cumulative Net Sales" in cell D86 and copy over and down through to cell D97.
You should write a formula such that when the Formula is copied, it computes the "Year To Date Cumulative Net Sales" amount correctly.
Hint: Please go through Learning Exercise 8.6, a similar exercise was solved.
Table 8 : Cumulative Net sales
Month Monthly Net sales Year to Date Cumulative Net sales
January 73,700
February 93,500
March 100,050
April 86,400
May 82,000
June 96,800
July 103,050
August 94,450
September 96,100
October 130,000
November 141,000
December 120,950

Added by Willie T.

Question

Please give Ace some feedback