USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
With a(n) ____ data table you can vary the value in one cell.
|
one-input
|
|
two-input
|
|
three-input
|
|
unlimited-input
|
Explanation:
Detailed explanation-1: -A data table does not allow changing more than two inputs of a formula. However, these two inputs can have as many possible values (to be experimented) as one wants. Excel Data tables, along with Scenarios and Goal Seek are parts of the What-If Analysis tools.
Detailed explanation-2: -A one-variable data table contain its input values either in a single column (column-oriented), or across a row (row-oriented). Any formula in a one-variable data table must refer to only one input cell.
There is 1 question to complete.