FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -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-2: -You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.

Detailed explanation-3: -Finding the range in such a data set is quite straightforward as well. Excel has the functions to find out the maximum and the minimum value from a range (the MAX and the MIN function).

Detailed explanation-4: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three.

Detailed explanation-5: -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.