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 output type of =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

Which function is related to =PY?

Question 5 of 10 5/10

Which formula is a valid example of =PY?

Question 6 of 10 6/10

Is =PY volatile?

Question 7 of 10 7/10

Which statement about =PY is correct?

Question 8 of 10 8/10

Which function is NOT related to =PY?

Question 9 of 10 9/10

How many required arguments does =PY have?

Question 10 of 10 10/10

How many optional arguments does =PY have?

Click a question to see the answer.

1. What is the output type of =PY?

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

Explanation: Output is “Text”.

2. Which is the correct syntax of =PY?

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

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

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

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

Explanation: Argument #1 is “python_code”.

4. Which function is related to =PY?

A. GROUPBY
B. COPILOT ✓
C. PMT
D. OCT2HEX

Explanation: “COPILOT” is related to PY.

5. Which formula is a valid example of =PY?

A. =PY('Hello' + ' ' + 'World',0) ✓
B. PY('Hello' + ' ' + 'World',0)
C. =COPILOT('Hello' + ' ' + 'World',0)
D. =PY('Hello' + ' ' + 'World',0, 0)

Explanation: Correct example: =PY('Hello' + ' ' + 'World',0)

6. Is =PY volatile?

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

Explanation: PY is not volatile.

7. Which statement about =PY is correct?

A. Text is always ignored
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. Both the python_code and return_type arguments must be static.
D. Select entire column for best performance

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.

8. Which function is NOT related to =PY?

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

Explanation: “IRR” is not related to PY.

9. How many required arguments does =PY have?

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

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

10. How many optional arguments does =PY have?

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

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