Home / Aptitude Tests / Microsoft Office / What is the correct ...

What is the correct syntax of IF() function in Excel?

...

What is the correct syntax of IF() function in Excel?

A.

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

B.

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

C.

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

D.

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

View answer & explanation

Correct answer is D

The correct syntax of IF() function is:

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

See all Microsoft Office questions & answers
See more Microsoft Excel questions & answers
Similar Questions

You are working on a new email but need to leave for the day. When you close the email, you see the ...

Microsoft PowerPoint is a ____ program ...

The shortcut key to close PowerPoint is? ...

A circular reference in Excel is ...

What is a slide-title master pair? ...

In MS Word, Ctrl+S is used to ________ ...

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spread...

We can request a receipt to show an email has been read by: ...

Which is not a view to create a table in MS Access ? ...

To create a table in MS Access ...

Aptitude Tests

Situational Judgement Questions and Answers

Spatial Reasoning Questions and Answers

Microsoft Office Questions and Answers

Quantitative Reasoning Questions and Answers

Numerical Reasoning Questions and Answers

Typing Speed and Accuracy Test

Logical Reasoning Questions and Answers

Verbal Reasoning Questions and Answers

Abstract Reasoning Questions and Answers

Nigeria General Knowledge Questions and Answers

Puzzles Questions and Answers

Personality Test

Data Interpretation Questions and Answers

See all →


View latest jobs in Nigeria today