Multiple choice

Which of the following are correct functions in Excel? (a) = SUM (A1 : A10) (b) = SUM (A1 : B10) (c) = SUM (B1 : A10) (d) = SUM (B10 : A1) (e) = SUM (B10 : A1)

  1. a, b only

  2. a, b, d only

  3. a, b, e only

  4. a, b, c, d only

  5. all of the functions are correct
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

All of the functions are correct. (a) = SUM (A1 : A10) will calculate sum of 10 cells from A1 to A10.  (b) = SUM (A1 : B10) will calculate sum of 20 cells from A1 to B10.  (c) = SUM (B1 : A10) is correct; it will work same as = SUM (A1 : B10) and calculate sum of 20 cells from A1 to B10. (d) = SUM (B10 : A1) is correct; it will work same as = SUM (A1 : B10) and calculate sum of 20 cells from A1 to B10. (e) = SUM (B10 : A1) will calculate sum of 2 cells B10 and A1 Comma(,) is used to represent a group of seperate cells. Colon(:) is used to represent a range or of cells.

 

Keep practicing — related questions