Wk Qu. 4-11 In the spreadsheet model. In the spreadsheet model shown below, an analyst makes...

 

Transcribed Image Text:

Wk Qu. 4-11 In the spreadsheet model. In the spreadsheet model shown below, an analyst makes the following data entries. Cell B3 B4 B5 B6 92,000 Value 110,000 83,000 82,000 A B Revenue 2 Month Revenue Change (%) 3 January 4 February 5 March 6 April n/a =(B4-B3)/83 =(85-84)/84 =(86-85)/85 What values will be shown in the following cells? (Negative values should be indicated by a minus si decimal places.) Cell Value C4 C5 C6 Wk Qu. 4-11 In the spreadsheet model. In the spreadsheet model shown below, an analyst makes the following data entries. Cell B3 B4 B5 B6 92,000 Value 110,000 83,000 82,000 A B Revenue 2 Month Revenue Change (%) 3 January 4 February 5 March 6 April n/a =(B4-B3)/83 =(85-84)/84 =(86-85)/85 What values will be shown in the following cells? (Negative values should be indicated by a minus si decimal places.) Cell Value C4 C5 C6

Answer rating: 100% (QA)

Cell C4 C4 B4 B3 B3 83000 111000 111000 2455 Cell C5 ... View the full answer