Web =ENCODEURL(text)

Quiz =ENCODEURL — 15 Questions

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

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

← ENCODEURL ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

How many optional arguments does =ENCODEURL have?

Question 2 of 15 2/15

Which function is related to =ENCODEURL?

Question 3 of 15 3/15

Is argument “text” required in =ENCODEURL?

Question 4 of 15 4/15

How many required arguments does =ENCODEURL have?

Question 5 of 15 5/15

What is the output type of =ENCODEURL?

Question 6 of 15 6/15

In =ENCODEURL, which is argument #1?

Question 7 of 15 7/15

What is the type of argument “text” in =ENCODEURL?

Question 8 of 15 8/15

Is =ENCODEURL volatile?

Question 9 of 15 9/15

Which category does =ENCODEURL belong to?

Question 10 of 15 10/15

Which use case fits =ENCODEURL?

Question 11 of 15 11/15

Which function is NOT related to =ENCODEURL?

Question 12 of 15 12/15

Which formula is a valid example of =ENCODEURL?

Question 13 of 15 13/15

Since which Excel version is =ENCODEURL available?

Question 14 of 15 14/15

Which is the correct syntax of =ENCODEURL?

Question 15 of 15 15/15

Does =ENCODEURL return a dynamic array?

Click a question to see the answer.

1. How many optional arguments does =ENCODEURL have?

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

Explanation: =ENCODEURL has 1 required, 0 optional (1 total).

2. Which function is related to =ENCODEURL?

A. ROUNDUP
B. HYPERLINK ✓
C. SKEW
D. FIXED

Explanation: “HYPERLINK” is related to ENCODEURL.

3. Is argument “text” required in =ENCODEURL?

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

Explanation: “text” is required.

4. How many required arguments does =ENCODEURL have?

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

Explanation: =ENCODEURL has 1 required, 0 optional (1 total).

5. What is the output type of =ENCODEURL?

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

Explanation: Output is “Text”.

6. In =ENCODEURL, which is argument #1?

A. range
B. text ✓
C. criteria
D. value

Explanation: Argument #1 is “text”.

7. What is the type of argument “text” in =ENCODEURL?

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

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

8. Is =ENCODEURL volatile?

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

Explanation: ENCODEURL is not volatile.

9. Which category does =ENCODEURL belong to?

A. Logical
B. Engineering
C. Math & Trig
D. Web ✓

Explanation: Category is “Web”.

10. Which use case fits =ENCODEURL?

A. Data Cleaning
B. Depreciation
C. External Data, Web & Cube ✓
D. Scientific & Unit Conversion

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

11. Which function is NOT related to =ENCODEURL?

A. SUBSTITUTE
B. HYPERLINK
C. WEBSERVICE
D. LOGNORM.DIST ✓

Explanation: “LOGNORM.DIST” is not related to ENCODEURL.

12. Which formula is a valid example of =ENCODEURL?

A. ENCODEURL("http:⁠//contoso.sharepoint.com/Finance/Profit and Loss Statement.xlsx")
B. =HYPERLINK("http:⁠//contoso.sharepoint.com/Finance/Profit and Loss Statement.xlsx")
C. =ENCODEURL("http:⁠//contoso.sharepoint.com/Finance/Profit and Loss Statement.xlsx", 0)
D. =ENCODEURL("http:⁠//contoso.sharepoint.com/Finance/Profit and Loss Statement.xlsx") ✓

Explanation: Correct example: =ENCODEURL("http:⁠//contoso.sharepoint.com/Finance/Profit and Loss Statement.xlsx")

13. Since which Excel version is =ENCODEURL available?

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

Explanation: Version: “Excel 2013”.

14. Which is the correct syntax of =ENCODEURL?

A. =ENCODEURL(text) ✓
B. ENCODEURL(text)
C. =HYPERLINK(text)
D. =ENCODEURL(text, 0)

Explanation: Correct syntax: =ENCODEURL(text)

15. Does =ENCODEURL return a dynamic array?

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

Explanation: ENCODEURL does not spill.