Web =PY(python_code,return_type)

Quiz =PY — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

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

Question 2 of 10 2/10

Which is the correct syntax of =PY?

Question 3 of 10 3/10

In =PY, which is argument #1?

Question 4 of 10 4/10

How many required arguments does =PY have?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Which function is related to =PY?

Question 7 of 10 7/10

Is argument “python_code” required in =PY?

Question 8 of 10 8/10

How many optional arguments does =PY have?

Question 9 of 10 9/10

In =PY, which is argument #2?

Question 10 of 10 10/10

Which statement about =PY is correct?

Click a question to see the answer.

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

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

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

2. Which is the correct syntax of =PY?

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

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

3. In =PY, which is argument #1?

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

Explanation: Argument #1 is “python_code”.

4. How many required arguments does =PY have?

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

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

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

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

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

6. Which function is related to =PY?

A. F.INV.RT
B. DOLLARDE
C. COPILOT ✓
D. ZTEST

Explanation: “COPILOT” is related to PY.

7. Is argument “python_code” required in =PY?

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

Explanation: “python_code” is required.

8. How many optional arguments does =PY have?

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

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

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

A. return_type ✓
B. python_code
C. value
D. criteria

Explanation: Argument #2 is “return_type”.

10. Which statement about =PY is correct?

A. The PY function cannot be used with any other Excel functions. If used with other functions, a formula cannot be entered.
B. Both the python_code and return_type arguments must be static.
C. 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. ✓
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.