Date & Time =NOW()

Quiz =NOW — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

Which use case fits =NOW?

Question 2 of 10 2/10

Which function is NOT related to =NOW?

Question 3 of 10 3/10

Which formula is a valid example of =NOW?

Question 4 of 10 4/10

Which category does =NOW belong to?

Question 5 of 10 5/10

What is the output type of =NOW?

Question 6 of 10 6/10

How many required arguments does =NOW have?

Question 7 of 10 7/10

Which statement about =NOW is correct?

Question 8 of 10 8/10

Does =NOW return a dynamic array?

Question 9 of 10 9/10

How many optional arguments does =NOW have?

Question 10 of 10 10/10

Since which Excel version is =NOW available?

Click a question to see the answer.

1. Which use case fits =NOW?

A. Conditional Aggregation
B. Depreciation
C. Date & Time Calculations ✓
D. Worksheet Info & Navigation

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

2. Which function is NOT related to =NOW?

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

Explanation: “SERIESSUM” is not related to NOW.

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

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

Explanation: Correct example: =NOW()

4. Which category does =NOW belong to?

A. Statistical
B. Date & Time ✓
C. Information
D. Logical

Explanation: Category is “Date & Time”.

5. What is the output type of =NOW?

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

Explanation: Output is “Date”.

6. How many required arguments does =NOW have?

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

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

7. Which statement about =NOW is correct?

A. Only works in old versions
B. 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. ✓
C. 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.
D. Select entire column for best performance

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.

8. Does =NOW return a dynamic array?

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

Explanation: NOW does not spill.

9. How many optional arguments does =NOW have?

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

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

10. Since which Excel version is =NOW available?

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

Explanation: Version: “All versions”.