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. Fraction
B. Scientific
C. General
D. Phone Number
Answer: Option D
Solution (By JKExamLibrary)
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.

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 PowerPoint, which feature allows you to apply a transition effect to all slides at once?
A. Slide Master
B. Animation Painter
C. Apply To All button in Transitions tab
D. Copy formatting

Correct Answer: Option C


Explanation:
After selecting a transition, clicking 'Apply To All' sets it for every slide.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In Excel, which function returns the row number of a reference?
A. ROWS()
B. COLUMN()
C. ROW_NUMBER()
D. ROW()

Correct Answer: Option D


Explanation:
ROW(reference) returns row number. COLUMN returns column number.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In MS Access, which data type is used to store binary data such as sound or video?
A. OLE Object
B. Attachment
C. Hyperlink
D. Both A and B

Correct Answer: Option D


Explanation:
Both can store multimedia, but Attachment is preferred.

This question belongs to: Computer Microsoft Office