DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The =SUM(A5:A9) function calculates the sum of the values from:
|
|
5 cells
|
|
|
2 cells
|
|
|
does not calculate an amount
|
|
|
there must be numbers in the specified cells
|
Explanation:
Detailed explanation-1: -Formula for adding values of cells A1 to A5 would be =SUMA1 : A5.
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: -It means the sum of all the values in the cells from A1 till A5 in MS Excel.
There is 1 question to complete.