What is the correct syntax of IF() function?

Microsoft Excel - Quiz(MCQ)

=IF (logical_test, [value_if_true], [value_if_false])

=IF (logical_test: [value_if_true], [value_if_false])

=IF (logical_test, {[value_if_true]}, {[value_if_false]})

=IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false]))

Correct Answer : =IF (logical_test, [value_if_true], [value_if_false])

Explanation :

The correct syntax of IF() function is :

=IF (logical_test, [value_if_true], [value_if_false])

Recently Updated in Microsoft Excel Questions

What is the keyboard shortcut to switch between open Excel windows?

ALT + TAB

CTRL + TAB

CTRL + ALT + TAB

None of the above

Correct Answer : CTRL + TAB

What is the keyboard shortcut to copy the value from the cell above the active cell into the cell or the Formula Bar in MS Excel?

ALT + SHIFT + "

CTRL + ALT + "

CTRL + SHIFT + C

CTRL + SHIFT + "

Correct Answer : CTRL + SHIFT + "

Explanation : The keyboard shortcut to copy the value from the cell above the active cell into the cell or the Formula Bar is "CTRL + SHIFT + "".

What is the keyboard shortcut to display the Format Cells dialog box in MS Excel?

CTRL + 1

ALT + 1

CTRL + F

CTRL + SHIFT + F

Correct Answer : CTRL + 1

Explanation : The keyboard shortcut to display the Format Cells dialog box is "CTRL + 1".

New Technologies MCQ's

Machine Learning

Artificial Intelligence