Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only thecells in that range that contain 100. What function should he use? $rightarrow$ COUNTIF

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

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 thecells in that range that contain 100. What function should he use?

A	False
B	True
C	Either A or B
D	None of the above

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 COUNTIF function to count how many times a particular value appears in a range of cells.

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

Detailed explanation-4: -Use AutoSum. Use AutoSum by selecting a range of cells that contains at least one numeric value. Then on the Formulas tab, click AutoSum > Count Numbers.

There is 1 question to complete.

FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL