contestada

14. In cell B14, create a formula without using a function that adds 1 to the value in cell B12 and then multiplies the result by the value in cell B13. Update the reference to cell B12, from a relative reference to a mixed reference by making an absolute reference to row 12. Copy the formula from cell B14 to the range B15:B17 and then copy the formulas from the range B14:B17 to the range C14:H17.

Respuesta :

Answer:

The formula for the given problem is given below:

= (1+B$12)×B13

Explanation:

Immediately you do one, then you can autofill the formula to the mentioned range B15:B17 and then to C14 to H17

When been done correctly, this is how the formula will look in those cells if you do it correctly.

Check the file attached below to see it.

Ver imagen yahayadanjuma55
MrRoyal

Microsoft Excel uses absolute, mixed and relative cell references to reference a cell.

The cell formulas from B14 to B17 are:

  • = (1+B$12)×B13
  • = (1+B$12)×B14
  • = (1+B$12)×B15
  • = (1+B$12)×B16

Before writing the formula, the following points should be noted

  • Using relative reference, cell B12 will be written as B$12.
  • Excel formulas begin with =

So, the formula to enter in cell B14 is: = (1+B$12)×B13

When the formula is copied from B14, down to B17, the formulas will be:

  • = (1+B$12)×B13
  • = (1+B$12)×B14
  • = (1+B$12)×B15
  • = (1+B$12)×B16

Notice that cell B12 maintain its original format of B$12, while B13 changes to B14, B15 and B16.

This is so because cell B12 is referenced using relative reference.

See attachment for further explanation.

Read more about cell referencing at:

https://brainly.com/question/1228033

Ver imagen MrRoyal

Otras preguntas