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. Scientific
B. Phone Number
C. General
D. Fraction
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 to open the thesaurus in MS Word?
A. Shift + F7
B. Ctrl + F7
C. F7
D. Alt + F7

Correct Answer: Option A


Explanation:
Shift+F7 opens thesaurus. F7 is spelling/grammar.

This question belongs to: Computer Microsoft Office
Question #2
In Excel, which formula will return '5' from the text 'Excel5'?
A. =RIGHT("Excel5",1)
B. =MID("Excel5",2,1)
C. =LEN("Excel5")
D. =LEFT("Excel5",1)

Correct Answer: Option A


Explanation:
RIGHT with 1 character returns '5'. LEFT returns 'E', MID could return 'x'.

This question belongs to: Computer Microsoft Office
Question #3
In MS Word, which key is used to extend a selection?
A. Ctrl
B. Alt
C. F8
D. Shift

Correct Answer: Option C


Explanation:
F8 turns on extend selection mode; pressing it repeatedly selects word, sentence, paragraph, etc. Shift+arrow also extends.

This question belongs to: Computer Microsoft Office