Web =PY(python_code,return_type)

Quiz =PY — 15 Questions

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

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

← PY ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which function is NOT related to =PY?

Question 2 of 15 2/15

How many required arguments does =PY have?

Question 3 of 15 3/15

Does =PY return a dynamic array?

Question 4 of 15 4/15

How many arguments does =PY have in total?

Question 5 of 15 5/15

Which use case fits =PY?

Question 6 of 15 6/15

In =PY, which is argument #2?

Question 7 of 15 7/15

What is the type of argument “python_code” in =PY?

Question 8 of 15 8/15

Which category does =PY belong to?

Question 9 of 15 9/15

Which function is related to =PY?

Question 10 of 15 10/15

How many optional arguments does =PY have?

Question 11 of 15 11/15

What is the type of argument “return_type” in =PY?

Question 12 of 15 12/15

Which statement about =PY is correct?

Question 13 of 15 13/15

Which is the correct syntax of =PY?

Question 14 of 15 14/15

Since which Excel version is =PY available?

Question 15 of 15 15/15

What is the output type of =PY?

Click a question to see the answer.

1. Which function is NOT related to =PY?

A. FILTERXML
B. COPILOT
C. TAN ✓
D. ENCODEURL

Explanation: “TAN” is not related to PY.

2. How many required arguments does =PY have?

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

Explanation: =PY has 2 required, 0 optional (2 total).

3. Does =PY return a dynamic array?

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

Explanation: PY spills as a dynamic array.

4. How many arguments does =PY have in total?

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

Explanation: =PY has 2 required, 0 optional (2 total).

5. Which use case fits =PY?

A. Dynamic Ranges & Dashboards
B. Conditional Logic
C. Securities & Bonds
D. External Data, Web & Cube ✓

Explanation: Use case “External Data, Web & Cube” fits PY.

6. In =PY, which is argument #2?

A. return_type ✓
B. python_code
C. range
D. lookup_value

Explanation: Argument #2 is “return_type”.

7. What is the type of argument “python_code” in =PY?

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

Explanation: Type of “python_code” is “Text”.

8. Which category does =PY belong to?

A. Web ✓
B. Engineering
C. Cube
D. Information

Explanation: Category is “Web”.

9. Which function is related to =PY?

A. TTEST
B. NORM.DIST
C. COPILOT ✓
D. TODAY

Explanation: “COPILOT” is related to PY.

10. How many optional arguments does =PY have?

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

Explanation: =PY has 2 required, 0 optional (2 total).

11. What is the type of argument “return_type” in =PY?

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

Explanation: Type of “return_type” is “Number”.

12. Which statement about =PY is correct?

A. Both the python_code and return_type arguments must be static.
B. The PY function cannot be directly entered or seen from Excel's formula bar, instead the Python editor will generate it and insert it into the cell for you. The PY function syntax is primarily used by add-ins to directly insert or read Python formulas. It can also be seen when using the FORMULATEXT function on a cell containing a Python formula. ✓
C. Output is always a dynamic array
D. Volatile and recalculates every time

Explanation: Correct: The PY function cannot be directly entered or seen from Excel's formula bar, instead the Python editor will generate it and insert it into the cell for you. The PY function syntax is primarily used by add-ins to directly insert or read Python formulas. It can also be seen when using the FORMULATEXT function on a cell containing a Python formula.

13. Which is the correct syntax of =PY?

A. =PY(python_code,return_type, 0)
B. =COPILOT(COPILOTthon_code,return_type)
C. PY(python_code,return_type)
D. =PY(python_code,return_type) ✓

Explanation: Correct syntax: =PY(python_code,return_type)

14. Since which Excel version is =PY available?

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

Explanation: Version: “Microsoft 365”.

15. What is the output type of =PY?

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

Explanation: Output is “Text”.