FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Answer: For example you can use the function SUM(range) to add and get the sum of all the individual values of a range of cells. Let’s say you want to add all the values of cell A1 until cell A5. To manually write A1+A2+A3+A4+A5 is a lot of work, so instead you can use the SUM() function.

Detailed explanation-2: -Formula for adding values of cells A1 to A5 would be =SUMA1 : A5.

Detailed explanation-3: -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-4: -In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.

Detailed explanation-5: -Using a formula like: =SUM(A1, A2, A3, B1, B2, B3)