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

Which statement about =YEAR is correct?

Question 2 of 15 2/15

How many arguments does =YEAR have in total?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

In =YEAR, which is argument #1?

Question 5 of 15 5/15

How many optional arguments does =YEAR have?

Question 6 of 15 6/15

Does =YEAR return a dynamic array?

Question 7 of 15 7/15

Is argument “serial_number” required in =YEAR?

Question 8 of 15 8/15

Which is the correct syntax of =YEAR?

Question 9 of 15 9/15

How many required arguments does =YEAR have?

Question 10 of 15 10/15

Which function is NOT related to =YEAR?

Question 11 of 15 11/15

Which use case fits =YEAR?

Question 12 of 15 12/15

Which function is related to =YEAR?

Question 13 of 15 13/15

Is =YEAR volatile?

Question 14 of 15 14/15

Since which Excel version is =YEAR available?

Question 15 of 15 15/15

Which category does =YEAR belong to?

Click a question to see the answer.

1. Which statement about =YEAR is correct?

A. 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.
B. Only works in old versions
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.

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

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

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

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

A. Value
B. Any type ✓
C. Date
D. Logical

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

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

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

Explanation: Argument #1 is “serial_number”.

5. How many optional arguments does =YEAR have?

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

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

6. Does =YEAR return a dynamic array?

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

Explanation: YEAR does not spill.

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

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

Explanation: “serial_number” is required.

8. Which is the correct syntax of =YEAR?

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

Explanation: Correct syntax: =YEAR(serial_number)

9. How many required arguments does =YEAR have?

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

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

10. Which function is NOT related to =YEAR?

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

Explanation: “DATEVALUE” is not related to YEAR.

11. Which use case fits =YEAR?

A. Investment Appraisal
B. Date & Time Calculations ✓
C. Sort, Filter & Dedupe
D. Numbering & Sample Data

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

12. Which function is related to =YEAR?

A. ODD
B. T.DIST
C. MULTINOMIAL
D. DATE ✓

Explanation: “DATE” is related to YEAR.

13. Is =YEAR volatile?

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

Explanation: YEAR is not volatile.

14. Since which Excel version is =YEAR available?

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

Explanation: Version: “All versions”.

15. Which category does =YEAR belong to?

A. Math & Trig
B. Database
C. Cube
D. Date & Time ✓

Explanation: Category is “Date & Time”.