Which specific MS Excel function evaluates whether a condition is satisfied and outputs one value if true, and a different designated value if false? MCQ with Answer and Explanation

Question

Which specific MS Excel function evaluates whether a condition is satisfied and outputs one value if true, and a different designated value if false?

A. AND

B. OR

C. IF

D. CHOOSE

Answer: Option C

Solution (By JKSSB Mock Tests)

The IF function executes logical truth tests, handling conditional output behaviors cleanly across standard data records.

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

Share Report

To insert a new slide in PowerPoint, which shortcut is used?

A. Ctrl + D

B. Ctrl + I

C. Ctrl + N

D. Ctrl + M

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + M inserts a new slide. Ctrl + N creates a new presentation, Ctrl + D duplicates the selected slide.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Access, which of the following is a valid way to create a report?

A. Create > Report Wizard

B. Create > Report

C. Create > Report Design

D. All of the above

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
All methods create reports.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

Which feature in MS Excel automatically fills adjacent cells when it recognizes a clear data pattern, such as combining first and last names?

A. AutoCorrect

B. Data Validation

C. Consolidate

D. Flash Fill

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Flash Fill recognizes structural text patterns and completes data entry down an entire column automatically.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs