DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
COUNTIF
|
|
|
COUNT
|
|
|
COUNTIFS
|
|
|
SUMIFS
|
Detailed explanation-1: -The COUNTIF Function[1] will count the number of cells that meet a specific criterion. The function is categorized under Excel Statistical functions.
Detailed explanation-2: -The COUNTIF function is a premade function in Excel, which counts cells as specified. NOTE: The COUNTIF function can have basic or more advanced uses. This covers the basic use for how to count specific numbers and words. Numbers (e.g. 90) and words (e.g. “Water") can be specified.
Detailed explanation-3: -Syntax: “=COUNTIF([range], [criteria])” where range = group of cells and criteria = value with range data. Set up: Enter example data > select cell > Formulas tab > More Functions > Statistical > COUNTIF. Highlight range: Place cursor in Range text box in Function Arguments dialog box > select cells.
Detailed explanation-4: -To count cells using a single criteria, use the COUNTIF function. The SUMIF function adds only the values that meet a single criteria. The SUMIFS function adds only the values that meet multiple criteria.