Search Header Logo

Logical Functions

Authored by Tak Cheung

Computers

11th Grade

Used 6+ times

Logical Functions
AI

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

What are logical functions used for in spreadsheets?

To perform calculations

To test whether a situation is true or false

To display information

All of the above

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is used for decision making in spreadsheets?

AND

OR

NOT

IF

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the format of the IF function?

=IF(condition, true, false)

=IF(condition, false, true)

=IF(true, condition, false)

=IF(false, condition, true)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the AND function do?

Returns TRUE if any of the conditions are met

Returns TRUE only if all of the conditions are met

Returns FALSE if any of the conditions are met

Returns FALSE only if all of the conditions are met

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the OR function do?

Returns TRUE if any of the conditions are met

Returns TRUE only if all of the conditions are met

Returns FALSE if any of the conditions are met

Returns FALSE only if all of the conditions are met

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the NOT function do?

Returns the logical opposite of the condition test

Returns TRUE if any of the conditions are met

Returns TRUE only if all of the conditions are met

Returns FALSE if any of the conditions are met

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the IFERROR function?

To perform calculations

To display alternative text or values when an error occurs

To test whether a situation is true or false

To compare more than one condition

Access all questions and much more by creating a free account

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

Already have an account?