USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The Count column found on the Grade Count table, can be computed by this function.
|
|
counta
|
|
|
countif
|
|
|
count
|
|
|
countblank
|
Explanation:
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.
Detailed explanation-2: -=COUNTIF(Range, criteria) The COUNTIF function uses the following arguments: Range (required argument) – This defines one or several cells that we wish to count. The range of cells are those cells that will be tested against the given criteria and counted if the criteria are satisfied.
Detailed explanation-3: -Like SUMIFS, COUNTIFS will allow you to take the count of rows or columns in a table that satisfy multiple specified conditions.
There is 1 question to complete.