In spreadsheet software, use ____ to test multiple scenarios by temporarily changing one or more variables to see the effect on related calculations.
A) filters
B) macros
C) pivot tables
D) what-if analysis

Question

Quizplus · Accepted Answer

What-if analysis is used to test multiple scenarios by temporarily changing one or more variables to see the effect on related calculations. Filters are used to display specific data in a spreadsheet. Macros are used to automate repetitive tasks. Pivot tables are used to summarize and analyze large datasets.

In Spreadsheet Software, Use ____ to Test Multiple Scenarios by Temporarily