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

Question

Share Report Error

Which of the following is NOT a valid function category in Excel?

A. Financial

B. Logical

C. Text

D. Graphing

Answer: Option D

Solution (By JKSSB Mock Tests)

Graphing is not a function category. Categories include Financial, Logical, Text, Date & Time, Lookup & Reference, Math & Trig, Statistical, etc.

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

What is the shortcut key to open the 'Spelling and Grammar' check in MS Word?

A. Shift + F7

B. F7

C. F5

D. F9

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
F7 launches the Spelling and Grammar checker. F5 opens Find and Replace, F9 updates fields, Shift+F7 opens the Thesaurus.

This question belongs to: Computer Microsoft Office

Question #2

What is the shortcut key used to insert a hyperlink into a selected cell or text across most MS Office programs?

A. Ctrl + L

B. Ctrl + H

C. Ctrl + M

D. Ctrl + K

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The standard keyboard shortcut to insert or edit a hyperlink in Microsoft applications like Word, Excel, and PowerPoint is Ctrl + K.

This question belongs to: Computer Microsoft Office

Question #3

What is the maximum number of columns in a Word table (as of Word 2016)?

A. 63

B. 255

C. 32767

D. Unlimited

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A Word table can have up to 63 columns. The number of rows is virtually unlimited (up to 32,767 rows in a table). So 63 is correct.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs