FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The ____ function reverses the value of its argument.
A
NOT
B
IS
C
FLIP
D
OPPOSITE
Explanation: 

Detailed explanation-1: -The NOT function reverses the value of its argument. One common use for the NOT function is to expand the usefulness of other functions that perform logical tests.

Detailed explanation-2: -The NOT Function[1] is an Excel Logical function. The function helps check if one value is not equal to another. If we give TRUE, it will return FALSE and when given FALSE, it will return TRUE. So, basically, it will always return a reverse logical value.

Detailed explanation-3: -The REVERSE function returns a character string of exactly the same length as the argument, whose characters are exactly the same as those specified in the argument except that they are in reverse order.

Detailed explanation-4: -The reversed() function takes any sequence as an argument and returns a reversed iterator object. The iterator object accesses the objects of the sequence in reverse order.

Detailed explanation-5: -The REVERSE function operates on a string and returns the characters in reverse order. For example, reverse(’abcde’) returns edcba . This function works on numeric and date data types as well as character data types; however, in most cases it has practical value for character strings.

There is 1 question to complete.