In Excel, what does the 'IF' function do? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, what does the 'IF' function do?

A. Sums cells based on a condition

B. Counts cells based on a condition

C. Looks up a value in a table

D. Tests a condition and returns one value if true, another if false

Answer: Option D

Solution (By JKSSB Mock Tests)

The IF function evaluates a logical test and returns one value for true and another for false. COUNTIF, SUMIF are conditional counting/summing, VLOOKUP is lookup.

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

In Excel, which function rounds a number down to the nearest integer?

A. INT()

B. ROUNDDOWN()

C. FLOOR()

D. All of these

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
INT rounds down to integer. ROUNDDOWN to number of digits. FLOOR rounds down to multiple. All round down.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, the error '#DIV/0!' occurs when:

A. Value not available

B. Invalid reference

C. Name not recognized

D. A formula divides by zero or an empty cell

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
#DIV/0! division by zero.

This question belongs to: Computer Microsoft Office

Question #3

Which key should be pressed to move to the next slide during a PowerPoint presentation?

A. Enter

B. Tab

C. Spacebar

D. Any of the above

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
All these keys advance to the next slide: Spacebar, Enter, Page Down, Right Arrow, Down Arrow, or N.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs