Logical Operators in Spreadsheets

Which of the following is NOT a common logical operator used in spreadsheets?

• AND

• OR

• NOT

• IF

What does the AND operator do in a spreadsheet?

• Checks if at least one condition is true

• Checks if both conditions are true

• Checks if both conditions are false

• Checks if at least one condition is false

Which logical operator would you use to check if either of two conditions is true?

• AND

• OR

• NOT

• IF

What is the first step to perform the AND function in a spreadsheet?

• Type the = symbol followed by the keyword AND and an opening & closing bracket ()

• Select the cell that you want to perform the AND function in

• Type the = symbol followed by the keyword OR and an opening & closing bracket ()

• Select the cell that you want to perform the OR function in

What will the AND operator output if both conditions are true?

• TRUE

• FALSE

• 0

• 1

Which function in Excel checks if all conditions are true?

• OR

• AND

• IF

• NOT

What is the correct syntax for the AND function in Excel to check if a value in cell A2 is greater than 18 and less than 65?

• =AND(A2>18, A2<65)

• =AND(A2<18, A2>65)

• =AND(A2>18; A2<65)

• =AND(A2<18; A2>65)

What will the AND function return if both conditions are true?

• FALSE

• ERROR

• TRUE

• #VALUE!

Which function in Excel checks if at least one condition is true?

• AND

• OR

• IF

• NOT

What is the correct syntax for the OR function in Excel to check if a value in cell A2 is less than 18 or greater than 65?

• =OR(A2>18, A2<65)

• =OR(A2<18, A2>65)

• =OR(A2>18; A2<65)

• =OR(A2<18; A2>65)