FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The function used to count lots of data in a certain range ____
A
Count
B
Large
C
Small
D
Rank
Explanation: 

Detailed explanation-1: -COUNT: To count cells that contain numbers. COUNTBLANK: To count cells that are blank. COUNTIF: To count cells that meets a specified criteria. Tip: To enter more than one criterion, use the COUNTIFS function instead.

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: -The COUNT function is a premade function in Excel, which counts cells with numbers in a range. Note: The COUNT function only counts cells with numbers, not cells with letters.

Detailed explanation-4: -Use the COUNTIF function to count how many times a particular value appears in a range of cells.

There is 1 question to complete.
Previous
Next