FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

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 will result in the total number of entries in the cell range B5 to B14?

A	Count
B	Max
C	MIn
D	Sum

Explanation:

Detailed explanation-1: -Answer: The COUNT function is used to count the number of numeric entries in a cell range in excel. where “range” is the cell range that you want to count the numeric entries for. The range can be a single cell, a group of cells, or a named range.

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: -Use the SUM function to sum numbers in a range.

Detailed explanation-4: -What is the use of the COUNT() function in Excel? Answer: Excel’s COUNT() function can be used to total the number of cells in a selected range. The COUNT() function will add up the number of cells in a selected range that contains numbers.

There is 1 question to complete.