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

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error
To create a hanging indent in MS Word, press:
A. Ctrl + Shift + T
B. Tab
C. Ctrl + T
D. Ctrl + M

Correct Answer: Option C


Explanation:
Ctrl+T creates/increases hanging indent. Ctrl+Shift+T decreases.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
Which of the following is NOT a valid Excel number format category?
A. Fraction
B. Phone Number
C. General
D. Scientific

Correct Answer: Option B


Explanation:
Phone Number is not a standard category; you can create a custom format but it's not a built-in category. General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special, Custom are categories.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In Excel, the 'Go To Special' dialog can be opened by:
A. F5 -> Special button, or Home tab -> Find & Select -> Go To Special
B. Ctrl + Shift + G
C. Alt + F5
D. Ctrl + G

Correct Answer: Option A


Explanation:
F5 opens Go To, then click Special. Alternatively, Home > Find & Select > Go To Special.

This question belongs to: Computer Microsoft Office