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

In =YEAR, which is argument #1?

Question 2 of 15 2/15

How many arguments does =YEAR have in total?

Question 3 of 15 3/15

Which statement about =YEAR is correct?

Question 4 of 15 4/15

Which is the correct syntax of =YEAR?

Question 5 of 15 5/15

How many optional arguments does =YEAR have?

Question 6 of 15 6/15

Which use case fits =YEAR?

Question 7 of 15 7/15

Which formula is a valid example of =YEAR?

Question 8 of 15 8/15

Is =YEAR volatile?

Question 9 of 15 9/15

Which function is related to =YEAR?

Question 10 of 15 10/15

Which category does =YEAR belong to?

Question 11 of 15 11/15

Does =YEAR return a dynamic array?

Question 12 of 15 12/15

What is the output type of =YEAR?

Question 13 of 15 13/15

Since which Excel version is =YEAR available?

Question 14 of 15 14/15

Is argument “serial_number” required in =YEAR?

Question 15 of 15 15/15

How many required arguments does =YEAR have?

Click a question to see the answer.

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

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

Explanation: Argument #1 is “serial_number”.

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

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

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

3. Which statement about =YEAR is correct?

A. 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. ✓
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. Text is always ignored
D. Requires add-in

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.

4. Which is the correct syntax of =YEAR?

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

Explanation: Correct syntax: =YEAR(serial_number)

5. How many optional arguments does =YEAR have?

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

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

6. Which use case fits =YEAR?

A. Reshape Tables
B. Workdays & Due Dates
C. Descriptive Statistics
D. Date & Time Calculations ✓

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

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

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

Explanation: Correct example: =YEAR(A3)

8. Is =YEAR volatile?

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

Explanation: YEAR is not volatile.

9. Which function is related to =YEAR?

A. IMCOS
B. DATE ✓
C. SQRTPI
D. EXPON.DIST

Explanation: “DATE” is related to YEAR.

10. Which category does =YEAR belong to?

A. Text
B. Cube
C. Statistical
D. Date & Time ✓

Explanation: Category is “Date & Time”.

11. Does =YEAR return a dynamic array?

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

Explanation: YEAR does not spill.

12. What is the output type of =YEAR?

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

Explanation: Output is “Number”.

13. Since which Excel version is =YEAR available?

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

Explanation: Version: “All versions”.

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

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

Explanation: “serial_number” is required.

15. How many required arguments does =YEAR have?

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

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