contestada

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.

Respuesta :

sadddamkashmiri801

Answer & Explanation:

The formula in the cell B7 would be:

"=B5-B6"

And now we will press "Ctrl+C" to copy the formula in the Cell B7. After copying we will select the cell range C7 to D7 and press "Ctrl+V" to paste this formula in the cell C7:D7 and then will press Enter key. Now what we see is results in C7:D7 which we can check in our calculator whether these are corectly calculated or not.

MrRoyal

Excel formulas are expressions used to perform computation.

The Excel formula to enter in cell B7 is [tex]\mathbf{= B5- B6}[/tex]

From the question, we have:

  • Cell B6 represents expenses
  • Cell B5 represents sales

The profit is the difference between sales and expenses.

i.e.

[tex]\mathbf{Profiit = Sales - Expenses}[/tex]

So, we have:

[tex]\mathbf{B7= B5- B6}[/tex]

This means that, the formula to enter in cell B7 is: [tex]\mathbf{= B5- B6}[/tex]

The corresponding formulas in C7 and D7 are: [tex]\mathbf{= C5- C6 \ and\ =D5 - D6}[/tex]

Read more about Excel formulas at:

https://brainly.com/question/1285762

ACCESS MORE
ACCESS MORE
ACCESS MORE
ACCESS MORE

Otras preguntas