In the Makeupdb.xlsx file, how many dollars worth of lipstick were sold by Colleen or Zaret in
Question:
In the Makeupdb.xlsx file, how many dollars’ worth of lipstick were sold by Colleen or Zaret in the East region?
Transcribed Image Text:
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 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 19 Jen 20 Zaret 21 Zaret 22 Betsy 23 Colleen 26 Emilee Date 1 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 10/27/2004 eye liner 11/27/2005 lip gloss 6/2/2006 mascara 9/24/2004 eye liner 2/1/2006 mascara 12/6/2006 lip gloss K Units 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: 50% (6 reviews)
We must locate the rows with either Colleen or Zarets names and ...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
-
In the Makeupdb.xlsx file, how many dollars worth of lip gloss did Jen sell? 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...
-
In the Makeupdb.xlsx file, how many dollars of sales were made by Emilee or in the East region? G H 4 Trans Number Name 5 1 Betsy 2 Hallagan 3 Ashley 4 Hallagan 5 Zaret 6 Colleen 7 Cristina 8 Colleen...
-
For the data in the file named Tablemakeuptemp.xlsx (in this chapters Templates folder), determine the total units and revenue for all lip gloss or lipstick sold by Jen or Ashley in the East region....
-
The operations manager of a company that produces frozen dinners had received numerous complaints from supermarkets about the companys Chick-n-Gravy dinners. The manager spilled/mixed items,...
-
Describe rights theory and list the four levels of rights. In what way is rights theory particularly helpful?
-
The bank statement for the checking account of Management Systems Inc. (MSI) showed a December 31, 2018, balance of $14,632.12. Information that might be useful in preparing a bank reconciliation is...
-
A construction contract has the following language: It is the responsibility of the contractor to inspect and become familiar with the Project and to acquaint itself thoroughly with all conditions...
-
Bob Vance is unable to reconcile the bank balance at January 31. Bobs reconciliation is as follows. Cash balance per bank $3,560.20 Add: NSF check 690.00 Less: Bank service charge 25.00 Adjusted...
-
Can you explain why we neglect the gravitational force between most objects unless at least one of them has an enormous mass (Earth, moon, Sun)
-
A simply supported pretensioned beam has a span of 75 ft (22.9 m) and the cross section shown in Figure P3.1. It is subjected to a uniform gravitational live-load intensity W =1,200 plf (17.5 kN/m)...
-
List all the salespeople. 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...
-
Perform a case-sensitive AZ sort by name on the data in the workbook Chapter32Problem6data.xlsx.
-
Calculate the mass of KI in grams required to prepare 5.00 3 102 mL of a 2.80 M solution.
-
Human wants are _____. a) relatively limited b) relatively unlimited c) easily satisfied d) about equal to our productive capacity
-
A PhD driving a cab would be considered __________.
-
The five-year plan had been the main economic plan of _____. a) the United States b) Sweden c) Nazi Germany d) the Soviet Union
-
An automobile manufacturer will accept a shipment of tires only if an inspection of 5 percent of the tires, randomly chosen from the shipment, does not contain any defective tires. The manufacturer...
-
The net thermal efficiency of an internal combustion engine is given by, where HV is the heating value of the fuel and sfc is the specific fuel consumption of the engine. Consider an engine operating...
-
The Java House is developing its annual financial statements for 2014. The following amounts were correct at December 31, 2014: cash, $ 58,800; investment in shares of PAX Corporation (long term), $...
-
A consumer magazine is evaluating five brands of trash compactors for their effectiveness in reducing the volume of typical household products that are discarded. In the experiment, each block...
-
Describe the three sources of status.
-
Why does social loafing occur?
-
List the strengths and weaknesses of group decisionmaking .
-
A red car is located 50 miles to the north of a blue car. The red car begins to drive south at 40 miles per hour. Simultaneously, the blue car begins to drive east at 70 miles per hour. (a) What is...
-
Problem 2: Great white sharks are big and hungry. The dataset 'Sharks.csv' contains the lengths (in feet) of 44 great whites. a.State two things you would like to know about these data that would...
-
Module 9, Quadratic Functions Assignment When a company offers a new product or service, they estimate how much of that product or service people will want at different prices. This is referred to as...
Physics For Scientists And Engineers With Modern Physics 10th Edition - ISBN: 1337553298 - Free Book
Study smarter with the SolutionInn App