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

In Excel, which of the following is a valid date format?
A. yyyy-mm-dd
B. All of these
C. mm/dd/yyyy
D. dd/mm/yyyy
Answer: Option B
Solution (By JKSSB Mock Tests)
Excel can display many date formats.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In PowerPoint, which key toggles between Normal and Outline view?
A. There is no single shortcut; use View tab
B. Ctrl + Shift + Tab (in some versions)
C. F6
D. Ctrl + F6

Correct Answer: Option A


Explanation:
No direct toggle; you switch in the View tab. I'll rephrase: In PowerPoint, which view displays only text in an outline format? Answer: Outline view (accessible from View tab). So I'll ask: In PowerPoint, to see only the text content of slides in a structured list, use Outline view. That's fine.

This question belongs to: Computer Microsoft Office
Question #2
In MS Word, the 'Columns' feature allows you to:
A. Insert table columns
B. Create a chart
C. Divide text into newspaper-style columns
D. Adjust paragraph indents

Correct Answer: Option C


Explanation:
Columns feature under Layout tab formats text in multiple columns.

This question belongs to: Computer Microsoft Office
Question #3
To quickly minimize the ribbon in MS Office, press:
A. Ctrl + F1
B. Alt + F1
C. Shift + F1
D. F1

Correct Answer: Option A


Explanation:
Ctrl+F1 collapses/expands the ribbon.

This question belongs to: Computer Microsoft Office