Microsoft Office Tutorials and References

In Depth Information

Exhibit 7.11
One-variable and two-variable data table

either a vertical or horizontal orientation. I have selected a vertical orientation that

requires the
Bet Value
be placed in the column (M) immediately to the left of the

formula column (N); for a horizontal orientation, the
Bet Value
wouldbeintherow

above the formula values. These are conventions that must be followed. The empty

cells, N2:N12, will contain repetitive calculations of
Proﬁt
. If a two variable table

is required, the variables are placed in the column to the left and the row above the

calculated values. Also, the variables used in the formula must have a cell location

in the worksheet that the formula references. In other words, the variable cannot be

entered directly into the formula as a number, but must reference a cell location; for

example, the cell references that are in the Brain worksheet.

Once the external structure of a table is constructed (the variable values and the

formula cell) we select the table range: M2:N12. See Exhibit 7.13. This step simply

identiﬁes the range that will contain the formula calculations and the value of the

variable to use. Next, you will ﬁnd in the Data ribbon the Data Table tool in the

Search JabSto ::

Custom Search