Question

1. In cell B7, enter a formula without using a function to determine the profit generated at the Downtown location by subtracting the store’s expenses (cell B6) from the store’s sales (cell B5) for the week of March 1-7, 2018. Copy the formula you created in cell B7 to the range C7:D7.

Answer 1

The formula in Cell B7 will be =B5-B6

(Sales - Expenses)

When this is copied in C7, the formula will be C5-C6

In D7 it will be D5-D6

WORKINGS