DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
An example of the function that returns the number of cells in a range of cells that contain data is ____
|
|
=NUMBER(B4)
|
|
|
=COUNT(B4)
|
|
|
=NUMBER(B4:B15)
|
|
|
=COUNT(B4:B15)
|
Explanation:
Detailed explanation-1: -The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.
Detailed explanation-2: -The COUNTIF Function[1] will count the number of cells that meet a specific criterion.
Detailed explanation-3: -The COUNTA function counts the number of cells that are not empty in a range.
There is 1 question to complete.