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

How many required arguments does =AND have?

Question 2 of 10 2/10

What is the output type of =AND?

Question 3 of 10 3/10

Is argument “logical2” required in =AND?

Question 4 of 10 4/10

Is =AND volatile?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Which category does =AND belong to?

Question 7 of 10 7/10

In =AND, which is argument #1?

Question 8 of 10 8/10

Which use case fits =AND?

Question 9 of 10 9/10

Since which Excel version is =AND available?

Question 10 of 10 10/10

Which statement about =AND is correct?

Click a question to see the answer.

1. How many required arguments does =AND have?

A. 2
B. 1 ✓
C. 0
D. 3

Explanation: =AND has 1 required, 1 optional (2 total).

2. What is the output type of =AND?

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

Explanation: Output is “Logical”.

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

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

Explanation: “logical2” is optional.

4. Is =AND volatile?

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

Explanation: AND is not volatile.

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

A. Logical ✓
B. Mixed
C. Number
D. Date

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

6. Which category does =AND belong to?

A. Engineering
B. Math & Trig
C. Cube
D. Logical ✓

Explanation: Category is “Logical”.

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

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

Explanation: Argument #1 is “logical1”.

8. Which use case fits =AND?

A. Rounding & Numeric
B. Depreciation
C. Daily Tasks ✓
D. Workdays & Due Dates

Explanation: Use case “Daily Tasks” fits AND.

9. Since which Excel version is =AND available?

A. Excel 2019
B. Excel 365
C. All versions ✓
D. Excel 2007 (Compatibility)

Explanation: Version: “All versions”.

10. Which statement about =AND is correct?

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

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.