In Excel, which function returns the year from a date? MCQ with Answer and Explanation

Question Report Error

In Excel, which function returns the year from a date?

A. MONTH()

B. DAY()

C. YEARFRAC()

D. YEAR()

Answer: Option D

Solution (By JKExamLibrary)

YEAR(serial_number) returns year.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error

What is the shortcut to refresh a PivotTable in Excel?

A. Alt + F5

B. F5

C. Ctrl + F5

D. Ctrl + Alt + F5

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
Alt+F5 refreshes PivotTable. Also right-click -> Refresh.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In MS Access, which of the following is not a valid field property?

A. Sort Order

B. Field Size

C. Caption

D. Format

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
Field properties include Field Size, Format, Caption, Default Value, etc. Sort Order is not a field property; sorting is applied in queries or tables via the Sort row.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

What is the shortcut to open the 'Help' pane in MS Office?

A. Ctrl + H

B. F2

C. Alt + H

D. F1

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
F1 opens Help in most Office applications.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs