Question: 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,

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 update if new data is added.

F G 4 Trans Number Name: 5 6 7 8 9 10

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

Step by Step Solution

★★★★★

3.47 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To find all transactions where Liam sold candy in the given data you can use Excels ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Microsoft Excel Data Analysis 7th Questions!

In the few minutes before your interview begins, decide on a structure for it: funnel, pyramid, or diamond. In a paragraph, justify why you would proceed with the interview structure you have chosen...

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...

Sort the data in descending order of units, breaking ties based on dollars in descending order. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all...

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...

For an N-month $100,000 loan with monthly payments at a 10 percent annual rate, use the SEQUENCE function to determine each months contribution to principal and interest. If you change the number of...

Use the SEQUENCE function to list all integers from 1 to 10,000 in 1,000 rows and 10 columns. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all...

The MakeupSales.xlsx file gives sales data for a small makeup company. Each row lists the salesperson, product sold, location of the sale, units sold, and revenue generated. Use this file to perform...

1. The Makeup.xlsx file gives sales data for a small makeup company. Each row lists the salesperson, product sold, location of the sale, units sold, and revenue generated. Use this file to perform...

A piston/cylinder device operating in a cycle with steam as the working fluid executes the following steps: Steam at 550 kPa and 200oC is heated at constant volume to a pressure of 800 kJPa. It...

Emery Nurseries used the allowance method to record the following transactions, adjusting entries, and closing entries during the year ended December 31, 20--: Feb. 9 Received 60% of the $5,000...