USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
if
|
|
and
|
|
or
|
|
count
|
|
sum
|
Detailed explanation-1: -If you want to count logical values, text, or error values, use the COUNTA function. If you want to count only numbers that meet certain criteria, use the COUNTIF function or the COUNTIFS function.
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 correct answer to the question “Which one is not a function in MS Excel” is option (b). AVG. There is no function in Excel like AVG, at the time of writing, but if you mean Average, then the syntax for it is also AVERAGE and not AVG.