Logical =BYROW(array, lambda(row))

Quiz =BYROW — 15 Questions

15 quiz questions about =BYROW — test syntax, arguments, examples & errors!

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

← BYROW ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Does =BYROW return a dynamic array?

Question 2 of 15 2/15

Is =BYROW volatile?

Question 3 of 15 3/15

How many required arguments does =BYROW have?

Question 4 of 15 4/15

In =BYROW, which is argument #3?

Question 5 of 15 5/15

What is the type of argument “array” in =BYROW?

Question 6 of 15 6/15

What is the type of argument “row” in =BYROW?

Question 7 of 15 7/15

What is the output type of =BYROW?

Question 8 of 15 8/15

How many arguments does =BYROW have in total?

Question 9 of 15 9/15

Which use case fits =BYROW?

Question 10 of 15 10/15

What usually causes #CALC! in =BYROW?

Question 11 of 15 11/15

Since which Excel version is =BYROW available?

Question 12 of 15 12/15

Is argument “lambda” required in =BYROW?

Question 13 of 15 13/15

What is the type of argument “lambda” in =BYROW?

Question 14 of 15 14/15

Which function is NOT related to =BYROW?

Question 15 of 15 15/15

Which formula is a valid example of =BYROW?

Click a question to see the answer.

1. Does =BYROW return a dynamic array?

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

Explanation: BYROW spills as a dynamic array.

2. Is =BYROW volatile?

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

Explanation: BYROW is not volatile.

3. How many required arguments does =BYROW have?

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

Explanation: =BYROW has 0 required, 3 optional (3 total).

4. In =BYROW, which is argument #3?

A. value
B. lambda
C. criteria
D. row ✓

Explanation: Argument #3 is “row”.

5. What is the type of argument “array” in =BYROW?

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

Explanation: Type of “array” is “Array”.

6. What is the type of argument “row” in =BYROW?

A. Value
B. Any type
C. Range ✓
D. Number

Explanation: Type of “row” is “Range”.

7. What is the output type of =BYROW?

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

Explanation: Output is “Array”.

8. How many arguments does =BYROW have in total?

A. 3 ✓
B. 2
C. 5
D. 4

Explanation: =BYROW has 0 required, 3 optional (3 total).

9. Which use case fits =BYROW?

A. Scientific & Unit Conversion
B. Dynamic Ranges & Dashboards
C. Numbering & Sample Data
D. Advanced Formulas ✓

Explanation: Use case “Advanced Formulas” fits BYROW.

10. What usually causes #CALC! in =BYROW?

A. Only works in old versions
B. تابع LAMBDA نامعتبر است یا تعداد پارامترها نادرست است و خطای «Incorrect Parameters» برمی‌گرداند.
C. Not providing a LAMBDA function or anything but a single value returned from the LAMBDA function returns a #CALC error. ✓
D. Output is always a dynamic array

Explanation: Not providing a LAMBDA function or anything but a single value returned from the LAMBDA function returns a #CALC error. — Fix: Use a calculation that gives a single result, such as SUM or MAX

11. Since which Excel version is =BYROW available?

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

Explanation: Version: “Excel 365”.

12. Is argument “lambda” required in =BYROW?

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

Explanation: “lambda” is optional.

13. What is the type of argument “lambda” in =BYROW?

A. Date
B. Range
C. Any type ✓
D. Mixed

Explanation: Type of “lambda” is “Any type”.

14. Which function is NOT related to =BYROW?

A. SUM
B. AVERAGE
C. LINEST ✓
D. LAMBDA

Explanation: “LINEST” is not related to BYROW.

15. Which formula is a valid example of =BYROW?

A. =AVERAGE(B2:E10, LAMBDA(r, SUM(r)))
B. BYROW(B2:E10, LAMBDA(r, SUM(r)))
C. =BYROW(B2:E10, LAMBDA(r, SUM(r)), 0)
D. =BYROW(B2:E10, LAMBDA(r, SUM(r))) ✓

Explanation: Correct example: =BYROW(B2:E10, LAMBDA(r, SUM(r)))