USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To include additional formulas in a one-input data table, enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -To include additional formulas in a one-input data table, enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.
Detailed explanation-2: -You can also press Ctrl+D to fill the formula down in a column. First select the cell that has the formula you want to fill, then select the cells underneath it, and then press Ctrl+D. You can also press Ctrl+R to fill the formula to the right in a row.
Detailed explanation-3: -The Go To Special Function[1] in Excel allows you to quickly select all cells that meet certain criteria, such as cells containing: Formulas (numbers, text, logicals, errors)
There is 1 question to complete.