USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Jane wants to count a range of cells in her spreadsheet. She would like Excel to count only the cells in that range that are greater than 1, 000. What function should she use?
|
|
AVERAGEIF
|
|
|
COUNTIF
|
|
|
SUMIF
|
|
|
TOTALIF
|
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: -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.
There is 1 question to complete.