Question

wo out of given four statements related to the working of =Count() and =CountA() function , are TRUE. Select 2 statements which are TRUE. =count() will count cells having numeric value =countA() will count cells having numeric value =count() will count cells having text as well as numeric value =countA() will count cells having Text as well as numeric value​

Answer 1

Answer:

The Excel COUNT function returns the count of values that are numbers, generally cells that contain numbers. Values can be supplied as constants, cell references, or ranges.

Purpose  

Count numbers

Return value  

Count of numeric values

Syntax  

=COUNT (value1, [value2], ...)

Arguments  

value1 - An item, cell reference, or range.

value2 - [optional] An item, cell reference, or range.

Version  

Excel 2003

Usage notes  

The COUNT function returns the count of numeric values in the list of supplied arguments. Arguments can be individual items, cell references, or ranges up to a total of 255 arguments. All numbers including negative values, percentages, dates, fractions, and time are counted. Empty cells and text values are ignored.

Explanation:

hope this helps...