FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Choose the case sensitive function in Excel.
A
VLOOKUP
B
MATCH
C
FIND
D
MID
Explanation: 

Detailed explanation-1: -The FIND function is case sensitive. If you are looking for a case-insensitive match, use the SEARCH function. The FIND function in Excel does not allow using wildcard characters. If the find text argument contains several characters, the FIND function returns the position of the first character.

Detailed explanation-2: -Note: The FIND function is case-sensitive.

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: -What is the FIND Function? The FIND Function[1] is categorized under Excel TEXT functions. The function will return the position of a specified character or sub-string within a supplied text string. In financial analysis, we can use this function to locate specific data.

Detailed explanation-5: -In computers, case sensitivity defines whether uppercase and lowercase letters are treated as distinct (case-sensitive) or equivalent (case-insensitive). For instance, when users interested in learning about dogs search an e-book, “dog” and “Dog” are of the same significance to them.

There is 1 question to complete.