Lookup & Reference =RTD(ProgID, server, topic1, [topic2], ...)

Quiz =RTD — 10 Questions

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

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

← RTD ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which function is related to =RTD?

Question 2 of 10 2/10

How many required arguments does =RTD have?

Question 3 of 10 3/10

In =RTD, which is argument #1?

Question 4 of 10 4/10

What is the type of argument “progID” in =RTD?

Question 5 of 10 5/10

Which is the correct syntax of =RTD?

Question 6 of 10 6/10

What is the output type of =RTD?

Question 7 of 10 7/10

Is argument “progID” required in =RTD?

Question 8 of 10 8/10

Which statement about =RTD is correct?

Question 9 of 10 9/10

Is =RTD volatile?

Question 10 of 10 10/10

Which use case fits =RTD?

Click a question to see the answer.

1. Which function is related to =RTD?

A. CONCAT
B. WEEKNUM
C. ADDRESS ✓
D. T.TEST

Explanation: “ADDRESS” is related to RTD.

2. How many required arguments does =RTD have?

A. 5
B. 6
C. 4 ✓
D. 3

Explanation: =RTD has 4 required, 0 optional (4 total).

3. In =RTD, which is argument #1?

A. progID ✓
B. server
C. criteria
D. range

Explanation: Argument #1 is “progID”.

4. What is the type of argument “progID” in =RTD?

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

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

5. Which is the correct syntax of =RTD?

A. =ADDRESS(ProgID, server, topic1, [topic2], ...)
B. RTD(ProgID, server, topic1, [topic2], ...)
C. =RTD(ProgID, server, topic1, [topic2], ...) ✓
D. =RTD(ProgID, server, topic1, [topic2], ..., 0)

Explanation: Correct syntax: =RTD(ProgID, server, topic1, [topic2], ...)

6. What is the output type of =RTD?

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

Explanation: Output is “Value”.

7. Is argument “progID” required in =RTD?

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

Explanation: “progID” is required.

8. Which statement about =RTD is correct?

A. When the server has been programmed to continually update results, unlike other functions, RTD formulas will change when Microsoft Excel is in automatic calculation mode.
B. The RTD COM automation add-in must be created and registered on a local computer. If you haven't installed a real-time data server, you will get an error message in a cell when you try to use the RTD function. ✓
C. Output is always a dynamic array
D. Volatile and recalculates every time

Explanation: Correct: The RTD COM automation add-in must be created and registered on a local computer. If you haven't installed a real-time data server, you will get an error message in a cell when you try to use the RTD function.

9. Is =RTD volatile?

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

Explanation: RTD is not volatile.

10. Which use case fits =RTD?

A. Conditional Aggregation
B. Date & Time Calculations
C. Daily Tasks ✓
D. Workdays & Due Dates

Explanation: Use case “Daily Tasks” fits RTD.