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. Select the cells you want to use in your scenario. Go to the tab. In the Forecast group, select and click Scenario Manager. Click Add and fill in the name and add comments if you wish. To compare, you will want to create version. Add a second scenario, changing the values from the first. Click to view the values in each scenario.
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.
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?