Date & Time =YEAR(serial_number)

Quiz =YEAR — 15 Questions

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

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

← YEAR ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

How many arguments does =YEAR have in total?

Question 2 of 15 2/15

Does =YEAR return a dynamic array?

Question 3 of 15 3/15

Since which Excel version is =YEAR available?

Question 4 of 15 4/15

Which function is NOT related to =YEAR?

Question 5 of 15 5/15

In =YEAR, which is argument #1?

Question 6 of 15 6/15

Which formula is a valid example of =YEAR?

Question 7 of 15 7/15

How many required arguments does =YEAR have?

Question 8 of 15 8/15

Which use case fits =YEAR?

Question 9 of 15 9/15

What is the output type of =YEAR?

Question 10 of 15 10/15

What is the type of argument “serial_number” in =YEAR?

Question 11 of 15 11/15

Which function is related to =YEAR?

Question 12 of 15 12/15

Which category does =YEAR belong to?

Question 13 of 15 13/15

Is =YEAR volatile?

Question 14 of 15 14/15

Which statement about =YEAR is correct?

Question 15 of 15 15/15

Is argument “serial_number” required in =YEAR?

Click a question to see the answer.

1. How many arguments does =YEAR have in total?

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

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

2. Does =YEAR return a dynamic array?

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

Explanation: YEAR does not spill.

3. Since which Excel version is =YEAR available?

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

Explanation: Version: “All versions”.

4. Which function is NOT related to =YEAR?

A. TODAY
B. DATE
C. DAY
D. ISERROR ✓

Explanation: “ISERROR” is not related to YEAR.

5. In =YEAR, which is argument #1?

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

Explanation: Argument #1 is “serial_number”.

6. Which formula is a valid example of =YEAR?

A. =YEAR(A3, 0)
B. =YEAR(A3) ✓
C. =DATE(A3)
D. YEAR(A3)

Explanation: Correct example: =YEAR(A3)

7. How many required arguments does =YEAR have?

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

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

8. Which use case fits =YEAR?

A. Conditional Logic
B. Rounding & Numeric
C. Date & Time Calculations ✓
D. Advanced Formulas

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

9. What is the output type of =YEAR?

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

Explanation: Output is “Number”.

10. What is the type of argument “serial_number” in =YEAR?

A. Any type ✓
B. Text
C. Number
D. Array

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

11. Which function is related to =YEAR?

A. BASE
B. CLEAN
C. ACCRINTM
D. DATE ✓

Explanation: “DATE” is related to YEAR.

12. Which category does =YEAR belong to?

A. Cube
B. Engineering
C. Compatibility
D. Date & Time ✓

Explanation: Category is “Date & Time”.

13. Is =YEAR volatile?

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

Explanation: YEAR is not volatile.

14. Which statement about =YEAR is correct?

A. Volatile and recalculates every time
B. Values returned by the YEAR, MONTH and DAY functions will be Gregorian values regardless of the display format for the supplied date value. For example, if the display format of the supplied date is Hijri, the returned values for the YEAR, MONTH and DAY functions will be values associated with the equivalent Gregorian date.
C. Select entire column for best performance
D. Microsoft 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 45658 because it is 45,657 days after January 1, 1900. ✓

Explanation: Correct: Microsoft 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 45658 because it is 45,657 days after January 1, 1900.

15. Is argument “serial_number” required in =YEAR?

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

Explanation: “serial_number” is required.