In Excel, the IF function belongs to which category? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the IF function belongs to which category?

A. Text

B. Logical

C. Math & Trig

D. Statistical

Answer: Option B

Solution (By JKSSB Mock Tests)

IF is a logical function. Other logical functions: AND, OR, NOT.

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

To close a presentation in PowerPoint, press:

A. Both A and B

B. Ctrl + W

C. Ctrl + F4

D. Alt + F4

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+W or Ctrl+F4 closes the active presentation window. Alt+F4 exits PowerPoint.

This question belongs to: Computer Microsoft Office

Question #2

What will be the output of the MS Excel formula =MATCH(30, {10, 20, 30, 40}, 0)?

A. #N/A

B. 2

C. 30

D. 3

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The MATCH function searches for a specified value in an array and returns its relative position. In the array {10, 20, 30, 40}, the lookup value 30 is at position 3.

This question belongs to: Computer Microsoft Office

Question #3

What is the purpose of the keyboard shortcut Ctrl + P across MS Office?

A. Pastes clipboard contents

B. Inserts a page break line

C. Launches the Print configuration window

D. Opens the Paragraph styling pane

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + P opens the Print pane, displaying print settings along with a real-time layout preview.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs