Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

numbers in column Al Add a 4th Column titled Store Location as shown below. Profit Revenue- 30,000 $ 100,000 $ Expenses 70,000 $ $ $

image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

No Nonsense Employee Retention Audit

Authors: Jeff Kortes

1st Edition

0988307014, 978-0988307018

More Books

Students also viewed these Accounting questions