Saturday, August 15, 2015

Q1. The following figure shows a part of a Microsoft Excel spreadsheet. Which of the following formulae cannot be used to add the given values 15,25 and 40?
              

    A
1
        15
2
        25
3
        30
4



(1)  =SUM(A1..A3)
(2)  = SUM A1+ SUM A2+  SUM A3
(3)  = a1+a2+a3

(4)  =SUM(A1,A2,A3)