Question

Ravi is analysing monthly sales data in Calc. He wants to test how changing the discount rate affects total revenue. Which feature should he use to simulate different outcomes?

Options

• Soft

• Indexing

• What-if Scenarios

• Filter

Answer 1

What-if Scenarios

Explanation:

Scenarios are part of “What-if Analysis” tools. They help in decision-making by allowing you to quickly switch between multiple “what-if” situations, such as “high discount” vs. “low discount”, to compare the projected outcomes without manually changing formulas each time.