Multiple choice technology programming languages

$INDEX('OTHER' , 'THE') equals

  1. 4

  2. 2

  3. 3

  4. 1

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

$INDEX returns the 0-based starting position of the second string within the first string. In 'OTHER', the substring 'THE' begins at index 2 (O=0, T=1, H=2), making the answer 2.