Question

The result of =FIND("is", "Mississippi",3) is ________.
A) 2
B) 4
C) 5
D) 6

Answer 1

The formula =FIND("is", "Mississippi",3) returns the starting position of the substring "is" in the word "Mississippi" starting from the third character, which is the fifth position, so the correct answer is C) 5.

Step-by-step explanation:

The question asks for the result of the formula =FIND("is", "Mississippi",3). The FIND function in Excel is used to locate the position of a specified substring within a string, starting at a specified position. The function is case-sensitive. Here, the function is searching for the substring "is" within the word "Mississippi" starting from the third character.

Starting from the third character in "Mississippi", the first occurrence of "is" begins at the fifth character position. Therefore, the correct answer is C) 5