Forecasting Data Answers

5 verified answers1 views
1
Free Preview

What happens to a data table when the formulas or variables used to create it are changed?

A
It will update only after the file has been closed and reopened.
B
It will automatically update immediately because the formulas are linked.
C
It will be unaffected because it is separate from the formulas used to create it.
D
It will display an error because the formula cannot function until it is corrected.
149407
Free Preview

Use the drop-down menus to complete the steps for using the Scenario command.

Answers:
2. Go to the tab.:Data
3. In the Forecast group, select and click Scenario Manager.:What-If Analysis
5. To compare, you will want to create version.:an original
7. Click to view the values in each scenario.:Show
149408

SortGet DataForecast Sheet✔ What-If Analysis

A
Sort
B
Get Data
C
Forecast Sheet
D
✔ What-If Analysis
149409

a what-if✔ an originala data table

A
a what-if
B
✔ an original
C
a data table
149410

OK✔ ShowReview

A
OK
B
✔ Show
C
Review

Did you find these answers helpful?

Forecasting Data Answers — TX-Business…