Date & Time =YEAR(serial_number)

Quiz =YEAR — 10 Questions

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

Question 1 of 10 1/10

Does =YEAR return a dynamic array?

Question 2 of 10 2/10

How many arguments does =YEAR have in total?

Question 3 of 10 3/10

Is =YEAR volatile?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

Which is the correct syntax of =YEAR?

Question 6 of 10 6/10

In =YEAR, which is argument #1?

Question 7 of 10 7/10

How many required arguments does =YEAR have?

Question 8 of 10 8/10

What is the output type of =YEAR?

Question 9 of 10 9/10

Which category does =YEAR belong to?

Question 10 of 10 10/10

Which statement about =YEAR is correct?

Click a question to see the answer.

1. Does =YEAR return a dynamic array?

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

Explanation: YEAR does not spill.

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

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

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

3. Is =YEAR volatile?

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

Explanation: YEAR is not volatile.

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

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

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

5. Which is the correct syntax of =YEAR?

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

Explanation: Correct syntax: =YEAR(serial_number)

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

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

Explanation: Argument #1 is “serial_number”.

7. How many required arguments does =YEAR have?

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

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

8. What is the output type of =YEAR?

A. Text
B. Number ✓
C. Mixed
D. Reference

Explanation: Output is “Number”.

9. Which category does =YEAR belong to?

A. Lookup & Reference
B. Statistical
C. Date & Time ✓
D. Logical

Explanation: Category is “Date & Time”.

10. Which statement about =YEAR is correct?

A. Volatile and recalculates every time
B. 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. ✓
C. 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.
D. Text is always ignored

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.