MS-Excel - STRING Functions
Authored by Rudie Asmara
Specialty, Special Education, Computers
7th - 12th Grade
Used 18+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Function to find the text length.
LEN
LENGTH
MID
TEXTLENGTH
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does =LEN("SINGAPORE") return?
8
9
10
11
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does =LEN("DAILY EFFORT") return?
5
6
11
12
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
= LEN("I AM HAPPY")
1
3
8
10
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following returns 9?
"=LEN("Apple")
"=LEN("Orange")
"=LEN("Pineapple")
"=LEN("Watermelon")
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Given A1="GROWTH MINDSET". To extract "G" from A1?
=LEFT(A1, 1)
=LEFT(A1,2)
=LEFT(A1,3)
=LEFT(A1,4)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Given A1="GROWTH MINDSET". To extract "GROW" from A1?
=LEFT(A1, 1)
=LEFT(A1,2)
=LEFT(A1,3)
=LEFT(A1,4)
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
