formula with mixed and absolute reference

Question

In cell B8, create a formula without using a function that multiplies the value in cell B7 by the value in cell B6 and then adds the value in B7. In this formula, use a mixed reference for cell B6 by including an absolute reference to row 6. Copy the formula from cell B8 to the range B9:B11 and then copy the formulas from the range B8:B11 to the range C8:H11

Answer 1

This question is not well posed, but here goes:

Formula in cell B8 is =B7*B$6+B7. The mixed reference is in bold. this copies down to

B9: B8*B$6+B8

B10: B9*B$6+B9

B11: B10*B$6+B10

and copies over to

C8: C7*C$6+C7

C9: C8*C$6+C8

C10: C9*C$6+C9

C11: C10*C$6+C10

As above the mixed references are in bold.

If the entries for B6 and B7 are 5 and 1 respectively, the computed values for B8:B11 would be 6, 36, 216 and 1296. if the entries for C6 and C7 were a and b respectively, the computed values for C8:C11 would be:

b*(a+1), b*(a+1)²,b*(a+1)³, etc.