Question

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.

Answer 1

Answer 2

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

Answer 3

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

Answer 4

Average Expense of all stores = $81,667

Working Note:

Store Location Revenue Expense Profit Queens $100,000 $70,000 $30,000 Brooklyn $160,000 $110,000 $50,000 Bronx $90,000 $65,000 $25,000 Total (Sums) $350,000 $245,000 $105,000 Averages $116,667 $81,667 $35,000

A B C D 1 Store Location Revenue Expense Profit 2 Queens 100000 70000 =+B2-C2 3 Brooklyn 160000 110000 =+B3-C3 4 Bronx 90000 65000 =+B4-C4 5 Total (Sums) =SUM(B2:34) =SUM(C2:04) =SUM(D2:04) 6 Averages =+AVERAGE(B2:B4) =+AVERAGE(C2:C4) =+AVERAGE(D2:04) 7

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.