Which of the following is NOT a valid Excel number format category? MCQ with Answer and Explanation

Which of the following is NOT a valid Excel number format category?
A. General
B. Phone Number
C. Fraction
D. Scientific
Answer: Option B
Solution (By JKSSB Mock Tests)
Phone Number is not a standard category; you can create a custom format but it's not a built-in category. General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special, Custom are categories.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
What is the shortcut key to open the 'New Comment' in MS Word?
A. Alt + M
B. Ctrl + Shift + M
C. Ctrl + M
D. Ctrl + Alt + M

Correct Answer: Option D


Explanation:
Ctrl+Alt+M inserts a comment.

This question belongs to: Computer Microsoft Office
Question #2
Which shortcut key is used to switch between open programs in Windows?
A. Ctrl + Tab
B. Shift + Tab
C. Alt + Tab
D. Windows + Tab

Correct Answer: Option C


Explanation:
Alt+Tab switches between open applications.

This question belongs to: Computer Microsoft Office
Question #3
In Access, which of the following is a valid way to enforce referential integrity?
A. Cascade Update Related Fields
B. Neither
C. Cascade Delete Related Records
D. Both A and B

Correct Answer: Option D


Explanation:
When defining a relationship, you can set referential integrity and optionally cascade update/delete. Both are options.

This question belongs to: Computer Microsoft Office