Question

Which of the following statements about Excel is Correct? We should copy numbers rather than formulas It's a good idea to put actual numbers in the cells Check cell references before copying It's useless to check the copied cells to make sure formulas are correctly setup. Question 5 (1 point) Which of the following copies formulas to all the cells below till the last cell? Drag None Ctri+C and Ctri+V Drop down Question 6 (1 point) In Excel spreadsheet, the function SUM(-10,30,10)+ Average(-10,30,10) returns 10 30 40 Question 7 (1 point) If you want to multiply each cell in B3:B9 with its corresponding cell in A3:A9 and then output sum of all the products in cell B12, What formula should be entered in cell B12? 1) -SUM (A3:A9.B3 B9) 2) -PRODUCT (A3 A9.B3 B9) 3) SU PRODUCT (A3 A9.B3 B9) 4) -SUMPROD (A3 A9.83 89)

Answer 1

4.

The following statement about Excel is correct:

Check cell references before copying

5.

Drag copies formulas to all the cells below till the last cell.

6.

The function =SUM(-10,30,10)+Average(-10,30,10) will return 40.

7.

The following formula will be entered in cell B12:

=SUMPRODUCT(A3:A9,B3:B9)