Question

What would FIND(" ", A2) return if A2 had Ball Park as the text.

Options:
Option 1: 4
Option 2: 3
Option 3: 5
Option 4: 2

Answer 1

FIND(" ", A2) returns the position of the first space in the text 'Ball Park', which is at the fifth position, so the correct answer is Option 3: 5 .

Step-by-step explanation:

The function FIND(" ", A2) is used in spreadsheet applications to locate the position of a specific character or characters within a text string. In this case, it is searching for the first space character in the text string contained in cell A2. If the content of A2 is Ball Park, the space is located at the 5th position. Therefore, FIND(" ", A2) would return 5 as its result.

So according to this, the correct answer from the provided options is: Option 3: 5.