Forecasting Data

Question 1

What are the steps for locating the Data Validation dialog box?

Revolt · Accepted Answer

Data

Question 2

What are the steps for locating the Data Validation dialog box?

Revolt · Accepted Answer

Forecast

Question 3

Use the drop-down menu to complete the steps for creating a scenario.

Revolt · Accepted Answer

Scenario Manager

Question 4

Use the drop-down menu to complete the steps for creating a scenario.

Revolt · Accepted Answer

values for the changing cells

Question 5

A data table is a range that displays what?

Revolt · Accepted Answer

the results of changing certain values in one or more formulas

Question 6

What is the function for displaying differences between two or more scenarios side by side?

Revolt · Accepted Answer

Scenario Summary

Question 7

Where does a forecast worksheet appear once it has been created?

Revolt · Accepted Answer

in a separate worksheet within the workbook

Question 8

Which type of data table can predict projected growth using both projected increases in sales and expenses?

Revolt · Accepted Answer

a two-variable data table

Question 9

Use the drop-down menu to complete the steps for creating a scenario.

Revolt · Accepted Answer

Data

Question 10

For which task is the Goal Seek feature most helpful?

Revolt · Accepted Answer

working backward to identify the input values for a specific result

Forecasting Data Answers