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

Quiz =REGISTER.ID — 10 Questions

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

Question 1 of 10 1/10

Which statement about =REGISTER.ID is correct?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

Which category does =REGISTER.ID belong to?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

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

Question 6 of 10 6/10

In =REGISTER.ID, which is argument #1?

Question 7 of 10 7/10

Does =REGISTER.ID return a dynamic array?

Question 8 of 10 8/10

Which function is NOT related to =REGISTER.ID?

Question 9 of 10 9/10

Which is the correct syntax of =REGISTER.ID?

Question 10 of 10 10/10

Which function is related to =REGISTER.ID?

Click a question to see the answer.

1. Which statement about =REGISTER.ID 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. Output is always a dynamic array
C. Requires add-in
D. Select entire column for best performance

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. Is argument “procedure” required in =REGISTER.ID?

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

Explanation: “procedure” is required.

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

A. Compatibility ✓
B. Date & Time
C. Text
D. Math & Trig

Explanation: Category is “Compatibility”.

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

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

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

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

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

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

6. In =REGISTER.ID, which is argument #1?

A. module_text ✓
B. lookup_value
C. range
D. procedure

Explanation: Argument #1 is “module_text”.

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

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

Explanation: REGISTER.ID does not spill.

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

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

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

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

A. =REGISTER.ID(module_text,procedure,[type_text]) ✓
B. =REGISTER.ID(module_text,procedure,[type_text], 0)
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])

10. Which function is related to =REGISTER.ID?

A. T.TEST
B. FORECAST ✓
C. COUNT
D. COUNTBLANK

Explanation: “FORECAST” is related to REGISTER.ID.