DATABASE FUNDAMENTALS
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: -Formula for adding values of cells A1 to A5 would be =SUMA1 : 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.