FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

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.
A
True
B
False
C
Either A or B
D
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.