# numbers in column Al Add a 4th Column titled "Store Location" as shown below. Profit Revenue-...

numbers in column Al Add a 4th Column titled "Store Location" as shown below. Profit Revenue- 30,000 \$ 100,000 \$ Expenses 70,000 \$ \$ \$ \$ Profit Revenue Expenses 30,000 \$ 100,000 \$ 70,000 50,000 \$ 160,000 \$ 110,000 25,000 \$ 90,000 \$ 65,000 Store Location Queens Brooklyn Bronx Sums \$ \$ 105,000 \$ 35,000 \$ 350,000 \$ 116,667 \$ 245,000 81,667 Averages Calculating Sums: To calculate the "Sum of Profits," type "=SUM(A6:A8)" in Cell A10.
QUESTION 2 What is the Profit earned at the store in Brooklyn? QUESTION 3 What is the Total Revenue earned from all stores? QUESTION 4 What is the Average Expense of all stores combined?

Profit earned at the store in Brooklyn is \$50,000

Total Revenue earned from all stores = \$105,000 (See table below)

Average Expense of all stores = \$81,667

Working Note:

I hope this clear your doubt.

Feel free to comment if you still have any query or need something else. I'll help asap.

Do give a thumbs up if you find this helpful.

##### Add Answer of: numbers in column Al Add a 4th Column titled "Store Location" as shown below. Profit Revenue-...
Similar Homework Help Questions
Free Homework App

Need Online Homework Help?