Home / Microsoft Excel / Question
MCQ
Which function returns one value if a condition is true and another if false?
Microsoft Excel
A IF
B WHEN
C CHOOSE
D SWITCH
Explanation

IF checks a condition and returns two different results.

Related MCQs

Which key moves to the next cell in a worksheet?
Microsoft Excel View
What does the formula =A1+B1 do?
Microsoft Excel View
Which shortcut inserts the current time in Excel?
Microsoft Excel View
Which function raises a number to a power?
Microsoft Excel View
What operator does a single space between two ranges represent in Excel?
Microsoft Excel View
Which function counts non-empty cells in a range?
Microsoft Excel View