# FUNDAMENTALS OF COMPUTER

## USING MICROSOFT EXCEL

### ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The function COUNTA is used for counting cells that contain
 A numbers and logical values only B text, numbers and logical values only C text, numbers, logical values and error values only D text, numbers, logical values, error values, and empty text (” “)
Explanation:

Detailed explanation-1: -The COUNTA function counts cells containing any type of information, including error values and empty text (""). For example, if the range contains a formula that returns an empty string, the COUNTA function counts that value. The COUNTA function does not count empty cells.

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 COUNTA function is used when there is a need to count the number of cells in single or multiple non-blank ranges. The cell range can also be non-adjacent. For example, for counting cells in the range B1:B50, the formula is “=COUNTA (B1:B50).” The function also counts the number of value arguments provided.

Detailed explanation-4: -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-5: -COUNTA says it will count the number of cells in a range that are not empty. COUNTBLANK says that it will count the number of empty cells in a specified range. So COUNTA and COUNTBLANK treat cells containing “” differently. This is inconsistent behaviour, but once you learn this, you can work with it.

There is 1 question to complete.