FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT WORD

HOW TO USE MAIL MERGE IN MICROSOFT WORD

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
“If ____ Then ____ Else” is where Word chooses between ____ options, depending on contents of a particular field.
A
three
B
two
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -Another way to get an Excel IF to test multiple conditions is by using an array formula. To complete an array formula correctly, press the Ctrl + Shift + Enter keys together. In Excel 365 and Excel 2021, this also works as a regular formula due to support for dynamic arrays.

Detailed explanation-2: -A conditional statement is a logical statement that has two parts, a hypothesis p and a conclusion q. When a conditional statement is written in if-then form, the “if” part contains the hypothesis and the “then” part contains the conclusion.

Detailed explanation-3: -The if-else-if statement is used to execute one code from multiple conditions. It is also called a multipath decision statement. It is a chain of if..else statements in which each if statement is associated with an else if statement and the last would be an else statement.

There is 1 question to complete.
Previous
Next