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

Is argument “return_type” required in =PY?

Question 2 of 10 2/10

Which use case fits =PY?

Question 3 of 10 3/10

Is argument “python_code” required in =PY?

Question 4 of 10 4/10

Which formula is a valid example of =PY?

Question 5 of 10 5/10

Which statement about =PY is correct?

Question 6 of 10 6/10

In =PY, which is argument #2?

Question 7 of 10 7/10

Which is the correct syntax of =PY?

Question 8 of 10 8/10

Which category does =PY belong to?

Question 9 of 10 9/10

Since which Excel version is =PY available?

Question 10 of 10 10/10

Which function is NOT related to =PY?

Click a question to see the answer.

1. Is argument “return_type” required in =PY?

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

Explanation: “return_type” is required.

2. Which use case fits =PY?

A. External Data, Web & Cube ✓
B. Data Cleaning
C. Reporting
D. Loans & Installments

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

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

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

Explanation: “python_code” is required.

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

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

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

5. Which statement about =PY is correct?

A. Requires add-in
B. Output is always a dynamic array
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. 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.

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

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

Explanation: Argument #2 is “return_type”.

7. Which is the correct syntax of =PY?

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

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

8. Which category does =PY belong to?

A. Text
B. Lookup & Reference
C. Financial
D. Web ✓

Explanation: Category is “Web”.

9. Since which Excel version is =PY available?

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

Explanation: Version: “Microsoft 365”.

10. Which function is NOT related to =PY?

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

Explanation: “IMAGINARY” is not related to PY.