Forecasting Data Answers

1. Go to the tab on the ribbon.

2. In the group, select from the drop-down What-If Analysis menu.

2. In the group, select from the drop-down What-If Analysis menu.

6. Specify and click OK.

2. In the group, you will select What-If Analysis and the dialog box will open.

A data table is a range that displays what?

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

1. Go to the tab.

For which task is the Goal Seek feature most helpful?

1. Go to the tab.

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

2. In the group, select from the drop-down What-If Analysis menu.

2. In the group, select from the drop-down What-If Analysis menu.

4. Specify the that contains the value to adjust.