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

Which is the correct syntax of =YEAR?

Question 2 of 10 2/10

Which function is NOT related to =YEAR?

Question 3 of 10 3/10

Is =YEAR volatile?

Question 4 of 10 4/10

In =YEAR, which is argument #1?

Question 5 of 10 5/10

Which statement about =YEAR is correct?

Question 6 of 10 6/10

What is the output type of =YEAR?

Question 7 of 10 7/10

Which function is related to =YEAR?

Question 8 of 10 8/10

Which use case fits =YEAR?

Question 9 of 10 9/10

Is argument “serial_number” required in =YEAR?

Question 10 of 10 10/10

How many arguments does =YEAR have in total?

Click a question to see the answer.

1. Which is the correct syntax of =YEAR?

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

Explanation: Correct syntax: =YEAR(serial_number)

2. Which function is NOT related to =YEAR?

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

Explanation: “PPMT” is not related to YEAR.

3. Is =YEAR volatile?

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

Explanation: YEAR is not volatile.

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

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

Explanation: Argument #1 is “serial_number”.

5. 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. Text is always ignored
C. 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. ✓
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.

6. What is the output type of =YEAR?

A. Number ✓
B. Value
C. Mixed
D. Logical

Explanation: Output is “Number”.

7. Which function is related to =YEAR?

A. PI
B. GAMMA
C. DATE ✓
D. FORECAST.ETS.SEASONALITY

Explanation: “DATE” is related to YEAR.

8. Which use case fits =YEAR?

A. Data Cleaning
B. Financial Calculations
C. Comparation
D. Date & Time Calculations ✓

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

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

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

Explanation: “serial_number” is required.

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

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

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