Find all transactions where Liam sold candy. Each row gives the salesperson, product sold, units sold, and
Question:
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 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 foundatior 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: 83% (6 reviews)
To find all transactions where Liam sold candy in the given data you can use Excels ...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
-
Sort the transactions in descending order of units. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all cases, make sure your answers will...
-
List all salesperson/product/units combinations that occur exactly once. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all cases, make sure your...
-
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...
-
Not sure if this note is applicable to the problem? (A2) Prove there is a bijection between any two countably infinite sets.
-
Refer to the Professional Judgment in Context feature at the outset of the chapter, which features the litigation charges against KPMG for its audit failures during the subprime mortgage crisis. a....
-
On April 19, 2018, Millipede Machinery sold a tractor to Thomas Hartwood, accepting a note promising payment of $120,000 in five years. The applicable effective interest rate is 7%. What amount of...
-
Im gathering some information about the sales/collection process and how it is supposed to work. Okay?
-
The Chen Company is considering the purchase of a new machine to replace an obsolete one. The machine being used for the operation has both a book value and a market value of zero; it is in good...
-
KORBIN COMPANY Comparative Balance Sheets December 31 Assets Current assets Long-term investments Plant assets, net Total assets Liabilities and Equity Current liabilities Common stock Other paid-in...
-
(a) Prepare any necessary transaction entries for 2019 and adjusting entries at December 31, 2019, using the financial statement effects template.(b) Prepare any necessary transaction entries for...
-
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...
-
The file named Deciles.xlsx contains the unpaid balance for 20 accounts. Use DBASE functions to compute the total unpaid balances in each decile. 8. In the file Makeupdb.xlsx, find all the unique...
-
Explain the regulation of the secretions of the small intestine.
-
An individual can build up his or her capital ______. a) by working longer hours only b) by cutting back on consumption only c) by both cutting back on consumption and working longer hours d) by...
-
Where is a price ceiling with respect to equilibrium price? What will be the relative size of quantity demanded and quantity supplied?
-
Which statement is the most accurate? a) Most of the worlds economies are close copies of the American capitalist model. b) The Chinese economy can best be described as democratic socialist. c)...
-
Capital comes from ______. a) gold b) savings c) high consumption d) the government
-
Which statement is the most accurate? a) During the 1980s, people in the Soviet Union and China who worked their own private plots were much more productive than those working on large collective...
-
Intrawest is a world leader in destination resorts and leisure travel. The companys success formula starts with a resort and then builds an animated village with shops, hotels, convention facilities,...
-
Suppose the S&P 500 futures price is 1000, = 30%, r = 5%, = 5%, T = 1, and n = 3. a. What are the prices of European calls and puts for K = $1000? Why do you find the prices to be equal? b. What...
-
How has e-commerce transformed marketing? a. Explain how Internet technology supports business-to-business electronic commerce. b. Define and describe Net marketplaces and explain how they differ...
-
How has e-commerce affected business-to-business transactions? List and describe important types of m-commerce services and applications.
-
What is the role of knowledge management systems in business? a. Define knowledge management and explain its value to businesses. b. Describe the important dimensions of knowledge. c. Distinguish...
-
Syed, who is 1.64 m tall, wishes to find the height of a tree with a shadow 35.12 m long. He walks 21.45 m from the base of the tree along the shadow of the tree until his head is in a position where...
-
Nonfinancial has a greater profit than financial. Manufacturing has the greatest profit with retail trade in second place and transportation and warehousing in last. Durable goods has a greater...
-
5. Suppose that population data on the score of the first exam in an econometrics class, along with hours of study per-day, is collected and reported per-student according to the data below. Study...
Study smarter with the SolutionInn App