Web =WEBSERVICE(url)

Quiz =WEBSERVICE — 15 Questions

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

Question 1 of 15 1/15

How many required arguments does =WEBSERVICE have?

Question 2 of 15 2/15

Which is the correct syntax of =WEBSERVICE?

Question 3 of 15 3/15

Which function is NOT related to =WEBSERVICE?

Question 4 of 15 4/15

How many optional arguments does =WEBSERVICE have?

Question 5 of 15 5/15

What is the output type of =WEBSERVICE?

Question 6 of 15 6/15

Which function is related to =WEBSERVICE?

Question 7 of 15 7/15

Does =WEBSERVICE return a dynamic array?

Question 8 of 15 8/15

Is argument “url” required in =WEBSERVICE?

Question 9 of 15 9/15

Which statement about =WEBSERVICE is correct?

Question 10 of 15 10/15

How many arguments does =WEBSERVICE have in total?

Question 11 of 15 11/15

Since which Excel version is =WEBSERVICE available?

Question 12 of 15 12/15

What is the type of argument “url” in =WEBSERVICE?

Question 13 of 15 13/15

In =WEBSERVICE, which is argument #1?

Question 14 of 15 14/15

Which use case fits =WEBSERVICE?

Question 15 of 15 15/15

Is =WEBSERVICE volatile?

Click a question to see the answer.

1. How many required arguments does =WEBSERVICE have?

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

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

2. Which is the correct syntax of =WEBSERVICE?

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

Explanation: Correct syntax: =WEBSERVICE(url)

3. Which function is NOT related to =WEBSERVICE?

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

Explanation: “ATAN” is not related to WEBSERVICE.

4. How many optional arguments does =WEBSERVICE have?

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

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

5. What is the output type of =WEBSERVICE?

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

Explanation: Output is “Text”.

6. Which function is related to =WEBSERVICE?

A. RANDARRAY
B. ISOWEEKNUM
C. SHEETS
D. ENCODEURL ✓

Explanation: “ENCODEURL” is related to WEBSERVICE.

7. Does =WEBSERVICE return a dynamic array?

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

Explanation: WEBSERVICE does not spill.

8. Is argument “url” required in =WEBSERVICE?

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

Explanation: “url” is required.

9. Which statement about =WEBSERVICE is correct?

A. Only works in old versions
B. Select entire column for best performance
C. 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. ✓
D. Text is always ignored

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.

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

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

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

11. Since which Excel version is =WEBSERVICE available?

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

Explanation: Version: “Excel 2013”.

12. What is the type of argument “url” in =WEBSERVICE?

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

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

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

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

Explanation: Argument #1 is “url”.

14. Which use case fits =WEBSERVICE?

A. Conditional Logic
B. Reshape Tables
C. Error Handling
D. External Data, Web & Cube ✓

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

15. Is =WEBSERVICE volatile?

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

Explanation: WEBSERVICE is not volatile.