USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
FV
|
|
|
Average
|
|
|
IF
|
|
|
Min
|
Detailed explanation-1: -The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition.
Detailed explanation-2: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false.
Detailed explanation-3: -Use the IF function along with AND, OR and NOT to perform multiple evaluations if conditions are True or False. The condition you want to test. The value that you want returned if the result of logical test is TRUE.
Detailed explanation-4: -The IF function is a premade function in Excel, which returns values based on a true or false condition. The condition is referred to as logical test, which can check things like: If a number is greater than another number > If a number is smaller than another number <
Detailed explanation-5: -IF is one of logical functions that evaluates a certain condition and returns one value if the condition is TRUE, and another value if the condition is FALSE.