Hello! I need help with Excel. I'm currently stuck at these last 4 requirement: - Which customer has purchase the most dollar amount of stock? - Which sector has the most purchases? (in amount and...

Hello! I need help with Excel. I'm currently stuck at these last 4 requirement: - Which customer has purchase the most dollar amount of stock? - Which sector has the most purchases? (in amount and number) - I also want to be able to enter in a ticker symbol and lookup a transaction - I want to be able to see how many stocks have been sold in each market. Sample is provided below: id first_name last_name email Company_Name Credit_Card_Number Amount Stock_Market Stock_Sector Stock_Symbol Stock_Name 1 Reid Garment [email protected] Twitterwire 3.58394E+15 $19,237.95 NASDAQ Miscellaneous ULBI Ultralife Corporation 2 Addie Breeder [email protected] Jaxnation 3.55148E+15 $20,266.25 NASDAQ Technology SLP Simulations Plus, Inc. 3 Catharine Lee [email protected] Zoombeat 3.56185E+15 $72,732.21 NASDAQ n/a MOTA Mota Group, Inc. 4 Riordan Churchlow [email protected] Meejo 5.00767E+15 $28,383.75 NASDAQ Health Care CBMG Cellular Biomedicine Group, Inc. 5 Elfie Lyness [email protected] Bubblebox 3.03783E+13 $70,015.74 NYSE Finance ISG ING Group, N.V. 6 Cary Shearsby [email protected] Browsebug 5.00236E+15 $36,354.79 NYSE Energy INT World Fuel Services Corporation 7 Hamnet Daybell [email protected] Skinte 3.58828E+15 $19,521.42 NYSE n/a JHI John Hancock Investors Trust 8 Melissa McClory [email protected] Jayo 6.33111E+17 $58,571.13 NASDAQ Miscellaneous SREV ServiceSource International, Inc. 9 Ardene Heims [email protected] Podcat 4.84401E+15 $53,887.23 NYSE Finance SFE Safeguard Scientifics, Inc. 10 Daisy Skeldon [email protected] Oyonder 6.75998E+15 $77,107.35 NASDAQ Finance ANDAU Andina Acquisition Corp. II 11 Carce Lidgely [email protected] Wordtune 3.54841E+15 $13,394.51 NASDAQ n/a CACG ClearBridge All Cap Growth ETF 12 Vivien Willmott [email protected] Innojam 5.31525E+15 $58,399.77 NASDAQ Technology TACT TransAct Technologies Incorporated 13 Damita Hammatt [email protected] Yadel 3.57333E+15 $30,378.23 NYSE Finance SNV Synovus Financial Corp. 14 Alexandrina Bickerton [email protected] Vitz 3.58766E+15 $7,446.28 NYSE Consumer Durables ESE ESCO Technologies Inc. 15 Murdoch Woodier [email protected] Ntags 5.00767E+15 $27,101.41 NASDAQ Health Care CYAD Celyad SA 16 Gayle Megson [email protected] Gigaclub 2.01463E+14 $9,086.77 NASDAQ Consumer Durables JASN Jason Industries, Inc. 17 Mella Roglieri [email protected] Oyondu 3.54855E+15 $9,811.90 NYSE Energy PER SandRidge Permian Trust 18 Aili Hannen [email protected] Wikido 3.56914E+15 $71,678.00 NASDAQ Consumer Services LINDW Lindblad Expeditions Holdings Inc. 19 Tammi Lushey [email protected] Riffpedia 6.77145E+17 $44,498.88 NASDAQ Health Care RNVA Rennova Health, Inc. 20 Theressa Jeacop [email protected] Linkbuzz 5.60221E+15 $43,935.27 NASDAQ Health Care VBIV VBI Vaccines, Inc. 21 Clara Baskerfield [email protected] Dynabox 4.175E+15 $59,961.62 NASDAQ n/a VONE Vanguard Russell 1000 ETF 22 Wilow Strippling [email protected] Tanoodle 4.04137E+15 $74,786.66 NASDAQ Consumer Services PNK Pinnacle Entertainment, Inc. 23 Georgianne Fishpool [email protected] Skalith 5.48245E+15 $50,381.01 NYSE n/a APB Asia Pacific Fund, Inc. (The) 24 Celisse Roswarne [email protected] Jabbersphere 4.02639E+15 $81,701.72 NYSE Capital Goods LDR Landauer, Inc.
Jan 08, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here