DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
true
|
|
|
false
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Excel is case sensitive with respect to names of cells. You cannot use column and row titles within formulas when you want to refer to the related data by name.
Detailed explanation-2: -Excel has some functions that are case-sensitive by default, including VLOOKUP, EXACT, FIND and SUBSTITUTE.
Detailed explanation-3: -The FIND function will return the position of the first matching string, and it is case sensitive. If you need a non-case-sensitive search, use the Excel SEARCH function.
Detailed explanation-4: -Updated: 11/16/2019 by Computer Hope. Text or typed input that is sensitive to capitalization of letters. For example, “Computer” and “computer” are two different words because the “C” is uppercase in the first example and lowercase in the second example.
Detailed explanation-5: -Almost all Excel functions are case insensitive for their inputs.