DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Insert a formula that displays the number of Sales greater than $80.
|
|
=COUNTIF
|
|
|
=COUNT
|
|
|
=COUNTA
|
|
|
=SUM
|
Explanation:
Detailed explanation-1: -Use COUNTIF to figure cells greater than some chosen figure Whole criterion expression must be enclosed in double quotation marks, such as “>80.” Here, comparison operator must be enclosed in double quotation marks, while cell reference should not be enclosed in double quotation marks.
Detailed explanation-2: -Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its simplest form, COUNTIF says: =COUNTIF(Where do you want to look?, What do you want to look for?)
There is 1 question to complete.