DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
AVERAGEIF
|
|
|
COUNTIF
|
|
|
SUMIF
|
|
|
TOTALIF
|
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: -Use the SUBTOTAL function to count the number of values in an Excel table or range of cells. If the table or range contains hidden cells, you can use SUBTOTAL to include or exclude those hidden cells, and this is the biggest difference between SUM and SUBTOTAL functions.
Detailed explanation-3: -Detailed Solution. The correct answer is COUNT IF.
Detailed explanation-4: -The COUNTIFS function applies criteria to cells across multiple ranges and counts the number of times all criteria are met.