What happens to a data table when the formulas or variables used to create it are changed?
Use the drop-down menus to complete the steps for using the Scenario command.
SortGet DataForecast Sheet✔ What-If Analysis
a what-if✔ an originala data table
OK✔ ShowReview
What are benefits of using scenarios? Check all that apply.They mainly show single variables.They can compare multiple variables.They highlight which goals have been met.They focus on creating separate sets of data.They can predict what is needed to meet a goal.They allow a user to summarize and compare data.
What does the Goal Seek Status box include? Check all that apply.the value for a cellthe number of a rowa cell to be changeda row to be changeda column to be changedthe cell that causes the change
What types of forecast worksheets are available in Excel? Check all that apply.pie chartbar graphline graphcolumn chartdoughnut chartdata layer visualization
What is the purpose of a forecast worksheet?
Use the drop-down menus to complete the steps for using the Scenario command.
Did you find these answers helpful?