Please explain how to format the spreadsheet, and explain the functions that are used to format

We upload Congratulations! You got a job being a junior financial data analyst! Your first job is to make a tool for people at your company to easily find information about recently purchased online stocks. Remember, it is okay to ask questions Here is the datac Stackinfo.se They want to know a variety of things: Which customer has purchase the most dollar amount of stock? Which sector has the most purchases? (in amount and number - They also want to be able henter in a ticker symbol and tookup a transaction They want to be able to see how many stocks have been sold in each market You will turn in a workbook that meets their needs You will be straded on how usable your spreadsheet is. Remember, you want to keep in mind 1) Accuracy of data control over what people are entering in the lookups) 2) Information flow How do people move through your workbook? 3) Aesthetics: Use of color outlines, fonts, etc. to give meaning to your analysis 4) Self-Documenting: Using comments and tabels to know what to do in your spreadsheet consider having an opening sheet Home Insert Draw Page Layout Formulas Data Review View Help Table Design X Comments Daste - Cab - 11-AA BI-A. Conditional Formatting formatosable Gene $ - % 9 8- 13 WE 49 SSD- Port Sort & Find FS Clipboard Any Date Ford Style fx 4 Sd 43 first name last name 1 Reid Garment 2 Addie Breeder 3 Catharine Lee 4 Riordan Churchlow 5 Elle Lyness Cary Shearsby 7 Hamnet Daybell Melina McCory Ardene Heims 10 Daisy Skeidon 11 Carce Lidly 12 Vivien Wilmott 13 Damit Hammatt 14 Alexandrina Bidkerton 15 Murdoch Woodies 16 Gayle Megson 17 Mella Rolien 18 Ali Hannen 19 Tammi Lushe Stackine (1) G email Company Name Credit Card Number Amount Stock Market Steck Sector Stock Symbol Stock Name garmento@bras Twittelwire 1 1 + $19,237.95 NASDAQ Miscellaneous Urade Corporation breederowi Jannation 3.55145.15 $20,266.25 NASDAQ Technology SLP Simulations Plus, Inc. dee2@hco.co Zoombeat 3.56185E 15 $72,732 21 NASDAQ w/ MOTA Mota Group, Inc churchlow Meja 5.00767E-15 SR 183.75 NASDAG Health Care COMO Celor medicine Oro elynesdonba. Bubblebox 3.03736-1) $70,015.74 NYSE Finance ISG ING Group, NV cshearbysmolowiebus 5.0023615 $16.154.79 NYSE INT World Fuel Services Corpor hdaybell@huge Skinte 1.5882815 $19.71.42 NYSE n/ NI John Man Investors Tru mmodoryfreclayo 6331111.17 $58,57111 NASDAQ Macellaneous SAEV Services International shembusi. Podcat 4.5440115 352721 NYSE Finance SFR Safeguard Scientifics, Inc dikeldonoted.Oyonder 6.75998.15 577. 107 35 NASDAQ Finance ANOAU Andina Acquisition Corp clidele poste Wordtune 358416.15 513.194.51 NASDAG wa CACG Cleartridge AC Grow wwillmott behinnojam 5115515 $58.190.77 NASDAQ Technology TACT TransAct Technolopes con dhammattipaiYadel 35233319 $30,373 NYSE SNV Syrovus Financial Care abickerland Bye Vit 3.58766.15 $7,446 28 NYSE Consumer Durat ESCO Technologine mwoodierewo Ntags 5.0076715 527 101.41 NASDAQ Health Care CYAD Celyad SA melucon Gigaclub 201463E14 59,056.77 NASDAQ Consumer DuratAN Jason Industries, Inc mrolierige loc Oyondu 3.54855E 15 59,811.90 NYSE Ener PER Sandridge Permia Trust ahannenhama Wikido 1.5691415 571,678.00 NASDAQ Consumer Servic UNDW Lindblad Expeditions Haling tushay@bible offpedia 6.27145E12 $44.498.88 NASDAQ Health Care RNVA Rennda Health in 2 3 4 5 16 17 18 19 20 We upload Congratulations! You got a job being a junior financial data analyst! Your first job is to make a tool for people at your company to easily find information about recently purchased online stocks. Remember, it is okay to ask questions Here is the datac Stackinfo.se They want to know a variety of things: Which customer has purchase the most dollar amount of stock? Which sector has the most purchases? (in amount and number - They also want to be able henter in a ticker symbol and tookup a transaction They want to be able to see how many stocks have been sold in each market You will turn in a workbook that meets their needs You will be straded on how usable your spreadsheet is. Remember, you want to keep in mind 1) Accuracy of data control over what people are entering in the lookups) 2) Information flow How do people move through your workbook? 3) Aesthetics: Use of color outlines, fonts, etc. to give meaning to your analysis 4) Self-Documenting: Using comments and tabels to know what to do in your spreadsheet consider having an opening sheet Home Insert Draw Page Layout Formulas Data Review View Help Table Design X Comments Daste - Cab - 11-AA BI-A. Conditional Formatting formatosable Gene $ - % 9 8- 13 WE 49 SSD- Port Sort & Find FS Clipboard Any Date Ford Style fx 4 Sd 43 first name last name 1 Reid Garment 2 Addie Breeder 3 Catharine Lee 4 Riordan Churchlow 5 Elle Lyness Cary Shearsby 7 Hamnet Daybell Melina McCory Ardene Heims 10 Daisy Skeidon 11 Carce Lidly 12 Vivien Wilmott 13 Damit Hammatt 14 Alexandrina Bidkerton 15 Murdoch Woodies 16 Gayle Megson 17 Mella Rolien 18 Ali Hannen 19 Tammi Lushe Stackine (1) G email Company Name Credit Card Number Amount Stock Market Steck Sector Stock Symbol Stock Name garmento@bras Twittelwire 1 1 + $19,237.95 NASDAQ Miscellaneous Urade Corporation breederowi Jannation 3.55145.15 $20,266.25 NASDAQ Technology SLP Simulations Plus, Inc. dee2@hco.co Zoombeat 3.56185E 15 $72,732 21 NASDAQ w/ MOTA Mota Group, Inc churchlow Meja 5.00767E-15 SR 183.75 NASDAG Health Care COMO Celor medicine Oro elynesdonba. Bubblebox 3.03736-1) $70,015.74 NYSE Finance ISG ING Group, NV cshearbysmolowiebus 5.0023615 $16.154.79 NYSE INT World Fuel Services Corpor hdaybell@huge Skinte 1.5882815 $19.71.42 NYSE n/ NI John Man Investors Tru mmodoryfreclayo 6331111.17 $58,57111 NASDAQ Macellaneous SAEV Services International shembusi. Podcat 4.5440115 352721 NYSE Finance SFR Safeguard Scientifics, Inc dikeldonoted.Oyonder 6.75998.15 577. 107 35 NASDAQ Finance ANOAU Andina Acquisition Corp clidele poste Wordtune 358416.15 513.194.51 NASDAG wa CACG Cleartridge AC Grow wwillmott behinnojam 5115515 $58.190.77 NASDAQ Technology TACT TransAct Technolopes con dhammattipaiYadel 35233319 $30,373 NYSE SNV Syrovus Financial Care abickerland Bye Vit 3.58766.15 $7,446 28 NYSE Consumer Durat ESCO Technologine mwoodierewo Ntags 5.0076715 527 101.41 NASDAQ Health Care CYAD Celyad SA melucon Gigaclub 201463E14 59,056.77 NASDAQ Consumer DuratAN Jason Industries, Inc mrolierige loc Oyondu 3.54855E 15 59,811.90 NYSE Ener PER Sandridge Permia Trust ahannenhama Wikido 1.5691415 571,678.00 NASDAQ Consumer Servic UNDW Lindblad Expeditions Haling tushay@bible offpedia 6.27145E12 $44.498.88 NASDAQ Health Care RNVA Rennda Health in 2 3 4 5 16 17 18 19 20