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

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. OR
B. IF
C. AND
D. CHOOSE
Answer: Option B
Solution (By JKSSB Mock Tests)
The IF function executes logical truth tests, handling conditional output behaviors cleanly across standard data records.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
In PowerPoint, which tab would you use to change the orientation of slides from landscape to portrait?
A. Insert -> Slide Orientation
B. View -> Slide Orientation
C. Design -> Slide Size -> Custom Slide Size
D. Home -> Orientation

Correct Answer: Option C


Explanation:
Slide orientation is under Design -> Slide Size.

This question belongs to: Computer Microsoft Office
Question #2
In MS PowerPoint, which option allows you to add a transition effect to a slide?
A. Slide Show tab
B. Transitions tab
C. Design tab
D. Animations tab

Correct Answer: Option B


Explanation:
Slide transitions are on the Transitions tab. Animations are for objects within slides.

This question belongs to: Computer Microsoft Office
Question #3
In MS Word, the feature that automatically scales down a document layout to fit text precisely onto one less physical sheet if it overflows by just a few trailing lines is:
A. Shrink One Page
B. Page Setup Optimizer
C. AutoFit Window
D. Compact Layout margins

Correct Answer: Option A


Explanation:
The 'Shrink One Page' (or Shrink to Fit) command decreases the size of text and margins slightly to fit the document's content onto one less page than it currently occupies.

This question belongs to: Computer Microsoft Office