List all the salespeople. Each row gives the salesperson, product sold, units sold, and revenue from a
Question:
List all the salespeople.
Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all cases, make sure your answers will automatically update if new data is added.
Transcribed Image Text:
F G 4 Trans Number Name: 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 1 Betsy 2 Hallagan 3 Ashley 4 Hallagan 5 Zarot 6 Colleen 7 Cristina 8 Colleen 9 Ashley 10 Betsy 11 Ashley 12 Ashley 13 Emilee 14 Hallagan 15 Zaret 16 Emilee 17 Colleen 18 Jen 19 Jen 20 Zaret I Product 4/1/2004 lip gloss 3/10/2004 foundatio 2/25/2005 lipstick 5/22/2006 lip gloss 6/17/2004 lip gloss 11/27/2005 eye liner 3/21/2004 eye liner 12/17/2006 lip gloss 7/5/2006 eye liner 8/7/2006 lip gloss 11/29/2004 mascara 11/18/2004 lip gloss 8/31/2005 lip gloss 1/1/2005 eye liner 9/20/2006 foundatio 4/12/2004 mascara 4/30/2006 mascara 8/31/2005 lip gloss 10/27/2004 eye liner 11/27/2005 lip gloss H Date J Units K L Dollars Location 45 $137.20 south 50 $152.01 midwest 9 $ 28.72 midwest 55 $167.08 west 43 $130.60 midwest 58 $175.99 midwest 8 $ 25.80 midwest 72 $217.84 midwest 75 $226.64 south 24 $ 73.50 east 43 $130.84 east 23 $ 71.03 west 49 $149.59 west 18 $ 56.47 south -8 $ (21.99) east 45 $137.39 east 66 $199.65 south 88 $265.19 midwest 78 $236.15 south 57 $173.12 midwest M N P =SORTBY(data,SEQUENCE(ROWS(data),1,ROWS(data),-1)) Q 1900 Cristina 1899 Hallagan 1898 Zaret 1897 Colleen 1896 Ashley 1895 Emilee 1894 Colleen 1893 Cici 1892 Cici 1891 Betsy 1890 Cici 1889 Emilee 1888 Colleen 1887 Zaret 1886 Cristina 1885 Ashley 1884 Hallagan 1883 Betsy R 38881 eye liner 39024 eye liner 38001 lipstick 38661 lip gloss 38397 foundation 38683 eye liner 38122 lip gloss 38199 foundatior 38771 mascara 38452 foundatior 38518 foundatior 39046 eye liner 38551 eye liner 38463 lip gloss 38573 mascara 38848 lip gloss 38859 lip gloss 38188 lip gloss S T 54 164.4873 midwest 28 85.65683 south 72 217.8359 west 46 140.4089 west 36 109.8426 east 15 47.16102 east 60 181.8703 east 20 61.92386 midwest 92 278.4349 west 39 119.1888 east 16 49.75399 east 76 229.9178 west 24 73.81115 west 61 185.3148 midwest 89 269.1475 south 12 37.83771 west 89 269.3955 west -6 -15.736 east
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 66% (9 reviews)
To automatically list all the salespeople from the given data you can use the following st...View the full answer
Answered By
Joshua Marie Geuvara
I am an academic writer with over 5 years of experience. I write term papers, essays, dissertations, reports, and any other academic paper. My main objective is to produce a high-quality paper free from plagiarism and ensure a student scores an A+. Being a fluent English speaker, I have great communication skills that also enable me to produce excellent papers.
I am conversant with most academic referencing styles (APA, MLA, and Harvard).
You can trust me with your paper and expect nothing less than quality and excellent results. I look forward to meeting with you and, more importantly, developing something that will both make us happy and satisfied.
0.00
0 Reviews
10+ Question Solved
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted:
Students also viewed these Business questions
-
Find all transactions where Ava was the salesperson or magazines were sold. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all cases, make sure...
-
Find all transactions where Liam sold candy. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all cases, make sure your answers will automatically...
-
List all salesperson/product/units combinations. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all cases, make sure your answers will...
-
Earned-value analysis. A project budget calls for the following expenditures: Task Date Budgeted Amount Build forms April 1 $10,000 Pour foundation April 1 $50,000 May 1 $100,000 Frame walls May 1...
-
Refer to the Auditing in Practice feature A Young Auditor Makes an Ethical Mistake in Professional Judgment. a. What was the ethical dilemma faced by Susan Birkerts friend when that fellow auditor...
-
Swathmore Clothing Corporation grants its customers 30 days' credit. The company uses the allowance method for its uncollectible accounts receivable. During the year, a monthly bad debt accrual is...
-
Continuing to focus on evidence associated with the act, concealment, and conversion, use the evidentiary material to continue the examination. In addition, as the examiner also start to think of...
-
Automobiles arrive at the drive-through window at a post office at the rate of 4 every 10 minutes. The average service time is 2 minutes. The Poisson distribution is appropriate for the arrival rate...
-
1C.1 What's the largest gravitational force you can produce between the two masses? (Note: it's convenient to express the forces in this sim in terms of piconewtons-pN. One piconewton is 0.000000 000...
-
Golden Wedding Dress Company designs custom wedding dresses for brides to be. The person preparing the adjusting entries at year-end was unable to complete the adjustments due to illness. You have...
-
Use the data in the file named Sales.xlsx to determine the following: Total dollar sales in the Midwest Total dollars that Heather sold in the East Total dollars that Heather sold or that were sold...
-
In the Makeupdb.xlsx file, how many dollars worth of lipstick were sold by Colleen or Zaret in the East region? G H 4 Trans Number Name 5 6 7 8 9 10 11 123 12 13 14 15 16 17 18 19 20 21 22 23 24 25...
-
Why are CEOs perpetrators of financial statement fraud?
-
Sopra Company is a closely-held corporation. Tony owns 60%, Carmella owns 20% and Meadow owns 20%, and all are related. Sopra Company has very large E&P. It was audited this year by the IRS and...
-
As a firm grows larger, ________-. a) economies of scale set in, then diseconomies of scale b) diseconomies of scale set in, then economies of scale c) economies of scale and diseconomies of scale...
-
The transcontinental railroads completed in the 1860s, 1870s, and 1880s all bypassed the ____. a) Northeast b) Midwest c) South d) mountain states e) Far West
-
There was a major tax cut in _____. a) both 1964 and 1981 b) neither 1964 nor 1981 c) 1964, but not in 1981 d) 1981, but not 1964
-
Each of the following is an example of capital except _____. a) land b) an office building c) a computer system d) a factory
-
RONA Inc. (www. rona. ca), founded in 1939, is Canadas leading distributor and retailer of hardware, home improvement, and gardening products. It has a network that exceeds 600 stores across Canada....
-
r = 0.18 Find the coefficients of determination and non-determination and explain the meaning of each.
-
What major factors are driving the internationalization of business? a. List and describe the five major dimensions for developing an international information systems architecture. b. Describe the...
-
What are the alternative strategies for developing global businesses? a. Describe the four main strategies for global business and organizational structure. b. Describe the four different system...
-
What are the challenges posed by global information systems and management solutions for these challenges? a. List and describe the major management issues in developing international systems. b....
-
Topic: challenges in logistic in recent years 1. How did the logistic firms in Berlin in food retail chain, manage the recent challenges of inflation and pandemic. Objective: My objective is to...
-
When you look at the world's top 100 economies by revenue, what will you notice ? give your opinion
-
A sample of 103 college students asked them if they likedstatistics. 92.2% said yes. Calculate a 97% confidence interval forthe true population proportion of those who like statistics. lower limit:...
Study smarter with the SolutionInn App