Siksha Sarovar

Siksha Sarovar (sikshasarovar.com) is a free educational web application that helps students in India learn programming and prepare for academic and competitive exams. The platform offers structured coding courses (C, C++, Python, Java, HTML, CSS, PHP, Power BI, AI, Machine Learning, Data Science), complete university curriculum notes for BCA/MCA students with previous year question papers, Class 10 and Class 12 CBSE/HBSE school notes, and dedicated preparation material for SSC, UPSC, Banking, Railway and other government exams. Browsing the site is completely free and requires no account. Users may optionally sign in with Google solely to save their learning progress, quiz scores and personal preferences across devices.

Privacy Policy | Terms of Service | Contact Siksha Sarovar | About Siksha Sarovar

v4.0.9 · PWA
Siksha Sarovar logo
Siksha Sarovar
Your Learning Universe

Siksha Sarovar is a free e-learning platform for coding courses, BCA university notes and competitive exam preparation. Optional Google sign-in saves your learning progress across devices.

Initializing knowledge base…
Compiling modules 0%

Practical 11: Scenario Manager in MS-Excel

Lesson 11 of 14 in the free Statistical Analysis using Excel Lab notes on Siksha Sarovar, written by Rohit Jangra.

Theoretical: Importance of Scenario Manager

Scenario Manager (Data → What-If Analysis → Scenario Manager) allows users to save multiple sets of input values (scenarios) and switch between them to compare outcomes — without changing the original data.

Why It's Important:

  • Supports decision-making by modeling multiple situations (Best/Worst/Expected case)
  • Generates a Scenario Summary report showing all scenarios and results side-by-side
  • No need to manually overwrite and re-enter values
  • Useful in financial planning, budget analysis, business forecasting

---

Scenario 1: Sales Forecast Analysis

CellLabelBase Value
B1Unit Price (₹)500
B2Units Sold1000
B3Total Revenue=B1*B2

Scenarios:

ScenarioUnit PriceUnits Sold
Optimistic6001500
Expected5001000
Pessimistic400700

Steps: Data → What-If Analysis → Scenario Manager → Add → Name: "Optimistic" → Changing Cells: B1,B2 → Enter values → Repeat for all → Summary

---

Scenario 2: Profit Variation Analysis

CellLabelValue/Formula
B1Revenue (₹)500000
B2Fixed Cost (₹)150000
B3Variable Cost100000
B4Profit=B1-B2-B3

Scenarios: High Profit (Revenue=700000), Normal, Low Profit (Revenue=350000)

---

Scenario 3: Student Result Outcome Analysis

CellLabelValue/Formula
B1Sub1 Marks80
B2Sub2 Marks75
B3Sub3 Marks70
B4Total=B1+B2+B3
B5Overall %=B4/300*100

Scenarios: Best Case (90,88,85), Average Case (75,70,68), Worst Case (55,50,48)

---

Scenario 4: Budget Planning Analysis

CellLabelValue/Formula
B1Monthly Income (₹)50000
B2Rent (₹)15000
B3Food (₹)8000
B4Transport (₹)3000
B5Monthly Savings=B1-B2-B3-B4

Scenarios: Conservative (Rent=18000), Moderate (Rent=15000), Liberal (Rent=10000)

---

Scenario 5: Exam Pass Percentage Analysis

CellLabelValue/Formula
B1Total Students100
B2Pass Count75
B3Pass %=B2/B1*100

Scenarios: High Pass (B2=90), Average (B2=75), Low Pass (B2=55)