Question

(a) In a worksheet column A, B and C are showing the quantity of an item in 3 different departmental stores. If column D is to display the total quantity, write the formula statement. 

(b) In Which cell should the above statement be written?

Answer 1

a) = sum (A1 : C1) (or)  

=sum (A1, B1, C1) (or) 

 = a1 + b1 + c1 

b) D1 

any rows may be used such as A2 : c2