DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Returns the number of cells in a range that contain any value/label
|
|
Count
|
|
|
CountA
|
|
|
CountIf
|
|
|
List
|
Explanation:
Detailed explanation-1: -The COUNTA function counts the number of cells that are not empty in a range.
Detailed explanation-2: -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-3: -The COUNTA function is a premade function in Excel, which counts all cells in a range that has values, both numbers and letters.
Detailed explanation-4: -The COUNTA function counts the number of grades in Maths from B2 to B6, in English from C2 to C6, and in Computer from D2 to D6. It returns the values 3, 2, and 3 respectively.
There is 1 question to complete.