USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What result does the COUNT function show?
|
|
Total number of cells containing data in the selected range
|
|
|
Total number of cells containing numbers in the selected range
|
|
|
Total number of cells containing text only in the selected range
|
|
|
Total number of cells containing the TRUE value specified in a logic test
|
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: -The COUNT function returns the total number of cells in the selected range that contain both text and numbers. The MAX function returns the total of all cells in the selected range. The MIN function returns the smallest value in a range of cells.
Detailed explanation-3: -Use the COUNT function in a formula to count the number of numeric values in a range.
There is 1 question to complete.