DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=Sum(A1 to A5)
|
|
|
=Sum(A1+A2+A3+A4+A5)
|
|
|
=Sum(A1:A2:A3:A4:A5)
|
|
|
=Sum(A1:A5)
|
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: -=SUM(A1, A2, B5) . To refer to data in two or more contiguous cells, use a range reference like A1:A5. For example, to sum values in all cell between A1 and A5, inclusive, use this formula: =SUM(A1:A5) .
Detailed explanation-4: -=A1+A2+A3 Adds the values in cells A1, A2, and A3. =SQRT(A1) Uses the SQRT function to return the square root of the value in A1.
Detailed explanation-5: -Using a formula like: =SUM(A1, A2, A3, B1, B2, B3)