DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
one-input
|
|
|
two-input
|
|
|
three-input
|
|
|
unlimited-input
|
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 two-variable data table uses a formula that contains two lists of input values. The formula must refer to two different input cells. Follow these steps: In a cell on the worksheet, enter the formula that refers to the two input cells.
Detailed explanation-3: -Go to the Data tab > Data Tools group, click the What-If Analysis button, and then click Data Table… In the Data Table dialog window, click in the Column Input cell box (because our Investment values are in a column), and select the variable cell referenced in your formula.