Page 167 - IT 402 v2.0 class 10
P. 167
Lab Assignment ‘n Activity I nte r - D is cip l inar y
Complete the following activities and tick on the circle.
se the Subtotal command to display the otal Fee collected for each class.
lso display rand otal Fee collected from all classes.
sing Subtotal calculate the revenue generated from the sale of each good.
GOODS PRICE
Pen 1000
Pencil 2000
Pen 500
Pencil 1200
Pen 500
Pencil 200
WHAT-IF ANALYSIS
hat-If nalysis is the most powerful feature in spreadsheet that helps to run reverse calculations sensitivity
analysis and scenarios comparison. ecision making is a crucial part of any business or ob role. hen we talk
about decisions which are informed based on data the outcome of the business or pro ect or task is always
more in control. hus hat-if nalysis is used by almost every data analyst and especially by middle to higher
management professionals to make better faster and more accurate decisions based on data.
hat-If nalysis can be done by changing the values in cells to see how those changes will affect the outcome
of formulas on the worksheet. It includes many powerful tools to perform complex mathematical calculations
which can help us to experiment and answer uestions with different data even when the data is incomplete.
Scenario oal Seek and Solver are the different tools of hat-If nalysis.
SCENARIO
Scenario is a tool to test what-if uestions. Scenario is a set of values that spreadsheet saves and can
substitute automatically in cells on a worksheet. ach Scenario is named and can be edited and formatted
separately and can be chosen from a drop-down list in the Navigator and the title bar of the Scenario.
hen the spreadsheet is printed only the contents of the currently active Scenario are printed. y adding a
Scenario arguments of a formula the new results can also be easily viewed.
Advanced Features of Spreadsheet 165

