IF, OR, AND, Left, Right, and Left

IF, OR, AND, Left, Right, and Left

11th Grade

10 Qs

quiz-placeholder

Similar activities

Chapter 3: Storage devices and media (Part 2):

Chapter 3: Storage devices and media (Part 2):

10th - 11th Grade

15 Qs

Excel

Excel

11th - 12th Grade

13 Qs

Excel-2

Excel-2

11th Grade

15 Qs

Laptop Computers and Mobile Devices

Laptop Computers and Mobile Devices

10th - 12th Grade

10 Qs

Track Changes and Comments

Track Changes and Comments

10th - 11th Grade

10 Qs

Google Sheets Review 1

Google Sheets Review 1

9th - 12th Grade

15 Qs

Coding and Robotics

Coding and Robotics

8th - 12th Grade

12 Qs

Электронные таблицы. Основные понятия.

Электронные таблицы. Основные понятия.

5th - 11th Grade

10 Qs

IF, OR, AND, Left, Right, and Left

IF, OR, AND, Left, Right, and Left

Assessment

Quiz

Computers

11th Grade

Hard

Created by

Khuon Ratha

Used 2+ times

FREE Resource

AI

Enhance your content

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Choose the correct answer below: A2>=30

A2ធំជាងឬស្មើរ30

A2តូចជាងឬស្មើរ30

A2ធំជាង30

A2តូចជាង30

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

True/False: =IF(A2>=30,"B",IF(A2>=25,"C",""))

True

False

3.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Choose 3 incorrect answers below: =OR () Function

=IF(OR(A3=18,B3="Female"),100,"")

=IF(OR(A3=18),(B3="Female"),100,"")

=IF(OR(A3=18,B3="Female")100,"")

=IF(OR(A3=18,B3="Female")100)

4.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Choose 3 correct answers below: =AND ()

=IF(AND(B3="Male", C3=20),100,0)

=IF(AND(B3="Male", C3=20),100,"")

=IF(AND(B3="Male", C3=20),100)

=IF(AND(B3=Male, C3=20),100,0)

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

TRUE/FALSE: =AND(1=1,2=2,3=3)

TRUE

FALSE

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

TRUE/FALSE: =AND(1=2,2=3,3=4)

TURE

FALSE

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

TRUE/FALSE: =OR(1=2,2=3)

TRUE

FALSE

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?