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?
-
Target Corporation prepares its financial statements according to U.S. GAAP. Target's financial statements and disclosure notes for the year ended January 30, 2016, are available in Connect. This...
-
How would the primordial helium content of the universe have been affected if the present cosmic background radiation temperature was \(27 \mathrm{~K}\) instead of \(2.7 \mathrm{~K}\) ? What about...
-
Provide the missing data in the following table for a distributor of martial arts products: Division Alpha Bravo Charlie Sales $11,500,000 S ? $ 920,000 $210,000 Net operating income ? Average...
-
The index of refraction for a particular material is 1.38. Determine the speed of light in this medium. Light passes from water (n=1.33) into air (n=1.003) at an angle of incidence of 25 degrees....
-
You are considering a purchase of a 4-plex, which is located in a desirable neighborhood. The cost of the property is $500,000. Effective rents are expected to average $1500 per month. Every resident...
-
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...
-
You are providing financial advice to a shrimp farmer who will be harvesting his last crop of farm-raised shrimp. His current shrimp crop is very young and will, therefore, grow and become more...
-
What is the definition of codicil?
-
What is a personal representative?
-
When Ralph dies, he has not made a will and is survived by many relativesa spouse, children, adopted children, sisters, brothers, uncles, aunts, cousins, nephews, and nieces. What determines who...
-
Describe the balance sheet effect. Describe the vicious cycle of deleveraging. Why is it necessary for the government to step in to halt a vicious cycle of deleveraging?
-
Why did the creation of the Federal Reserve fail to prevent the bank runs of the Great Depression? What measures stopped the bank runs?
-
Gold Jewellers Inc. is developing its annual financial statements for 2015. The following amounts were correct at December 31, 2015: cash, $ 58,000; trade receivables, $ 71,000; merchandise...
-
On March 31, 2018, Gardner Corporation received authorization to issue $30,000 of 9 percent, 30-year bonds payable. The bonds pay interest on March 31 and September 30. The entire issue was dated...
-
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...
-
During the holidays, Kim makes and sells candy. Last holiday season, she made a profit of $10 on each box of candy she sold, and she sold 300 boxes. Based on some experimentation she did, Kim...
-
TTC Corporation purchased equipment on January 1 at a cost of $75,000. When purchased, the equigment years and a residual value of $15,000. Assuming TTC utilized the straight-line method of...
-
Is there an argument in BMI(1979 link: https://supreme.justia.com/cases/federal/us/441/1/) that the blanket license raises output and that price-fixing is required for blanket license? Output of what...
Study smarter with the SolutionInn App