Forecasting Data

Question 1

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

Revolt · Accepted Answer

It will automatically update immediately because the formulas are linked.

Question 2

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

Revolt · Accepted Answer

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

Question 3

SortGet DataForecast Sheet✔ What-If Analysis

Revolt · Accepted Answer

✔ What-If Analysis

Question 4

a what-if✔ an originala data table

Revolt · Accepted Answer

✔ an original

Question 5

OK✔ ShowReview

Revolt · Accepted Answer

✔ Show

Question 6

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.

Revolt · Accepted Answer

They can compare multiple variables.; They can predict what is needed to meet a goal.; They allow a user to summarize and compare data.

Question 7

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

Revolt · Accepted Answer

the value for a cell; a cell to be changed; the cell that causes the change

Question 8

What types of forecast worksheets are available in Excel? Check all that apply.pie chartbar graphline graphcolumn chartdoughnut chartdata layer visualization

Revolt · Accepted Answer

line graph; column chart

Question 9

What is the purpose of a forecast worksheet?

Revolt · Accepted Answer

It uses historical data to predict one trend line.

Question 10

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

Revolt · Accepted Answer

✔ Data; 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

Forecasting Data Answers

More from this Course

TRY EDGENUITY HACKS