FUNDAMENTALS OF COMPUTER

Previous

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 the number of cells in a range in her spreadsheet. She would like to count only the cell in that range that contain 100. Wha
A
SUMIF
B
AVERAGEIF
C
TOTALIF
D
COUNTIF
Explanation: 

Detailed explanation-1: -Use the COUNTA function function to count only cells in a range that contain values.

Detailed explanation-2: -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-3: -Count how often a single value occurs by using the COUNTIF function. Use the COUNTIF function to count how many times a particular value appears in a range of cells.

Detailed explanation-4: -The COUNTIF function counts the number of cells within a range that meet the criteria entered.

Detailed explanation-5: -The COUNTIFS function applies criteria to cells across multiple ranges and counts the number of times all criteria are met.

There is 1 question to complete.
Previous