In Excel, which function would you use to find the position of 'at' in the text 'Education'?
A. FIND("at", "Education")
B. MATCH("at", "Education")
C. Both A and B
D. SEARCH("at", "Education")
Answer: Option C
Solution (By JKExamLibrary)
Both SEARCH and FIND return the starting position. SEARCH is case-insensitive, FIND is case-sensitive.
This question belongs to:
Computer
Microsoft Office
No comments yet. Be the first to start the discussion!