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. MONTH()

B. YEARFRAC()

C. YEAR()

D. DAY()

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

In MS Word, what is the function of the 'Crop' tool?

A. To resize an image

B. To change the brightness of an image

C. To rotate an image

D. To remove unwanted areas of an image

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Crop removes the outer edges of a picture to focus on a specific area. It does not resize (though cropping changes dimensions), adjust brightness, or rotate.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, which of the following is used to create a table of authorities?

A. References > Table of Authorities

B. View > Table of Authorities

C. Review > Table of Authorities

D. Insert > Table of Authorities

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Table of Authorities is in the References tab, used for legal citations.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, what does the function =IF(A1>70, "Pass", "Fail") return if A1 contains 85?

A. Fail

B. TRUE

C. 85

D. Pass

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The condition A1>70 is true (85>70), so IF returns the value_if_true "Pass".

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs