Financial =DOLLARFR(decimal_dollar, fraction)

Quiz =DOLLARFR — 10 Questions

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

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

← DOLLARFR ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

In =DOLLARFR, which is argument #2?

Question 2 of 10 2/10

Which formula is a valid example of =DOLLARFR?

Question 3 of 10 3/10

What usually causes #DIV/0! in =DOLLARFR?

Question 4 of 10 4/10

Does =DOLLARFR return a dynamic array?

Question 5 of 10 5/10

Which statement about =DOLLARFR is correct?

Question 6 of 10 6/10

What is the type of argument “decimal_dollar” in =DOLLARFR?

Question 7 of 10 7/10

What is the fix for #NUM! in =DOLLARFR?

Question 8 of 10 8/10

How many arguments does =DOLLARFR have in total?

Question 9 of 10 9/10

Is argument “fraction” required in =DOLLARFR?

Question 10 of 10 10/10

Since which Excel version is =DOLLARFR available?

Click a question to see the answer.

1. In =DOLLARFR, which is argument #2?

A. range
B. fraction ✓
C. value
D. criteria

Explanation: Argument #2 is “fraction”.

2. Which formula is a valid example of =DOLLARFR?

A. =DOLLARDE(1.125,16)
B. =DOLLARFR(1.125,16) ✓
C. DOLLARFR(1.125,16)
D. =DOLLARFR(1.125,16, 0)

Explanation: Correct example: =DOLLARFR(1.125,16)

3. What usually causes #DIV/0! in =DOLLARFR?

A. If fraction is 0, DOLLARFR returns the #DIV/0! error value. ✓
B. Only works in old versions
C. Output is always a dynamic array
D. مقدار fraction کوچک‌تر از صفر است.

Explanation: If fraction is 0, DOLLARFR returns the #DIV/0! error value. — Fix: برای fraction مقدار صفر وارد نکنید؛ عددی بزرگ‌تر از صفر انتخاب کنید.

4. Does =DOLLARFR return a dynamic array?

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

Explanation: DOLLARFR does not spill.

5. Which statement about =DOLLARFR is correct?

A. Text is always ignored
B. If fraction is not an integer, it is truncated. ✓
C. Requires add-in
D. Select entire column for best performance

Explanation: Correct: If fraction is not an integer, it is truncated.

6. What is the type of argument “decimal_dollar” in =DOLLARFR?

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

Explanation: Type of “decimal_dollar” is “Number”.

7. What is the fix for #NUM! in =DOLLARFR?

A. Write a positive number ✓
B. Only works in old versions
C. Volatile and recalculates every time
D. Select entire column for best performance

Explanation: If fraction is less than 0, DOLLARFR returns the #NUM! error value. — Fix: Write a positive number

8. How many arguments does =DOLLARFR have in total?

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

Explanation: =DOLLARFR has 2 required, 0 optional (2 total).

9. Is argument “fraction” required in =DOLLARFR?

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

Explanation: “fraction” is required.

10. Since which Excel version is =DOLLARFR available?

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

Explanation: Version: “All versions”.