Page 220 - TP_IT_V1.0_C10_flipbpookl
P. 220
Short key To access the Navigator
pane:
Alt +
F5 +
4
If you click on each scenario the corresponding marks of the Unit Test, Term 1 Exam and Term 2 Exam changes and on
that basis the Total Marks will be calculated and displayed. The set of four scenarios with the corresponding set of cells
are displayed below:
USING WHAT IF ANALYSIS
What-If analysis involves exploring how changes in input variables affect the results of a formula or model. This analysis
can be conducted with one input variable (one-input analysis) or two input variables (two-input analysis).
The description of each input is as follows:
218 Trackpad Information Technology (Ver. 1.0)-X

