Cis Chapter 9 Procedures

Front 1

Array formula, create:

Back 1

a.) Type the array formula into a cell or range of cells.
b.) Press CTRL + SHIFT + ENTER keys after typing the formula.

Front 2

One-variable data table, create:

Back 2

a.) Insert a formula that references the input cell in the upper-left cell of the table.
b.) If you want the input values in the first row, insert a formula that references the result cells in the first column of the table beneath the formula referencing the input cell. If you want the input values in the first column, insert a formula that references the result cells in the first row of the table to the right of the formula referencing the input cell.
c.) If you want the input values in the first row, insert the input values in the first row of the table. If you want the input values in the first column, insert the input values in the first column of the table.
d.) Select the table, click Data on the menu bar, and then click Table.
e.) Enter the cell reference for the input cell in the Row input cell box when input values are in the first row or in the Column input cell box when input values are in the first column, and then click the OK button.

Front 3

Scenario, create:

Back 3

a.) Click Tools.
b.) Click Scenarios.
c.) Click the Add button.
d.) Enter a name for the scenario.
e.) Define the changing cells in the scenario.
f.) Insert a comment describing the scenario.
g.) Click the OK button.
h.) Enter values for each changing cell in the scenario.
i.) Click the OK button.
j.) Click the Show button.
k.) Click the Close button.

Front 4

Scenario, edit:

Back 4

a.) Open Scenario Manager.
b.) Click the scenario name in the Scenarios list box.
c.) Click the Edit button.
d.) Enter a new cell range for the changing cells.
e.) Click the OK button.
f.) Enter new values for the changing cells.
g.) Click the OK button.
h.) Click the Show button to show the results of the edited scenario.
i.) Click the Close button.

Front 5

Scenario, view:

Back 5

a.) Open Scenario Manager.
b.) Click the name of the scenario in the Scenarios list box.
c.) Click the Show button.
d.) Click the Close button.

Front 6

Scenario Manager, open:

Back 6

a.) Click tools.
b.) Click Scenarios.

Front 7

Scenario PivotTable report, create:

Back 7

a.) Open the Scenario Manager.
b.) Click Summary.
c.) Click the Scenario PivotTable report option button.
d.) Click OK.

Front 8

Scenario summary report, create:

Back 8

a.) Open Scenario Manager.
b.) Click the Summary button.
c.) Click the Scenario summary option button.
d.) Enter the cell range for the result cells of the scenario.
e.) Click the OK button.

Front 9

Two-variable data table, create:

Back 9

a.) In the upper-left cell of the table, insert a reference to the result cell.
b.) Beneath the upper-left cell, enter a column of input values for the table.
c.) To the right of the upper-left cell, fill in the row with the second set of input values.
d.) Select the table.
e.) Click Data.
f.) Click Table.
g.) In the Row input cell box, enter the input cell corresponding to the row of input values.
h.) In the Column input cell box, enter the input cell corresponding to the column of input values.
i.) Click the OK button.