FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
This function can be written to carry out an action and is a conditional operator.
A
If Statements
B
List Functions
C
Count Functions
D
Lookup Functions
Explanation: 

Detailed explanation-1: -The conditional operator (? :) is a ternary operator (it takes three operands). The conditional operator works as follows: The first operand is implicitly converted to bool . It is evaluated and all side effects are completed before continuing.

Detailed explanation-2: -The else statement With if statements, our programs can execute a set of instructions only if the condition is true. If we want our programs to execute a different set of instructions when the condition is false, then we can use an else statement.

Detailed explanation-3: -IF statement and boolean operators. You can combine two or more conditional expressions on the IF statement.

There is 1 question to complete.