# FUNDAMENTALS OF COMPUTER

## USING MICROSOFT EXCEL

### HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Nathan wants a formula to return “Yes” if the value in cell A1 is less than the value in cell B1, and to return “No” otherwise. Which of the following functions should he use?
 A IFERROR B VLOOKUP C IF D RAND
Explanation:

Detailed explanation-1: -To determine whether the value in cell Al is less than the value in cell B1 and return “Yes” if it is, and “No” otherwise, Nathan can use the IF function. The syntax for the IF function is: =IF(logical test, value if true, value if false). The logical test in this case would be if Al<B1.

Detailed explanation-2: -The less than or equal to operator (<=) returns TRUE if the first value is less than or equal to the second value. 1. For example, take a look at the formula in cell C1 below. Explanation: the formula returns TRUE because the value in cell A1 is less than or equal to the value in cell B1.

Detailed explanation-3: -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-4: -The statement “A1 >= B1” tests whether the value in cell A1 is-lesser-than or equal to the value in cell B1. AutoFill, which copies content and formats from a cell or range into an-adjacent-cell or range.

There is 1 question to complete.