Compatibility =REGISTER.ID(module_text,procedure,[type_text])

Quiz =REGISTER.ID — 15 Questions

15 quiz questions about =REGISTER.ID — test syntax, arguments, examples & errors!

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

← REGISTER.ID ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which category does =REGISTER.ID belong to?

Question 2 of 15 2/15

Which function is NOT related to =REGISTER.ID?

Question 3 of 15 3/15

Which is the correct syntax of =REGISTER.ID?

Question 4 of 15 4/15

Is argument “module_text” required in =REGISTER.ID?

Question 5 of 15 5/15

Is =REGISTER.ID volatile?

Question 6 of 15 6/15

What is the type of argument “procedure” in =REGISTER.ID?

Question 7 of 15 7/15

Which formula is a valid example of =REGISTER.ID?

Question 8 of 15 8/15

Which use case fits =REGISTER.ID?

Question 9 of 15 9/15

Since which Excel version is =REGISTER.ID available?

Question 10 of 15 10/15

What is the type of argument “module_text” in =REGISTER.ID?

Question 11 of 15 11/15

Does =REGISTER.ID return a dynamic array?

Question 12 of 15 12/15

How many optional arguments does =REGISTER.ID have?

Question 13 of 15 13/15

What is the type of argument “type_text” in =REGISTER.ID?

Question 14 of 15 14/15

Which statement about =REGISTER.ID is correct?

Question 15 of 15 15/15

Is argument “procedure” required in =REGISTER.ID?

Click a question to see the answer.

1. Which category does =REGISTER.ID belong to?

A. Financial
B. Math & Trig
C. Compatibility ✓
D. Text

Explanation: Category is “Compatibility”.

2. Which function is NOT related to =REGISTER.ID?

A. OCT2BIN ✓
B. MODE
C. FORECAST
D. PERCENTILE

Explanation: “OCT2BIN” is not related to REGISTER.ID.

3. Which is the correct syntax of =REGISTER.ID?

A. =REGISTER.ID(module_text,procedure,[type_text], 0)
B. =REGISTER.ID(module_text,procedure,[type_text]) ✓
C. REGISTER.ID(module_text,procedure,[type_text])
D. =FORECAST(module_text,procedure,[type_text])

Explanation: Correct syntax: =REGISTER.ID(module_text,procedure,[type_text])

4. Is argument “module_text” required in =REGISTER.ID?

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

Explanation: “module_text” is required.

5. Is =REGISTER.ID volatile?

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

Explanation: REGISTER.ID is not volatile.

6. What is the type of argument “procedure” in =REGISTER.ID?

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

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

7. Which formula is a valid example of =REGISTER.ID?

A. =REGISTER.ID("MyDLL","MyProc") ✓
B. =FORECAST("MyDLL","MyProc")
C. =REGISTER.ID("MyDLL","MyProc", 0)
D. REGISTER.ID("MyDLL","MyProc")

Explanation: Correct example: =REGISTER.ID("MyDLL","MyProc")

8. Which use case fits =REGISTER.ID?

A. Reporting ✓
B. Conditional Aggregation
C. Error Handling
D. Advanced Formulas

Explanation: Use case “Reporting” fits REGISTER.ID.

9. Since which Excel version is =REGISTER.ID available?

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

Explanation: Version: “Excel 2007 (Compatibility)”.

10. What is the type of argument “module_text” in =REGISTER.ID?

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

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

11. Does =REGISTER.ID return a dynamic array?

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

Explanation: REGISTER.ID does not spill.

12. How many optional arguments does =REGISTER.ID have?

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

Explanation: =REGISTER.ID has 2 required, 1 optional (3 total).

13. What is the type of argument “type_text” in =REGISTER.ID?

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

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

14. Which statement about =REGISTER.ID is correct?

A. Only works in old versions
B. Volatile and recalculates every time
C. 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. ✓
D. Output is always a dynamic array

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.

15. Is argument “procedure” required in =REGISTER.ID?

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

Explanation: “procedure” is required.