What-if analysis is a very powerful and simple tool to test the effects of different assumptions in a spreadsheet.Group startsTrue or FalseTrue, unselectedFalse, unselected

Which of the following Microsoft Excel tool lets you Test out scenarios and determine the range of outcomes without changing the actual data?SolverWhat-If-AnalysisMacros

When using IF statements in Microsoft Excel we are required to make a decision on whether criteria is either true or false

Functions, formulas, charts, and what-if analysis are common features of database management systems.Group startsTrue or FalseTrue, unselectedFalse, unselected

he major purpose of Scenario Analysis in Excel is A. To evaluate different sets of assumptionsB.  To run simulations to predict future outcomes

Spreadsheet models are referred to as what-if models because they _____.Group of answer choicesallow easy instantaneous recalculation for a change in model inputshave specialized functions to perform detailed analysiscome preloaded on computersare mathematical and logic-based models