FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO INSERT HEADERS FOOTERS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
All capital letters must be used when entering formulas.
A
TRUE
B
FALSE
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -Yes, both capital and non-capital letters can be used in Excel formulas. After you press enter to finalize a formula it will most likely capitalize it for you, but you’re free to enter it either way.

Detailed explanation-2: -Tip: Use the formula =UPPER(A1) for all UPPERCASE; =LOWER(A1) for all lowercase.

Detailed explanation-3: -The reason is that TRUE and FALSE are keywords, which means they have a special significance; they are not text strings.

Detailed explanation-4: -Use =UPPER(A2) in cases where you need to convert text to uppercase, replacing A2 with the appropriate cell reference. Now, fill down the formula in the new column.

There is 1 question to complete.