Page 394 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

Question: How can you use Excel scenarios to compare different sales projections for the first quarter?
Steps to do :
1 Fill in the actual budget allocations in the “Actual” column.
2 Go to the “Data” tab, click on “What-If Analysis,” and select “Scenario Manager.”
3 Click on “Add” to create new scenarios, naming them as needed (e.g., Scenario 1, Scenario 2).

4 Input different budget allocations for each scenario.
5 By switching between scenarios, you can compare the impact of different budget allocations on departmental
spending.

Question 2: Project Timeline Scenarios
Imagine a project timeline table like this:

Task Duration (Days) Scenario 1 Scenario 2
Research 10

Development 20
Testing 15

Deployment 5
Question: How can you use scenarios to analyze different project completion timelines?

Steps to do:
1 Enter the duration of each task in the “Duration (Days)” column.
2 Go to the “Data” tab, click on “What-If Analysis,” and select “Scenario Manager.”
3 Create new scenarios (e.g., Scenario 1, Scenario 2) and input different durations for each task.

4 By comparing scenarios, you can assess how adjustments in task durations impact the overall project timeline.

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