FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Maggie wants to use a function that will return True when all its arguments are true, and False when one or more arguments are false. What function would she use?

A	IF
B	AND
C	OR
D	NOT

Explanation:

Detailed explanation-1: -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. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")

Detailed explanation-2: -Reference operators compare values for the purpose of true/false results. An Excel complex formula uses more than one arithmetic operator. According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.

Detailed explanation-3: -The PMT function uses the following arguments: Rate (required argument) – The interest rate of the loan. Nper (required argument) – Total number of payments for the loan taken.

There is 1 question to complete.