Use the file named Makeup2007.xlsx for questions 1016. Create a table that, when you enter a year
Question:
Use the file named Makeup2007.xlsx for questions 10–16.
Create a table that, when you enter a year in your worksheet, contains sales of each product by person during that year.
Transcribed Image Text:
G H 4 Trans Number Name 456789 10 11 12 13 14 15 16 17 18 19 222 1 Betsy 2 Hallagan 3 Ashley 4 Hallagan 5 Zaret 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 Date J Product 4/1/2004 lip gloss 3/10/2004 foundatior 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 foundatior 4/12/2004 mascara 4/30/2006 mascara 8/31/2005 lip gloss K Units L Dollars 45 $137.20 50 $ 152.01 9 $ 28.72 55 $167.08 43 $ 130.60 58 $ 175.99 8 $ 25.80 72 $ 217.84 75 $ 226.64 24 $ 73.50 43 $ 130.84 23 $ 71.03 49 $ 149.59 18 $ 56.47 -8 $ (21.99) 45 $ 137.39 66 $199.65 88 $ 265.19
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 100% (5 reviews)
Answered By
Sinmon Warui Kamau
After moving up and down looking for a job, a friend introduced me to freelance writing. I started with content writing and later navigated to academic writing. I love writing because apart from making a living out of it, it is also a method of learning and helping others to learn.
5.00+
40+ Reviews
45+ 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
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
(6. A cylinder weighing 120N rests between two frictionless walls as shown in the following figure. B 3 The wall reaction (N) at Point A is most nearly: (A) (B) (C) 96 139 150 200 (7. A body is...
-
? ?? ? Prepare Company 1's COMPLETE CASH FLOW STATEMENT for 2016 (that includes CFO, CFI, CFF) using INDIRECT approach for CFO part. Explain how to treat for accounting purposes occupation of...
-
Refer to the Auditing in Practice feature "Description of Common Types of Earnings Management Techniques." Why might it be difficult for auditors to disallow companies' preferences to decrease...
-
The following trial balance relates to Quincy as at 30 September 2019: The following notes are relevant: 1. On 1 October 2018, Quincy sold one of its products for 10 million (included in revenue in...
-
In an experiment to determine the effect of ambient temperature on the emissions of oxides of nitrogen (NOx) of diesel trucks, 10 trucks were run at temperatures of 40F and 80F. The emissions, in...
-
Multiple Choice Questions Select the best answer for each of the following and explain the reason for your selection. a. Which of the following procedures is least likely to be completed before the...
-
Answer the following questions. Show all work. (6 pts) 1. If y 3x-5 3x+8 find d'y dx (5 pts) 2. If an object's position, in yards, after 1 minutes, is given by s(t)=850-80+21+3r, find the object's...
-
Prepare a December 31 trial balance for Jindal Company using the following information and fill in the missing amount for Equipment (assume all data are correct). Cash Accounts payable Services...
-
Use the file named Makeup2007.xlsx for questions 1016. What is the average dollar size of a foundation sale made by Betsy after the end of 2004? G H 4 Trans Number Name 456789 10 11 12 13 14 15 16 17...
-
Use the file named Makeup2007.xlsx for questions 1016. What is the average number of units of foundation sold by Emilee? G H 4 Trans Number Name 456789 10 11 12 13 14 15 16 17 18 19 222 1 Betsy 2...
-
Solve each inequality and graph the solution. 1. 2(x - 1) - 3 > 4x + 1 2. 7x + 4 ( 2(x - 1) 3. 4. - 3x ->3 -x 2
-
What is the role of the entrepreneur in translating cost of production into supply?
-
True or false? Because entrepreneurs are motivated by opportunities to sell an item at a price higher than the average cost of producing it, they do not start for-benefit firms. Explain your answer.
-
How is efficiency related to the number of firms in an industry characterized by strong economies of scale?
-
Draw a short-run marginal cost curve, short-run average cost curve, and long-run average total cost curve for an efficient firm producing where there are diseconomies of scale.
-
Is an oligopolist more or less likely to engage in strategic decision making compared to a monopolistic competitor?
-
Radial keratotomy is a type of refractive surgery in which radial incisions are made in the cornea of myopic (nearsighted) patients in an effort to reduce their myopia. Theoretically, the incisions...
-
Suppose the government bond described in problem 1 above is held for five years and then the savings institution acquiring the bond decides to sell it at a price of $940. Can you figure out the...
-
What are the advantages and disadvantages of allowing employees to use their personal smartphones for work?
-
What management , organization, and technology factors should be addressed when deciding whether to allow employees to use their personal smartphones for work?
-
Compare the BYOD experiences of Michelin North America and Rosendin Electric. Why did BYOD at Michelin work so well?
-
After learning the course, you divide your portfolio into three equal parts (i.e., equal market value weights), with one part in Treasury bills, one part in a market index, and one part in a mutual...
-
1 points Save Answer The bonds issued by United Corp. bear a coupon of 7 percent, payable semiannually. The bond matures in 19 years and has a $1,000 face value. Currently, the bond sells at $1040....
-
You'd like to buy a 20-year, noncallable bond with an annual coupon rate of 8.4% paid semi-annually. The bond has a par value of $1,000. If you require an 8.25% nominal yield to maturity on this...
Study smarter with the SolutionInn App