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

Question

Share Report Error

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

A. DAY()

B. MONTH()

C. YEAR()

D. YEARFRAC()

Answer: Option C

Solution (By JKSSB Mock Tests)

YEAR(serial_number) returns year.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

Share Report

To insert a row above the selected row in Excel, press:

A. Ctrl + Shift + + (plus)

B. Alt + I, R

C. Ctrl + +

D. All of these

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
All these shortcuts can insert a row when a row is selected.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What is the shortcut key combination to check the word count, character count, and paragraph metrics of an active document file in MS Word?

A. Ctrl + W

B. Ctrl + F7

C. Ctrl + Shift + G

D. Alt + Shift + C

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + Shift + G opens the Word Count summary pane directly, showing details like page count, character count, and paragraph metrics.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

Which section of the MS Word status bar shows real-time page metrics, word counts, and proofing status?

A. The Title Bar

B. The Quick Access Layout

C. The Status Bar

D. The Ribbon

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Status Bar located at the very bottom of the window displays document metrics such as total page count, active page, word count, language, and zoom sliders.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs