Question

Task Instructions

In cel E10, create a fomula by entering cell references
that adds cells B9 and B10, and then subtracts cell EB.

Answer 1

= B9 + B10 - E8

Step-by-step explanation:

Required

Create a formula in E10 that subtracts E8 from the sum of B9 and B10

The sum of B9 and B10 is represented with B9 + B10

When E8 is subtracted, the formula becomes B9 + B10 - E8

To write a formula in Excel, you start with " = " sign.

So, type the following in cell E10

= B9 + B10 - E8

The cell references in this case are the name of the cells; i.e. B9, B10 and E8