Theoretical Questions

a) What is a Data Table in MS Excel? A Data Table is a What-If Analysis tool that calculates multiple results for one or two variable inputs simultaneously, displaying all outcomes in a tabular format automatically.

Importance:

• Eliminates manual recalculation for each scenario
• Shows how one or two variables affect a result
• One-variable table: varies a single input (e.g., interest rate)
• Two-variable table: varies two inputs simultaneously (e.g., loan amount + interest rate)

Location: Data → What-If Analysis → Data Table

---

Question b: Qty × Price Revenue Table (One-Variable)

Setup:

Data Table (Vary Quantity):

Steps:

1. In column A: list quantity values (10, 20, 30…)
2. In B (header row): enter the Revenue formula =B3
3. Select A:B range → Data → What-If Analysis → Data Table
4. Row input cell: blank; Column input cell: B2
5. Click OK — Excel fills all revenue values automatically

---

Question: EMI Data Table (Two-Variable)

Setup:

Two-Variable Data Table:

Steps:

1. Row headers = Interest rates (6%–10%)
2. Column headers = Loan amounts
3. Top-left corner cell = =B4 (PMT formula reference)
4. Select the entire table → Data → What-If Analysis → Data Table
5. Row input cell: B2 (Rate); Column input cell: B1 (Loan Amount)
6. Click OK