USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
All formulas must be entered using capital letters.
|
|
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 the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")
There is 1 question to complete.