Page 393 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

• After clicking on Summary, a Scenario Summary dialog box appears for you to put Result cells (B7 in this
case) and choose between Scenario summary. At last, press the OK option.

As a result, you will be able to create the scenario summary report

Related Exercises:

Question 1: Sales Projection Scenarios
Suppose you have a sales projection table like this:

Month Scenario A Scenario B Scenario C

January 1000 1200 900
February 1100 1300 950

March 1050 1250 920

378
CITS : IT & ITES - Computer Software Application - Exercise 65