FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

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]

Which function counts the number of cells within a range that meet the criteria?

A	SUMIF
B	COUNTIF
C	AVERAGEIF
D	VLOOKUP

Explanation:

Detailed explanation-1: -Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.

Detailed explanation-2: -The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.

Detailed explanation-3: -The COUNTIF function is a premade function in Excel, which counts cells as specified. NOTE: The COUNTIF function can have basic or more advanced uses. This covers the basic use for how to count specific numbers and words. Numbers (e.g. 90) and words (e.g. “Water") can be specified.

There is 1 question to complete.