DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
countblank function
|
|
|
min function
|
|
|
sum function
|
|
|
autosum
|
Detailed explanation-1: -Use the COUNTBLANK function, one of the Statistical functions, to count the number of empty cells in a range of cells.
Detailed explanation-2: -Heres a quick summary of what they do, followed by an example of each. COUNT counts how many cells in a range contain numeric data (numbers). COUNTA counts how many populated cells in a range (i.e. not blank). COUNTBLANK counts how many blank cells in a range.
Detailed explanation-3: -Count blank cells with condition In a situation, when you want to count empty cells based on some condition, COUNTIFS is the right function to use as its syntax provides for multiple criteria.
Detailed explanation-4: -Use the COUNTA function to count only cells in a range that contain values. When you count cells, sometimes you want to ignore any blank cells because only cells with values are meaningful to you. For example, you want to count the total number of salespeople who made a sale (column D).