contestada

13. In cell b13, create a formula without a function using absolute references that subtracts the values of cells b5 and b7 from cell b6 and then multiplies the result by cell b8. Copy the formula from cell b13 to the range c13:h13.

Respuesta :

MrRoyal

Excel formulas are expressions used to perform computation.

The formula in Excel is: =($B$6 - $B$5 - $B$7)* $B$8

How to determine the formula

From the question, we are to:

  • Subtract B5 and B7 from B6
  • Use absolute style referencing

To use the absolute reference in Excel cells, we have to include the dollar "$" sign.

This means that: a cell A1 will be written as: $A$1;

So, the formula to enter in cell B13 is:

=($B$6 - $B$5 - $B$7)* $B$8

Read more about Excel formulas at:

https://brainly.com/question/14820723

Otras preguntas