D E H M N Client Database Jobs New Gift? Stolus Clients Total Jobs 24 6 18 Job Range 1 5 10 20 Status Bronze Silver Gold Platinum 12 1/1/20 1/1/14 1 B/2/16 5 1 New Start Date Loyalty Date New Starters Free Gifts Total Catering Jobs 10 258 B 2 12 6 2 3 4 1 1/7/18 2 6 10 16 - s Client ID 6 10130 7 10195 8 10315 9 10540 10 10639 11 10679 12 10932 13 11230 14 11280 15 11325 16 11344 17 11365 18 11584 19 11646 20 11762 21 11854 22 11958 23 12136 24 12141 25 12345 26 12443 27 12714 28 12802 29 12808 30 12811 31 12838 32 13063 33 13301 34 13824 35 13875 36 14051 37 14504 38 14515 39 15329 40 15458 41 15627 42 15928 43 15957 44 17091 45 17464 46 17769 47 18487 48 18536 49 1948 50 20626 51 20636 52 22216 53 22329 54 22740 Organisation Join Dale Versize 28/11/15 LACNE 29/1/13 First Finance 18/6/14 Colot 7/8/15 CTX 17/9/17 Steps IT Training 14/1/14 StepAhead 5/5/20 Duer Axell Group 23/7/20 ByleSize 17/7/16 Data Pro Sys 3/10/17 PicSure 7/11/19 Ripple Com 22/4/14 Pink Cloud Networks 16/10/14 Cyber Data Processing 8/3/19 TQ Processo 17/8/17 CTX 11/5/16 HearProof 1/12/19 Collings University 21/5/18 ASET PLC DENL 20/1/15 Zim Sales 15/11/13 Intelligence Systems 15/1/20 Respira Networks 14/12/19 EYN 24/9/13 Pilce Streambank 7/11/16 XLAN Internet Exchange 14/5/18 ICANT 18/6/19 Wix Labs 6/7/15 Parmis Technologies 17/11/13 Euro-M 27/2/16 TQ Processes 30/4/15 Oglev 14/4/15 Zconnect, Inc 10/10/19 AHA Networks 9/8/18 West Telco 9/6/1B Ebony Telecom 20/10/19 WWT 5/7/20 Mojba 1/9/14 Fzig Fibre 5/9/18 Chirah Technologies 3/8/18 Ares 6/8/20 IPI Bucharest 13/10/16 Show Construction 16/4/18 Epsilon Tech 29/7/14 Tatsan 16/1/20 Qinisor 14/7/18 UON 12/7/18 NetAssist 29/9/14 Client Contact Email Brad Gorman bgorman@versize.com.au Kanji Bhodia kbhodiacice.com.cu SeyedAlireza Vaziri svazirl firsfinance.com.au Vasilelos Giotsas viotas colot.com.au Geoffrey Huston ghusten@ctx.com.au Benedikt Stockebrand bstockebrand@steps training.com.au Petr paek pipaek@stepchead.com.au Tarek Fouad fouadde.com.au Steven Leander sleander@axellgroup.com.au Kevin Pillay kpillay@bytesize.com. Miquel van Smoorenburg mwan simoorenburg@dataprotys.com.au Lukasz Janczura lianczuro@picsure.com.au Christian Kaufmann ckoutmann ripplecom.com.au Dennis Thomas dthomas@pinkcloudnetworks.com.au Jonathan Freeman ifreeman@cyberdataprocessing.com.au Mehmet Tik mikroprocesse.com.au John HILI jhill@ctx.com.cn Brian Nisbet bnisbetheartproof.com.au Sepehr Ashoori sashoorcollingsuniversity.com Jordi Palet Martinez Ipalet martinez osatplc.com.au Steve Balon sbalon@denil.com.au Orlin Tenchev atenchevinales.com.au Musallam Alfarsi malforsl@intelligencesystems.com.au Sebastian Becker sbecker@respiranetworks.com.cn Ignas Bagdonas ibagdonasdeyn.com.au Noora Balouma nbalouma@pilcostreambank.com.au Christoph Dietzel cdietzel@xloninternetexchange.com.au Shahab Vahabzadeh svahabzadeh Qicant.com.au Zubair Bin Abdul Kader Shaik shaik@wizlabs.com.au Hannaneh Haiseyed avodi hhaliseyed avodi@parmistechnologies.com Marius Gruen mgruen@euro-m.com.au Ondrej Caletka ocaletko@taprocesses.com.au UIF Keber ukieberoplev.com.cn Ihor Baranovsky! ibaranovsky@connect, inc.com.au Kevin Pack kpack@ahanetworks.com.au Ernest Byaruhanga ebyaruhange@westtelco.com.au Karolina Hlobilov khlobilov ebonytelecoms.com.au Milad Afshari mafshari@ww..com. Miles McCrede mmccrede@mo bal.com.au Ole Jacobsen jacobsen@fzigfibre.com.au Gery Von Emelen gvan emelen@chirchtechnologies.com.au Sebastian Lohff slohff are.com Ionut Sandu Isandu@ipibucharest.com.au Knut A. Syed ksyed@shawconstruction.com.au Piotr Strzytewski patrzyzewskiepsilontech.com.au Seyed Ahmad Mousavi Smousavitatsan.com.cn Uta Meier-Hahn umeier-hahn@qinisor.com.cn Badar Al Mamor bal mamarl@uon.com.au Paul Thornton pthornton@netaassist.com.au 1 4 B 5 2 2 15 24 15 10 6 3 9 6 1 1 7 2 2 1 B 6 6 1 6 3 7 Question Instruction Marks Done C9 2 In M6 create a calculation to work out how many Clients have Bronze status. Copy the formula down to M9. In N6 create a calculation to work out how many jobs Clients with Bronze status have booked. Copy the formula down to N9. C10 2 C11 4 Create a Donut chart to show the percentage of clients of each status. Change the Chart Title to Client Status and add Data Labels to show percentages. Use Chart Element tools to position the legend at the bottom of the chart (do not drag)