Google News
logo
Microsoft Excel - Quiz(MCQ)
Which function is used to get the location of text in a string in MS Excel?
A)
INDEX()
B)
FIND()
C)
STRINGSEARCH()
D)
SEARCH()

Correct Answer : Option (D) :   SEARCH()


Explanation :

The SEARCH() function is used to get the location of text in a string.
 
Syntax :
 
=SEARCH (find_text, within_text, [start_num])
Example:
 
=SEARCH("How","Hello, world! How are you?") // Returns 15

Advertisement