Web =WEBSERVICE(url)

Quiz =WEBSERVICE — 10 Questions

10 quiz questions about =WEBSERVICE — test syntax, arguments, examples & errors!

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

← WEBSERVICE ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which function is NOT related to =WEBSERVICE?

Question 2 of 10 2/10

Which use case fits =WEBSERVICE?

Question 3 of 10 3/10

Which category does =WEBSERVICE belong to?

Question 4 of 10 4/10

Which statement about =WEBSERVICE is correct?

Question 5 of 10 5/10

How many required arguments does =WEBSERVICE have?

Question 6 of 10 6/10

How many arguments does =WEBSERVICE have in total?

Question 7 of 10 7/10

In =WEBSERVICE, which is argument #1?

Question 8 of 10 8/10

Since which Excel version is =WEBSERVICE available?

Question 9 of 10 9/10

Which is the correct syntax of =WEBSERVICE?

Question 10 of 10 10/10

Which function is related to =WEBSERVICE?

Click a question to see the answer.

1. Which function is NOT related to =WEBSERVICE?

A. FILTERXML
B. PY ✓
C. IFERROR
D. ENCODEURL

Explanation: “PY” is not related to WEBSERVICE.

2. Which use case fits =WEBSERVICE?

A. External Data, Web & Cube ✓
B. Workdays & Due Dates
C. Comparation
D. Advanced Formulas

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

3. Which category does =WEBSERVICE belong to?

A. Web ✓
B. Date & Time
C. Cube
D. Lookup & Reference

Explanation: Category is “Web”.

4. Which statement about =WEBSERVICE is correct?

A. Requires add-in
B. Select entire column for best performance
C. Only works in old versions
D. For the best results, the URL for WEBSERVICE should be encoded prior to inclusion in the formula. To encode a URL, use the ENCODEURL function. Then reference the cell with the encoded URL in the WEBSERVICE formula. ✓

Explanation: Correct: For the best results, the URL for WEBSERVICE should be encoded prior to inclusion in the formula. To encode a URL, use the ENCODEURL function. Then reference the cell with the encoded URL in the WEBSERVICE formula.

5. How many required arguments does =WEBSERVICE have?

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

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

6. How many arguments does =WEBSERVICE have in total?

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

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

7. In =WEBSERVICE, which is argument #1?

A. url ✓
B. value
C. lookup_value
D. range

Explanation: Argument #1 is “url”.

8. Since which Excel version is =WEBSERVICE available?

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

Explanation: Version: “Excel 2013”.

9. Which is the correct syntax of =WEBSERVICE?

A. WEBSERVICE(url)
B. =WEBSERVICE(url) ✓
C. =WEBSERVICE(url, 0)
D. =ENCODEURL(url)

Explanation: Correct syntax: =WEBSERVICE(url)

10. Which function is related to =WEBSERVICE?

A. MIRR
B. ENCODEURL ✓
C. SQRT
D. F.DIST

Explanation: “ENCODEURL” is related to WEBSERVICE.