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 happens when you select text in MS Word and press the keyboard shortcut Ctrl + G?

A. Launches the online research reference dictionary lookup helper

B. Opens the 'Find and Replace' dialog box focusing directly on the 'Go To' tab

C. Applies a green color highlight layer

D. Groups multiple paragraphs into a structural container block

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + G (or F5) launches the Find and Replace window with the 'Go To' tab selected, which allows jumping to specific pages, sections, or line items.

This question belongs to: Computer Microsoft Office

Question #2

In MS PowerPoint, which tool allows you to select customized layout options to output 2, 3, 6, or 9 small presentation slides onto a single paper sheet for distribution?

A. Outline Print Setup

B. Handout Master

C. Notes Page Layout

D. Slide Sorter Setup

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Handout Master edits layouts for physical paper prints meant for audiences, containing custom configurations for multiple slides per sheet.

This question belongs to: Computer Microsoft Office

Question #3

What is the keyboard shortcut to open the 'Font' dialog box in MS Word?

A. Both A and B

B. Ctrl + D

C. Ctrl + Shift + F

D. Ctrl + F

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+D opens Font dialog. Ctrl+Shift+F also opens Font dialog with Font tab selected.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs