MS-Excel - STRING Functions

Function to find the text length.

• LEN
• LENGTH
• MID
• TEXTLENGTH

What does =LEN("SINGAPORE") return?

• 8
• 9
• 10
• 11

What does =LEN("DAILY EFFORT") return?

• 5
• 6
• 11
• 12

= LEN("I AM HAPPY")

• 1
• 3
• 8
• 10

Which of the following returns 9?

• "=LEN("Apple")
• "=LEN("Orange")
• "=LEN("Pineapple")
• "=LEN("Watermelon")

Given A1="GROWTH MINDSET". To extract "G" from A1?

• =LEFT(A1, 1)
• =LEFT(A1,2)
• =LEFT(A1,3)
• =LEFT(A1,4)

Given A1="GROWTH MINDSET". To extract "GROW" from A1?

• =LEFT(A1, 1)
• =LEFT(A1,2)
• =LEFT(A1,3)
• =LEFT(A1,4)

Given A1="SINGAPORE". What does = LEFT(A1,4) return ?

• SING
• SINGA
• APORE
• SINGAPORE

Given A1="SINGAPORE". What does = LEFT(A1,5) return ?

• SING
• SINGA
• APORE
• SINGAPORE

Given A1="GROWTH MINDSET". Which of the following formulas is used to extract "GROW" from A1?

• =LEFT(A1, 1)
• =LEFT(A1,4)
• =LEFT(A1,1,4)
• =LEFT(A1,4,1)