MS-Excel - STRING  Functions

MS-Excel - STRING Functions

7th - 12th Grade

15 Qs

quiz-placeholder

Similar activities

Hàm Thống Kê - Hàm Value

Hàm Thống Kê - Hàm Value

11th - 12th Grade

10 Qs

Excel

Excel

5th - 7th Grade

20 Qs

MICROSOFT EXCEL

MICROSOFT EXCEL

9th - 11th Grade

10 Qs

Post Test Excel Logika IF

Post Test Excel Logika IF

10th Grade

10 Qs

Quiz Sesi Kedua

Quiz Sesi Kedua

1st - 12th Grade

10 Qs

Les Tableurs ( Microsoft Excel ) 1

Les Tableurs ( Microsoft Excel ) 1

6th - 12th Grade

10 Qs

Latihan Soal Fungsi Logika Di Ms. Excel

Latihan Soal Fungsi Logika Di Ms. Excel

8th Grade

20 Qs

IF(), OR(), AND(), TExt(), LEFT(), RIGHT()

IF(), OR(), AND(), TExt(), LEFT(), RIGHT()

11th Grade

11 Qs

MS-Excel - STRING  Functions

MS-Excel - STRING Functions

Assessment

Quiz

Specialty, Special Education, Computers

7th - 12th Grade

Medium

Created by

Rudie Asmara

Used 18+ times

FREE Resource

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)

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?