DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In a data table, the formula(s) you are analyzing must include a cell reference to the output cell.
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -On the Data tab, in the Data Tools group or Forecast group (in Excel 2016), click What-If Analysis > Data Table (in the Data Tools group or Forecast group of Excel 2016). In the Row input cell field, enter the reference to the input cell for the input values in the row. Type cell B4 in the Row input cell box.
Detailed explanation-2: -A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function. A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.
There is 1 question to complete.