USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=SUM(A1:A5)
|
|
|
Add A1-A5
|
|
|
Subtract the numbers
|
|
|
A1 = A5
|
Detailed explanation-1: -The sum formula is simply “=SUM(cell1:cell2)". So, if you want to sum cells A1 to A5, you would enter “=SUM(A1:A5)".
Detailed explanation-2: -When you enter =A1:A5 into any cell in rows 1 to 5, you will get the value from column A, from the same row where you entered that formula-unless you array enter it, in which case you will get 1, which is the first element of the array, returned to the first cell into which the formula is entered.
Detailed explanation-3: -It means the sum of all the values in the cells from A1 till A5 in MS Excel.
Detailed explanation-4: -The formula “=SUM(B1:B3)” adds the numbers of the cells B1 to B3. It returns 131. The SUM formula automatically updates with the insertion or deletion of a value. It also includes the changes made to an existing cell range.