Question

______ is a set of values that can be used within the calculations in the spreadsheet to explore and compare various alternatives depending on changing conditions.

Options

• Sort

• Filter

• What-if Scenarios

• Comments

Answer 1

What-if Scenarios is a set of values that can be used within the calculations in the spreadsheet to explore and compare various alternatives depending on changing conditions.

Explanation:

You can test and compare different sets of values in Calc’s “What-if Scenarios” by changing the input factors and seeing how they change the results. This helps you make data-driven choices when conditions change in calculations.