Math & Trig =ODD(number)

Quiz =ODD — 10 Questions

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

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

← ODD ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which function is NOT related to =ODD?

Question 2 of 10 2/10

How many optional arguments does =ODD have?

Question 3 of 10 3/10

Which is the correct syntax of =ODD?

Question 4 of 10 4/10

How many required arguments does =ODD have?

Question 5 of 10 5/10

Which function is related to =ODD?

Question 6 of 10 6/10

Is argument “number” required in =ODD?

Question 7 of 10 7/10

Which formula is a valid example of =ODD?

Question 8 of 10 8/10

What is the fix for #VALUE! in =ODD?

Question 9 of 10 9/10

Since which Excel version is =ODD available?

Question 10 of 10 10/10

Which statement about =ODD is correct?

Click a question to see the answer.

1. Which function is NOT related to =ODD?

A. ISODD
B. DSTDEV ✓
C. EVEN
D. ISEVEN

Explanation: “DSTDEV” is not related to ODD.

2. How many optional arguments does =ODD have?

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

Explanation: =ODD has 1 required, 0 optional (1 total).

3. Which is the correct syntax of =ODD?

A. =EVEN(number)
B. =ODD(number, 0)
C. ODD(number)
D. =ODD(number) ✓

Explanation: Correct syntax: =ODD(number)

4. How many required arguments does =ODD have?

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

Explanation: =ODD has 1 required, 0 optional (1 total).

5. Which function is related to =ODD?

A. EVEN ✓
B. VAR.S
C. CUBESETCOUNT
D. WEBSERVICE

Explanation: “EVEN” is related to ODD.

6. Is argument “number” required in =ODD?

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

Explanation: “number” is required.

7. Which formula is a valid example of =ODD?

A. =ODD(1.5) ✓
B. =EVEN(1.5)
C. ODD(1.5)
D. =ODD(1.5, 0)

Explanation: Correct example: =ODD(1.5)

8. What is the fix for #VALUE! in =ODD?

A. Convert the text to a number ✓
B. Requires add-in
C. Only works in old versions
D. Text is always ignored

Explanation: If number is nonnumeric, ODD returns the #VALUE! error value. — Fix: Convert the text to a number

9. Since which Excel version is =ODD available?

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

Explanation: Version: “All versions”.

10. Which statement about =ODD is correct?

A. Select entire column for best performance
B. Text is always ignored
C. Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an odd integer, no rounding occurs. ✓
D. Requires add-in

Explanation: Correct: Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an odd integer, no rounding occurs.