USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
counts the number of cells that are not empty.
|
|
|
counts the number of cells that contain a number.
|
|
|
counts the number of cells in a range, that meets a given criteria.
|
|
|
counts the number of cells that are empty.
|
Detailed explanation-1: -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?)
Detailed explanation-2: -What is the COUNTIF Function? The COUNTIF Function[1] will count the number of cells that meet a specific criterion. The function is categorized under Excel Statistical functions. In financial analysis, the COUNTIF function is quite helpful.
Detailed explanation-3: -The COUNTIF function counts cells in a range that meet a given condition, referred to as criteria. COUNTIF is a common, widely used function in Excel, and can be used to count cells that contain dates, numbers, and text. Note that COUNTIF can only apply a single condition.
Detailed explanation-4: -The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments.