Text =DOLLAR(number, [decimals])

Quiz =DOLLAR — 10 Questions

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

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

← DOLLAR ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Does =DOLLAR return a dynamic array?

Question 2 of 10 2/10

Which statement about =DOLLAR is correct?

Question 3 of 10 3/10

Which is the correct syntax of =DOLLAR?

Question 4 of 10 4/10

In =DOLLAR, which is argument #2?

Question 5 of 10 5/10

How many required arguments does =DOLLAR have?

Question 6 of 10 6/10

Which function is related to =DOLLAR?

Question 7 of 10 7/10

Which use case fits =DOLLAR?

Question 8 of 10 8/10

Which category does =DOLLAR belong to?

Question 9 of 10 9/10

What is the output type of =DOLLAR?

Question 10 of 10 10/10

What is the type of argument “number” in =DOLLAR?

Click a question to see the answer.

1. Does =DOLLAR return a dynamic array?

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

Explanation: DOLLAR does not spill.

2. Which statement about =DOLLAR is correct?

A. Select entire column for best performance
B. Only works in old versions
C. Requires add-in
D. Generally, you should use the Format Cells dialog (Ctrl+1) or Home > Number > Accounting Number Format option to apply a currency formatting to a cell. This is because the DOLLAR function returns the number provided as text. Numbers stored as text are a common cause of spreadsheet errors, because many functions ignore them, such as SUM, AVERAGE, MIN, MAX, etc. ✓

Explanation: Correct: Generally, you should use the Format Cells dialog (Ctrl+1) or Home > Number > Accounting Number Format option to apply a currency formatting to a cell. This is because the DOLLAR function returns the number provided as text. Numbers stored as text are a common cause of spreadsheet errors, because many functions ignore them, such as SUM, AVERAGE, MIN, MAX, etc.

3. Which is the correct syntax of =DOLLAR?

A. =DOLLAR(number, [decimals], 0)
B. DOLLAR(number, [decimals])
C. =DOLLAR(number, [decimals]) ✓
D. =ARRAYTOTEXT(number, [decimals])

Explanation: Correct syntax: =DOLLAR(number, [decimals])

4. In =DOLLAR, which is argument #2?

A. decimals ✓
B. range
C. number
D. lookup_value

Explanation: Argument #2 is “decimals”.

5. How many required arguments does =DOLLAR have?

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

Explanation: =DOLLAR has 1 required, 1 optional (2 total).

6. Which function is related to =DOLLAR?

A. ARRAYTOTEXT ✓
B. OCT2HEX
C. PRICEMAT
D. MODE.MULT

Explanation: “ARRAYTOTEXT” is related to DOLLAR.

7. Which use case fits =DOLLAR?

A. Conditional Aggregation
B. Data Cleaning
C. Text Manipulation ✓
D. Scientific & Unit Conversion

Explanation: Use case “Text Manipulation” fits DOLLAR.

8. Which category does =DOLLAR belong to?

A. Text ✓
B. Logical
C. Engineering
D. Financial

Explanation: Category is “Text”.

9. What is the output type of =DOLLAR?

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

Explanation: Output is “Text”.

10. What is the type of argument “number” in =DOLLAR?

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

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