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

The major purpose of Scenario Analysis in Excel is A. To evaluate different sets of assumptionsB.  To run simulations to predict future outcomesOptions :Only AOnly BBoth A and BNeither A nor B

Which Excel function would one use if they want to make sure that all of the conditions in a certain set are met?=IF=OR=AND

The purpose of Scenario Manager is to Group of answer choices a.Manage multiple scenario where calculations are unclear b.Predict the resulting changes in the data when certain aspects of the output is changed c.Predict the resulting changes in the outputs when certain aspects of the data is changed d.Help managers manage various scenarios e.Demonstrate typical scenario in spreadsheets

Which of the following tools can be used for data analysis?ExcelRPythonAll of the above

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