In Excel, which function is used to convert a date to a serial number? MCQ with Answer and Explanation

Question Report Error

In Excel, which function is used to convert a date to a serial number?

A. NOW

B. DATE

C. VALUE

D. DATEVALUE

Answer: Option D

Solution (By JKExamLibrary)

DATEVALUE converts a date in text format to a serial number. VALUE converts text to number generally.

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

In MS PowerPoint, which of the following is used to insert a SmartArt graphic?

A. Both A and B

B. Insert > Illustrations > SmartArt

C. Insert > Graphic

D. Insert > SmartArt

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
SmartArt is under Insert > SmartArt or Insert > Illustrations > SmartArt.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In MS PowerPoint, what key should a presenter hold down while using the pen tool during a live show to draw rigid horizontal or vertical annotation lines?

A. Shift

B. Tab

C. Alt

D. Ctrl

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
Holding the Shift key during a presentation slide delivery locks the integrated pen tool tracking into perfect horizontal or vertical lines.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In Excel, the 'Paste Special' option 'Values' pastes:

A. Comments only

B. Formatting only

C. Only the values, not formulas or formatting

D. Formulas only

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Values pastes the results of formulas.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs