DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You cannot use column and row titles within formulas when you want to refer to the related data by name.
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -You cannot use column and row titles within formulas when you want to refer to the related data by name.
Detailed explanation-2: -Correct a # error value. If a formula cannot correctly evaluate a result, Excel displays an error value, such as #####, #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!. Each error type has different causes, and different solutions.
Detailed explanation-3: -The easiest way is to use the keyboard shortcut Ctrl + ‘. This shortcut will toggle the formulas on and off. If you want to see all the formulas in a sheet at once, you can use the shortcut Ctrl + Shift + ‘. This shortcut will highlight all the cells that contain formulas.
There is 1 question to complete.