Find all transactions where Ava was the salesperson or magazines were sold. Each row gives the salesperson,
Question:
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 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: 100% (4 reviews)
To find all transactions where Ava was the salesperson or magazines were sold we need to analyze the given data Based on the provided information it s...View the full answer
Answered By
Surendar Kumaradevan
I have worked with both teachers and students to offer specialized help with everything from grammar and vocabulary to challenging problem-solving in a range of academic disciplines. For each student's specific needs, I can offer explanations, examples, and practice tasks that will help them better understand complex ideas and develop their skills.
I employ a range of techniques and resources in my engaged, interesting tutoring sessions to keep students motivated and on task. I have the tools necessary to offer students the support and direction they require in order to achieve, whether they need assistance with their homework, test preparation, or simply want to hone their skills in a particular subject area.
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...
-
Build a circuit on a breadboard from the circuit diagram of the two loop-network circuits: www R
-
Thomas Flanagan was an audit partner and key member of management (Vice Chairman) at Deloitte LLP, based out of the firm's Chicago office. During the latter part of his career, he managed a large...
-
Explain how the CECL model (introduced in ASU No. 2016-13 and required in 2020) differs from current GAAP in its calculation of bad debt expense.
-
If you had been treated with respect, this would never have happened, would it?
-
Ideal Manufacturing Company of Sycamore, Illinois, has supported a research and development (R&D) department that has for many years been the sole contributor to the company's new farm machinery...
-
Note: Assume all raw materials were used as direct materials. Inventories Raw materials inventory Work in process inventory Finished goods inventory Activity during current year Raw materials...
-
On January 1, 2021, Acme Co. is considering purchasing a 40 percent ownership interest in PHC Co., a privately held enterprise, for $700,000. PHC predicts its profit will be $185,000 in 2021,...
-
The Duplicate worksheet in the Chapter35data.xlsx file contains two lists of names. Use an array formula to count the number of names appearing on both lists.
-
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...
-
Is it necessary and useful to have different valuation bases for different assets?
-
Which statement is true? a) The huge federal budget deficit was caused by market failure. b) Market failure is the main reason that we need public goods and services. c) Public goods and services are...
-
Goods and services that are nonexcludable and nonrivalrous, and tend to be indivisible are ______. a) public b) private c) both public and private d) neither public nor private.
-
It is sometimes suggested that the Federal Reserve should try to achieve zero inflation. If we assume that velocity is constant, does this zero-inflation goal require that the rate of money growth...
-
Which label most accurately describes the American economy? a) socialist b) purely capitalist c) predominately capitalist d) fascist e) communist
-
When you drive, rather than walk or take public transportation, you incur social costs such as ______.
-
Sino- Forest Corporation was a Chinese company that produced fibre boards for residential and commercial use. It made an initial public offering on the Alberta Stock exchange in 1994, and it listed...
-
How does Kant answer Humes bundle theory of self? Do you think he is successful?
-
What are the challenges that enterprise applications pose, and how are enterprise applications taking advantage of new technologies? a) List and describe the challenges posed by enterprise...
-
What are the unique features of e-commerce, digital markets, and digital goods? a. List and describe the eight unique features of e-commerce. b. Define a digital market and digital goods and describe...
-
What are the principal e-commerce business and revenue models? a. Name and describe the principal e-commerce business models. b. Name and describe the e-commerce revenue models.
-
oday's exchange rate between British pounds and US dollars is 1:1.29, meaning 1 pound is worth 1.29 dollars. For simplicity, we say the exchange rate between pound and dollar is 1.29. Consider a...
-
explain and provide correct answer otherwise downvote and report Under-recovery of overheads occurs when: 1. Actual overheads have fallen in relation to what they were expected to be 2. The overhead...
-
Suppose that a duck is swimming in the circle x =cos( t ), y =sin( t ) and that the water temperature is given bythe formula T = 5 x 2 e y + 5 xy 3 . Find dT/dt , the rate of change in temperature...
Study smarter with the SolutionInn App