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

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

11th Grade

11 Qs

quiz-placeholder

Similar activities

BIM 1 Excel 9 Weeks Review

BIM 1 Excel 9 Weeks Review

9th - 12th Grade

16 Qs

Latihan 1 Kelas X

Latihan 1 Kelas X

10th Grade - University

10 Qs

Excel Avançado 01

Excel Avançado 01

9th - 12th Grade

16 Qs

Spreadsheets

Spreadsheets

1st - 12th Grade

15 Qs

Excel If function WSC 4.2.3

Excel If function WSC 4.2.3

7th Grade - University

10 Qs

Empowerment Technologies Lesson 1-4

Empowerment Technologies Lesson 1-4

11th - 12th Grade

15 Qs

Quiz Dasar Microsoft Excel

Quiz Dasar Microsoft Excel

10th Grade - University

16 Qs

INFORMÁTICA: Quem sabe mais?

INFORMÁTICA: Quem sabe mais?

KG - Professional Development

15 Qs

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

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

Assessment

Quiz

Computers

11th Grade

Hard

Created by

Khuon Ratha

Used 2+ times

FREE Resource

11 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Which function do we use in this picture?

=IF()

=AND()

=OR()

=Text()

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Which function do we use in this picture?

=IF()

=AND()

=OR()

=Text()

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Which function do we use in this picture?

=IF()

=AND()

=OR()

=Text()

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Which function do we use to convert the letter in the cell?

=IF()

=AND()

=OR()

=Text()

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

True/False: LEFT(text,num_chars)

True

False

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Chan Dara =Left(A1,3) will show____

Cha

Chan

Dar

Dara

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Chan Dara =Right(A1,3) will show____

Cha

Chan

ara

Dara

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?

Discover more resources for Computers