Text =CALL(register_id,[argument1],...)

Quiz =CALL — 15 Questions

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

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

← CALL ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which statement about =CALL is correct?

Question 2 of 15 2/15

What is the type of argument “module_text” in =CALL?

Question 3 of 15 3/15

What is the type of argument “type_text” in =CALL?

Question 4 of 15 4/15

What is the type of argument “procedure” in =CALL?

Question 5 of 15 5/15

Which use case fits =CALL?

Question 6 of 15 6/15

Is argument “register_id” required in =CALL?

Question 7 of 15 7/15

Is argument “argument1” required in =CALL?

Question 8 of 15 8/15

In =CALL, which is argument #3?

Question 9 of 15 9/15

Which category does =CALL belong to?

Question 10 of 15 10/15

Which function is related to =CALL?

Question 11 of 15 11/15

How many optional arguments does =CALL have?

Question 12 of 15 12/15

Is argument “module_text” required in =CALL?

Question 13 of 15 13/15

Is =CALL volatile?

Question 14 of 15 14/15

Which is the correct syntax of =CALL?

Question 15 of 15 15/15

Is argument “type_text” required in =CALL?

Click a question to see the answer.

1. Which statement about =CALL is correct?

A. Caution Incorrectly editing the registry may severely damage your operating system, requiring you to reinstall it. Microsoft cannot guarantee that problems resulting from editing the registry incorrectly can be resolved. Before editing the registry, back up any valuable data. For the most recent information about using and protecting your computer's registry, see Microsoft Windows Help. ✓
B. Volatile and recalculates every time
C. This function is provided for advanced users only. If you use the CALL function incorrectly, you may cause errors that will require you to restart your computer. This function is only available from an Excel macro sheet.
D. Text is always ignored

Explanation: Correct: Caution Incorrectly editing the registry may severely damage your operating system, requiring you to reinstall it. Microsoft cannot guarantee that problems resulting from editing the registry incorrectly can be resolved. Before editing the registry, back up any valuable data. For the most recent information about using and protecting your computer's registry, see Microsoft Windows Help.

2. What is the type of argument “module_text” in =CALL?

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

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

3. What is the type of argument “type_text” in =CALL?

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

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

4. What is the type of argument “procedure” in =CALL?

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

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

5. Which use case fits =CALL?

A. Ranking & Top N
B. Advanced Formulas ✓
C. Loans & Installments
D. External Data, Web & Cube

Explanation: Use case “Advanced Formulas” fits CALL.

6. Is argument “register_id” required in =CALL?

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

Explanation: “register_id” is required.

7. Is argument “argument1” required in =CALL?

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

Explanation: “argument1” is optional.

8. In =CALL, which is argument #3?

A. type_text
B. range
C. procedure ✓
D. value

Explanation: Argument #3 is “procedure”.

9. Which category does =CALL belong to?

A. Web
B. Text ✓
C. Logical
D. Statistical

Explanation: Category is “Text”.

10. Which function is related to =CALL?

A. IMSUM
B. TREND
C. N
D. ARRAYTOTEXT ✓

Explanation: “ARRAYTOTEXT” is related to CALL.

11. How many optional arguments does =CALL have?

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

Explanation: =CALL has 4 required, 1 optional (5 total).

12. Is argument “module_text” required in =CALL?

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

Explanation: “module_text” is required.

13. Is =CALL volatile?

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

Explanation: CALL is not volatile.

14. Which is the correct syntax of =CALL?

A. =CALL(register_id,[argument1],...) ✓
B. =ARRAYTOTEXT(register_id,[argument1],...)
C. CALL(register_id,[argument1],...)
D. =CALL(register_id,[argument1],..., 0)

Explanation: Correct syntax: =CALL(register_id,[argument1],...)

15. Is argument “type_text” required in =CALL?

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

Explanation: “type_text” is required.