Logical =AND(logical1, [logical2], ...)

Quiz =AND — 10 Questions

10 quiz questions about =AND — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← AND ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is argument “logical1” required in =AND?

Question 2 of 10 2/10

Does =AND return a dynamic array?

Question 3 of 10 3/10

What is the output type of =AND?

Question 4 of 10 4/10

Which statement about =AND is correct?

Question 5 of 10 5/10

Which category does =AND belong to?

Question 6 of 10 6/10

What is the type of argument “logical1” in =AND?

Question 7 of 10 7/10

Is argument “logical2” required in =AND?

Question 8 of 10 8/10

In =AND, which is argument #1?

Question 9 of 10 9/10

Which function is NOT related to =AND?

Question 10 of 10 10/10

What is the type of argument “logical2” in =AND?

Click a question to see the answer.

1. Is argument “logical1” required in =AND?

A. Yes ✓
B. —
C. No
D. Yes

Explanation: “logical1” is required.

2. Does =AND return a dynamic array?

A. —
B. No
C. No ✓
D. Yes

Explanation: AND does not spill.

3. What is the output type of =AND?

A. Number
B. Value
C. Logical ✓
D. Text

Explanation: Output is “Logical”.

4. Which statement about =AND is correct?

A. Output is always a dynamic array
B. If an array or reference argument contains text or empty cells, those values are ignored.
C. The arguments must evaluate to logical values, such as TRUE or FALSE, or the arguments must be arrays or references that contain logical values. ✓
D. Requires add-in

Explanation: Correct: The arguments must evaluate to logical values, such as TRUE or FALSE, or the arguments must be arrays or references that contain logical values.

5. Which category does =AND belong to?

A. Text
B. Web
C. Math & Trig
D. Logical ✓

Explanation: Category is “Logical”.

6. What is the type of argument “logical1” in =AND?

A. Number
B. Reference
C. Array
D. Logical ✓

Explanation: Type of “logical1” is “Logical”.

7. Is argument “logical2” required in =AND?

A. —
B. No ✓
C. No
D. Yes

Explanation: “logical2” is optional.

8. In =AND, which is argument #1?

A. lookup_value
B. criteria
C. logical1 ✓
D. range

Explanation: Argument #1 is “logical1”.

9. Which function is NOT related to =AND?

A. NOT
B. OR
C. IF
D. DVAR ✓

Explanation: “DVAR” is not related to AND.

10. What is the type of argument “logical2” in =AND?

A. Reference
B. Logical ✓
C. Array
D. Text

Explanation: Type of “logical2” is “Logical”.