Date & Time =NOW()

Quiz =NOW — 15 Questions

15 quiz questions about =NOW — test syntax, arguments, examples & errors!

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

← NOW ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which category does =NOW belong to?

Question 2 of 15 2/15

Which function is related to =NOW?

Question 3 of 15 3/15

Does =NOW return a dynamic array?

Question 4 of 15 4/15

How many optional arguments does =NOW have?

Question 5 of 15 5/15

Since which Excel version is =NOW available?

Question 6 of 15 6/15

Which statement about =NOW is correct?

Question 7 of 15 7/15

Which formula is a valid example of =NOW?

Question 8 of 15 8/15

How many required arguments does =NOW have?

Question 9 of 15 9/15

Which use case fits =NOW?

Question 10 of 15 10/15

Which function is NOT related to =NOW?

Question 11 of 15 11/15

How many arguments does =NOW have in total?

Question 12 of 15 12/15

What is the output type of =NOW?

Question 13 of 15 13/15

Which is the correct syntax of =NOW?

Question 14 of 15 14/15

Is =NOW volatile?

Click a question to see the answer.

1. Which category does =NOW belong to?

A. Date & Time ✓
B. Information
C. Lookup & Reference
D. Financial

Explanation: Category is “Date & Time”.

2. Which function is related to =NOW?

A. LOWER
B. HOUR ✓
C. YIELD
D. GROUPBY

Explanation: “HOUR” is related to NOW.

3. Does =NOW return a dynamic array?

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

Explanation: NOW does not spill.

4. How many optional arguments does =NOW have?

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

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

5. Since which Excel version is =NOW available?

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

Explanation: Version: “All versions”.

6. Which statement about =NOW is correct?

A. Excel stores dates as sequential serial numbers so that they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2025 is serial number 45658 because it is 45,657 days after January 1, 1900. ✓
B. The results of the NOW function change only when the worksheet is calculated or when a macro that contains the function is run. It is not updated continuously.
C. Volatile and recalculates every time
D. Only works in old versions

Explanation: Correct: Excel stores dates as sequential serial numbers so that they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2025 is serial number 45658 because it is 45,657 days after January 1, 1900.

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

A. =NOW(, 0)
B. NOW()
C. =HOUR()
D. =NOW() ✓

Explanation: Correct example: =NOW()

8. How many required arguments does =NOW have?

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

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

9. Which use case fits =NOW?

A. Dynamic Ranges & Dashboards
B. Reporting
C. Probability & Hypothesis Testing
D. Date & Time Calculations ✓

Explanation: Use case “Date & Time Calculations” fits NOW.

10. Which function is NOT related to =NOW?

A. TODAY
B. MINUTE
C. HOUR
D. RECEIVED ✓

Explanation: “RECEIVED” is not related to NOW.

11. How many arguments does =NOW have in total?

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

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

12. What is the output type of =NOW?

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

Explanation: Output is “Date”.

13. Which is the correct syntax of =NOW?

A. =NOW(, 0)
B. =HOUR()
C. =NOW() ✓
D. NOW()

Explanation: Correct syntax: =NOW()

14. Is =NOW volatile?

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

Explanation: NOW is volatile and recalculates on every calc.