In the Makeupdb.xlsx file, how many dollars worth of lip gloss did Jen sell? G H 4
Question:
In the Makeupdb.xlsx file, how many dollars’ worth of lip gloss did Jen sell?
Transcribed Image Text:
G H 4 Trans Number Name 5 1 Betsy 2 Hallagan 3 Ashley 4 Hallagan 5 Zaret 6 Colleen 7 Cristina 8 Colleen 9 Ashley 6 7 8 9 10 11 123 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 10 Betsy 11 Ashley 12 Ashley 13 Emilee 14 Hallagan 15 Zaret 16 Emilee 17 Colleen 18 Jen 19 Jen 20 Zaret 21 Zaret 22 Betsy 23 Colleen 26 Emilee Date K Product Units 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 10/27/2004 eye liner 11/27/2005 lip gloss 6/2/2006 mascara 9/24/2004 eye liner 2/1/2006 mascara lip gloss 12/6/2006 1 M 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 12 $38.08 west 28 $ 86.51 midwest 25 $77.31 midwest 24 $ 74.62 west
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 83% (6 reviews)
We need to find all the entries where Jen is listed as the name an...View the full answer
Answered By
Akash M Rathod
I have been utilized by educators and students alike to provide individualized assistance with everything from grammar and vocabulary to complex problem-solving in various academic subjects. I can provide explanations, examples, and practice exercises tailored to each student's individual needs, helping them to grasp difficult concepts and improve their skills.
My tutoring sessions are interactive and engaging, utilizing a variety of tools and resources to keep learners motivated and focused. Whether a student needs help with homework, test preparation, or simply wants to improve their skills in a particular subject area, I am equipped to provide the support and guidance they need to succeed.
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
-
Using the data in the file named Makeupdb.xlsx, how many units of lip gloss did Zaret sell during 2004 and 2005? 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...
-
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...
-
How many units of lip gloss did Colleen sell outside the West 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 26 27 28 1 Betsy 2 Hallagan 3 Ashley 4...
-
A database is to be made to store information about a catalogue of CDs. Information to be stored about each CD includes title, price, genre, and a list of tracks. Each CD will also have an artist,...
-
Explain why professional skepticism is important in making professional judgments. What are the types of actions that a professionally skeptical auditor will take?
-
For the functions f(x) = 2x-2 and g(x) = 6x - 3, find (gof)(x).
-
What is meant by the concept litigation plan?
-
Presented below is information related to Meghani Company. Instructions Compute the ending inventory for Meghani Company for 2013 through 2018 using the dollar-value LIFOmethod. Ending Inventory...
-
Case : Stock A has a beta of .69 and an expected return of 9.27 percent. Stock B has a beta of 1.13 and an expected return of 11.88 percent. Stock C has a beta of 1.48 and an expected return of 15.31...
-
Conduct a Pareto analysis for the number of minutes that flights are late in the accompanying data. Interpret the results. E Click the icon to view the Atlanta Airline Data. Conduct a Pareto analysis...
-
Sort the sales data in workbook Chapter32Problem5data.xlsx in ascending order of units sold and, in case of ties, alphabetically AZ by product name.
-
The file named Makeupsortfont.xlsx contains our makeup data with certain dates shown in blue, red, or brown font. Sort the data so that the brown dates are on top, followed by the red dates and then...
-
Kadri Corporation reported basic EPS of $3.00 and diluted EPS of $2.40 for 2017. Its EPS calculations follow: Kadri issued the convertible preferred stock at the beginning of 2017 and the Series A...
-
Laura Li, a U.S. resident, worked for three months this summer in China. What type of tax authority may be especially useful in determining the tax consequences of her foreign income?
-
The version of the SIR model discussed in Section 21. 2 is flawed because it does not account for the possibility of prevalence elasticity. In Section 21.2 The SIR model of infectious disease...
-
Actionwear makes clothing and accessories for the fitness industry. The company is considering dropping its line of Fitbands. What costs would be considered relevant to this decision? Are there costs...
-
Explain why a random sample is one of the best ways to obtain a sample that is representative of the population.
-
Using Figure 7.8 as a starting point, consider the effect of a donut tax equal to $2 per donut, which increases the price of a donut from $1!to $3. In the figure below, assume that the new (posttax)...
-
In the Friend or Foe game, Foe is a (weakly) dominant strategy for both players. What can explain why, in roughly 50 percent of decisions, players chose Friend and split the sum of money with the...
-
Consider a game of poker being played with a standard 52-card deck (four suits, each of which has 13 different denominations of cards). At a certain point in the game, six cards have been exposed. Of...
-
The balance in Tahoma Companys raw materials inventory account was $150,000 at the beginning of June and $135,000 at the end of June. Raw materials purchased during the month totaled $50,000. Tahoma...
-
The balance in Amber Companys work-in-process inventory account was $400,000 at the beginning of September and $320,000 at the end of September. Manufacturing costs for the month follow. Required:...
-
Boulder Products, Inc., had the following activity for the month of October. Required: Prepare an income statement for the month of October. Sales revenue Selling expenses General and administrative...
-
Beginning inventory 150 Akira Company had the following transactions for the month. Cost per Unit $ 10 Number of units Purchased Mar. 31 160 130 50 Purchased Oct. 15 Ending inventory 12 15 ?...
-
Crane Service Center just purchased an automobile hoist for $31,500. The hoist has an 8-year life and an estimated salvage value of $3,800. Installation costs and freight charges were $4,100 and...
-
Hutchinson, Inc. provides the following data taken from its third quarter budget: Cash collections July $67,000 August $39,000 September $43,000 Cash payments: Purchases of direct materials 37,000...
Study smarter with the SolutionInn App