USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The word “SUM” in the function =SUM(A1:A100) is called:
|
|
the argument
|
|
|
the function name
|
|
|
the operator
|
|
|
the range
|
Explanation:
Detailed explanation-1: -The function sums values supplied as arguments (up to 255 arguments). Arguments can be supplied as numbers, cell references, ranges, arrays, constants, and the results of other formulas or functions.
Detailed explanation-2: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10. =SUM(A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.
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.