In Excel, which of the following is a valid date format? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which of the following is a valid date format?

A. All of these

B. mm/dd/yyyy

C. yyyy-mm-dd

D. dd/mm/yyyy

Answer: Option A

Solution (By JKSSB Mock Tests)

Excel can display many date formats.

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

Which shortcut is used to start a slide show from the current slide in PowerPoint?

A. Ctrl + F5

B. Shift + F5

C. Alt + F5

D. F5

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Shift+F5 starts from current slide.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Excel, what does the error message '#NULL!' typically indicate?

A. A cell contains an invalid division calculation

B. A required parameter in a formula is missing

C. A formula specifies an intersection of two cell ranges that do not intersect

D. A numeric value is outside of the expected bounds

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The #NULL! error appears when a space operator is used between two ranges that do not actually cross paths or intersect (e.g., =SUM(A1:A2 B1:B2)).

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Access, which of the following is a valid query that updates data?

A. Update Query

B. Delete Query

C. All of the above

D. Append Query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Update, Append, and Delete are all action queries that modify data.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs