COMPUTER APPLICATIONS
OFFICE AUTOMATION SOFTWARE
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following syntax is correct regarding to SUM function in Excel?
|
|
=SUM (A1, B1)
|
|
|
=SUM (A1:B9)
|
|
|
=SUM (A1:A9, B1:B9)
|
|
|
All of the above
|
Explanation:
Detailed explanation-1: -SUMIF. Perform the SUM function only if there is a specified value in the first selected cells. An example of this would be =SUMIF(A1:A6, “TEST", B1:B6), which only adds the values B1:B6 if the word “test” was entered somewhere between A1:A6.
Detailed explanation-2: -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.
There is 1 question to complete.