Which of the following is correct syntax in Excel? - Microsoft Excel MCQs

Home / Programming MCQs / Microsoft Excel MCQs / Question

M

Mr. Dubey • 51.43K Points
Coach

Q. Which of the following is correct syntax in Excel?

(A) =IF(LogicalTest, TrueResult, FalseResult)

(B) =IF(LogicalTest, (TrueResult, FalseResult))

(C) =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)

(D) =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

Correct answer: Option(A)

Microsoft Excel Share

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Previous MCQ Next MCQ

Discusssion

Login to discuss.

Related MCQs on Microsoft Excel

How can you find specific information in a list?

Which of the following is the oldest spreadsheet package?

What is the use of VLOOKUP function in MS Excel?

The most common subtotal used Subtotals command is the function, which causes Excel to display a sum each time the control field change ?

Which of the following is correct syntax in Excel?

You can open the Sort dialog box by choosing Sort from the ....... menu ?

In Excel which of the following is not a worksheet design criterion

What is entered by the function =today()

Which of the following addressing modes can be used for writing formulas in a cell in a worksheet in Microsoft Excel

In Excel you can use the horizontal and vertical scroll bars to

Learn All Microsoft Excel MCQs