Each question is assumed to be independent in other words qu

Each question is assumed to be independent; in other words, questions do not depend on the answers to previous questions, and you assume at the start of each question that the worksheet is exactly as below:

If you want to calculate the product of \"x\" and \"y\", and put it in column C, what are the formula(s) that will go in the cells in column C? Give the formulas that will be in the cells in column C, for rows 3 through 6.

Assume cell C3 has the formula \"=B3+A3\" in it. What will be the value of C6 if you start at C3 and fill down through row 15?

Assume cell C6 has the formula \"=A$4*B9\". What will display in cell C6?

Assume cell C6 has the formula \"=A$4*B9\". You copy cell C6 and paste it to cell D7. What will display in cell D7? What formula will be in D7?

Assume cell C6 has the formula \"=A$4*B9\". You cut cell C6 and paste it to cell D7. What will display in cell D7? What formula will be in D7?

Solution

1. =A3*B3 for row 3

=A4*B4 for row 4

=A5*B5 for row 5

=A6*B6 for row 6

2. C6 will be A6 + B6 = 28

3. C6 will display 6

4. D7 will display 0.

Formula will be B$4*C10

5. D7 will display 6.

Formula will be A$4*B9