2.11 Other Processing Methods 2

What will the formula `=AND(B3>10, B4<5)` return if B3 is 12 and B4 is 3?

• TRUE

• FALSE

• ERROR

• #VALUE!

Answer explanation

The formula `=AND(B3>10, B4<5)` checks if B3 is greater than 10 (true, since 12>10) and if B4 is less than 5 (true, since 3<5). Both conditions are true, so the formula returns TRUE.

Which logical operator would you use to check if either B3 is greater than 10 or B4 is less than 5?

• AND

• OR

• NOT

• XOR

Answer explanation

The correct operator is OR because it checks if at least one of the conditions is true. Here, we want to know if either B3 is greater than 10 or B4 is less than 5, making OR the appropriate choice.

If B2 is 0, what will the formula `=NOT(B2>1)` return?

• TRUE

• FALSE

• ERROR

• #VALUE!

Answer explanation

The formula `=NOT(B2>1)` checks if B2 (which is 0) is greater than 1. Since 0 is not greater than 1, the expression evaluates to FALSE. The NOT function then inverts this to TRUE, making the correct answer TRUE.

In a spreadsheet, how would you modify the formula in E3 to display 'Yes' only if the pass mark is achieved in both papers?

• =IF(AND(C3>=pass_mark, D3>=pass_mark), "Yes", "No")

• =IF(OR(C3>=pass_mark, D3>=pass_mark), "Yes", "No")

• =IF(NOT(C3>=pass_mark), "Yes", "No")

• =IF(C3>=pass_mark, "Yes", "No")

Answer explanation

The correct formula is =IF(AND(C3>=pass_mark, D3>=pass_mark), "Yes", "No"). This checks if both C3 and D3 meet or exceed the pass mark, returning 'Yes' only if both conditions are true.

What is the simplest way to sort a list of data in a spreadsheet?

• Use a filter

• Click anywhere in the column and use the sort function

• Manually rearrange the data

• Use a pivot table

Answer explanation

The simplest way to sort a list in a spreadsheet is to click anywhere in the column and use the sort function. This method quickly organizes the data without manual effort or complex tools like filters or pivot tables.

Which logical operator would you use to reverse the result of a logical test?

• AND

• OR

• NOT

• XOR

Answer explanation

The NOT operator is used to reverse the result of a logical test. If the test evaluates to true, NOT will make it false, and vice versa. Therefore, NOT is the correct choice for this question.

If you want to sort a list of names in alphabetical order, which order should you choose?

• Descending

• Ascending

• Random

• Numerical

Answer explanation

To sort names in alphabetical order, you should choose ascending order. This arranges the names from A to Z, which is the standard method for alphabetical sorting.

What will the formula `=OR(B3>10, B4<5)` return if B3 is 8 and B4 is 6?

• TRUE

• FALSE

• ERROR

• #VALUE!

Answer explanation

The formula `=OR(B3>10, B4<5)` checks if B3 is greater than 10 or B4 is less than 5. With B3 as 8 and B4 as 6, both conditions are false, so the formula returns FALSE.

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

• AND

• OR

• NOT

• ADD

Answer explanation

ADD is not a logical operator in spreadsheets; it is an arithmetic function used for addition. The logical operators are AND, OR, and NOT, which are used to evaluate conditions.

If you want to ensure a formula only returns TRUE when both conditions are met, which operator should you use?

• OR

• AND

• NOT

• IF

Answer explanation

The AND operator ensures that a formula returns TRUE only when both conditions are met. In contrast, OR returns TRUE if at least one condition is met, while NOT negates a condition. IF is a function, not an operator.