# FUNDAMENTALS OF COMPUTER

## DATABASE FUNDAMENTALS

### BASICS OF BIG DATA

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Within a list or range, this function will tally all cells that have a given number.
 A PMT B Count C Rank D Mode
Explanation:

Detailed explanation-1: -Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5.

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: -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-4: -Remarks. The COUNTA function counts cells containing any type of information, including error values and empty text (""). For example, if the range contains a formula that returns an empty string, the COUNTA function counts that value.

There is 1 question to complete.