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.
|
|
TRUE
|
|
|
FALSE
|
|
|
Either A or B
|
|
|
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.