Information =N(value)

Quiz =N — 10 Questions

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

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

← N ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which function is NOT related to =N?

Question 2 of 10 2/10

Which category does =N belong to?

Question 3 of 10 3/10

In =N, which is argument #1?

Question 4 of 10 4/10

How many required arguments does =N have?

Question 5 of 10 5/10

Which formula is a valid example of =N?

Question 6 of 10 6/10

What is the type of argument “value” in =N?

Question 7 of 10 7/10

Since which Excel version is =N available?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Which function is related to =N?

Question 10 of 10 10/10

Which statement about =N is correct?

Click a question to see the answer.

1. Which function is NOT related to =N?

A. COVARIANCE.S ✓
B. T
C. VALUE
D. N_X

Explanation: “COVARIANCE.S” is not related to N.

2. Which category does =N belong to?

A. Compatibility
B. Information ✓
C. Database
D. Cube

Explanation: Category is “Information”.

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

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

Explanation: Argument #1 is “value”.

4. How many required arguments does =N have?

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

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

5. Which formula is a valid example of =N?

A. N(A2)
B. =T(A2)
C. =N(A2) ✓
D. =N(A2, 0)

Explanation: Correct example: =N(A2)

6. What is the type of argument “value” in =N?

A. Logical
B. Reference
C. Any type ✓
D. Number

Explanation: Type of “value” is “Any type”.

7. Since which Excel version is =N available?

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

Explanation: Version: “All versions”.

8. What usually causes #DIV/0! in =N?

A. Volatile and recalculates every time
B. Output is always a dynamic array
C. A number = That number; A date, in one of the built-in date formats available in Microsoft Excel = The serial number of that date; TRUE = 1; FALSE = 0; An error value, such as #DIV/0! = The error value; Anything else = 0. ✓
D. Select entire column for best performance

Explanation: A number = That number; A date, in one of the built-in date formats available in Microsoft Excel = The serial number of that date; TRUE = 1; FALSE = 0; An error value, such as #DIV/0! = The error value; Anything else = 0. — Fix: بررسی کنید سلول مرجع حاوی خطا نباشد؛ در صورت نیاز با تابع IFERROR خطا را مدیریت کنید.

9. Which function is related to =N?

A. WEEKDAY
B. T ✓
C. DATEDIF
D. ACOS

Explanation: “T” is related to N.

10. Which statement about =N is correct?

A. It is not generally necessary to use the N function in a formula, because Excel automatically converts values as necessary. This function is provided for compatibility with other spreadsheet programs. ✓
B. Volatile and recalculates every time
C. Requires add-in
D. Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.

Explanation: Correct: It is not generally necessary to use the N function in a formula, because Excel automatically converts values as necessary. This function is provided for compatibility with other spreadsheet programs.