Pls help me this using excel software

PART SORT AND FILTER QUESTIONS ANSWER ALL QUESTIONS Question 3 Based On Table 3: 1 NURUL NAJWA BINTI ABDULLAH 2 NURUL IZZYANI BINTI ROSLAN 3 RABIATUL ADAWIYAH BINTI SHUIB 4 SHAFIQAH AMIRA FARIHA BT SHUIB MOHAMMAD HABIBULLAH DINI BIN MOHAMMAD SHAHRIL 5 6 MUHAMMAD IQBAL HANIF B. SAULI MUHAMMAD FARHAN BIN MOHAMMAD FAISOL 7 8 AHMAD MUHAIMIN BIN MAZLAN 9 NOOR AZTASHA BINTI ZULKIFLI 75 1A, KUALA SUNGAI PADANG, SIMPANG EMPAT 02700 NO.6, TAMAN REPOH INDAH KM 3.5 JALAN KANGR-ARAU, KANGAR 01000 PERLIS 1051, LRG MAS 1 TAMAN DELIMA SUNGAI PETANI 08000 KEDAH NO. 24, JALAN DAHLIA 10, TAMAN IRA, KANGAR, PERLIS. 01000 PERLIS NO.387, KAMPUNG DATO', BEHOR LATEH, KAYANG 01000 PERLIS NO.55,KUATERS MADA BEHOR LATEH, KANGAR 01000 PERLIS NO. 18 TAMAN SURIA 5 JITRA 06000 KEDAH NO. 58 JALAN 7 TAMAN PAUH INDAH PAUH ARAU 02600 PERLIS 131, KAMPUNG PIDA 3 SEMUT GATAL, TAMBUN TULANG, ARAU, PERLIS. 02600 PERLIS NO.9 JALAN MASMUDA 5 TAMAN MASMUDA KANGAR 01000 PERLIS NO. 48, KG. BELAKANG KILANG, SUNGAI SIPUT, KUALA PERLIS, 02000 PERLIS NO 64, JLN SEKOLAH TUNJONG, BESERI, PERLIS 02400 PERLIS KM 4, JALAN SERIAB, KANGAR 01000 PERLIS 88A, BT 1, JLN SANTAN 01000 PERLIS NO 8, LORONG 16, TAMAN SRI WANG, FASA II, ARAU 02600 PERLIS NO 8, LORONG JAMBU MERAH, KANGAR 01000 PERLIS A21 LORONG HAJI SAMAN BATU 4 1/4 JALAN KAKI BUKIT KANGAR 01000 PERLIS 48, KG BOHOR MALI, JALAN BOHOR MASJID, 10 NUR DIANA BINTI ROSLAN 11 NURUL QAMARINA BINTI NOR AZZAMI 12 NURUL FARHANA BT NORDIN 13 NURAISYA BT AZIZAN 14 FATIN FAZIRA BINTI ROZAIDI 15 MASRIAH BINTI MOHD SALLEH 16 HILMAN HANIF BIN MANSOR 17 HAIRUL IKHWAN BIN CHE HASNOOL 18 NURUL AIDA BT SHAKIR 5 19 NURIL ALIF B AZMAN MUHAMMAD SAYYID HAZIM BIN MUHD. 20 NOOR 21 MUHAMAD FITRI B. ROSLAN 22 MUHAMMAD IZZAT AKMAL BIN FOAZI 23 NOR FATIN NABILA BINTI YUSRI WAN MUHAMMAD HADI BIN WAN AHMAD 24 HAZMI 25 NURUDDIN BIN MOHAMAD KAMAL 26 NURUL SYASYA BINTI ABDUL RAHAMAN 27 SITI NUR IZZATI BINTI JUMRI 28 KU AIFAA TASNIM BINTI KU SAIDIN 29 NUR NAZUHA BINTI ZULKIFLI KUALA PERLIS 02000 PERLIS NO 100B, JALAN PADANG NYU, ARAU 02600 PERLIS NO.37A, PIDA 3,JALAN SANGLANG, KODIANG, KEDAH 06100 PERLIS K-19 PEKAN SIMPANG EMPAT, 02700 PERLIS NO. 10 JALAN 7 TAMAN SANTAN 2 02400 PERLIS 22, JALAN ROSLI TALIB, KAMPUNG KURUNG TENGAR 02000 PERLIS NO 278, JLN CENGAL, 2/8, TMN CENGAL INDAH, KULIM 09000 KEDAH NO. 26, LORONG 1, TAMAN SRI WANG FASA 1, 02600 ARAU, PERLIS 02600 PERLIS BATU 4, JALAN SIMPANG EMPAT 01000 PERLIS NO 17 LORONG 5, TAMAN ANGSANA BUKIT KETERI 02450 PERLIS Bt 1 1/4, JLN DATO KAYAMAN, BKT KETERI 02450 PERLIS NO 9, JALAN 10, TAMAN SANTAN II, KANGAR 01000 PERLIS KPG KENANGAN SIMPANG AMPAT, SIMPANG AMPAT, PERLIS 02700 PERLIS 6C, KG PADANG BESAR MUKIM KURUNG ANAI, ARAU 02600 PERLIS 88 JALAN CHIN ALI KUBANG GAJAH ARAU 02600 PERLIS 174, KAMPUNG BELAKANG KILANG, KUALA PERLIS, PERLIS. 02000 PERLIS KAMPUNG TANJUNG BULUH, MUKIM SERIAB, KANGAR, PERLIS 01000 TIADA MAKLUMAT P/S NO 89, JALAN SURAU, KAMPUNG ABI PADANG MACHANG, KANGAR 01000 PERLIS NO.32,LORONG HAJI OSMAN JALAN SANTAN, 0100 KANGAR,PERLIS 01000 PERLIS A-1-4 KUARTERS KTMB PADANG BESAR (U) JALAN KG.KOLAM 02100 PERLIS KEPALA TITI TOK PULAU PAUH SANGLANG 02700 SIMPANG EMPAT PERLIS 30 MUHAMMAD AMIR FIRDAUS B NORISHAM 31 MUHAMMAD NIZAM BIN IBRAHIM 32 NURDIYANA SYAHIRA BINTI AHMAD SHAFIR 33 KHAIRUL MUSFIRAH BINTI ABD KARIM 34 NOR SYAKILA BT ISMAIL 35 NURUL AMIRAH BINTI SAHIDI 36 FARRAH NUR ISWANIE BT.JASNI 37 NUR AIN HASSANAH BINTI KHAIRUNSAM 38 NOR ATIKAH BINTI MANSOR 02700 PERLIS NO 1, KG. SERIAB KANGAR 01000 PERLIS 39 NUR IZZATI BINTI ABD MALEK 6 40 ABDUL HAKEEM BIN ADAM LOT 535, KG DATO UTAN AJI, KANGAR 01000 PERLIS Table 3 a. Insert this row on the top NO NAME ADDRESS POSTCODE DISTRICT STATE b. Separate the data (address) according to the title on the first row above c. Find and Replace all the SHORT FORM into correct spelling (e.g: LRG = LORONG, BT = BATU, KG = KAMPUNG d. Filter all data by DISTRICT where "KANGAR". e Filter all data by STATE where "PERLIS" f. Sort all data by SECOND COLUMN into Ascending Order & Sort all data by NAME and ADDRESS to view in Row Labels. h. Sort all data by DISTRICT and STATE to view in Row Labels. i. Use align center for all the data. SELECT ALL DATA and create ONE (1) BAR GRAPH to display all statistic data. PART SORT AND FILTER QUESTIONS ANSWER ALL QUESTIONS Question 3 Based On Table 3: 1 NURUL NAJWA BINTI ABDULLAH 2 NURUL IZZYANI BINTI ROSLAN 3 RABIATUL ADAWIYAH BINTI SHUIB 4 SHAFIQAH AMIRA FARIHA BT SHUIB MOHAMMAD HABIBULLAH DINI BIN MOHAMMAD SHAHRIL 5 6 MUHAMMAD IQBAL HANIF B. SAULI MUHAMMAD FARHAN BIN MOHAMMAD FAISOL 7 8 AHMAD MUHAIMIN BIN MAZLAN 9 NOOR AZTASHA BINTI ZULKIFLI 75 1A, KUALA SUNGAI PADANG, SIMPANG EMPAT 02700 NO.6, TAMAN REPOH INDAH KM 3.5 JALAN KANGR-ARAU, KANGAR 01000 PERLIS 1051, LRG MAS 1 TAMAN DELIMA SUNGAI PETANI 08000 KEDAH NO. 24, JALAN DAHLIA 10, TAMAN IRA, KANGAR, PERLIS. 01000 PERLIS NO.387, KAMPUNG DATO', BEHOR LATEH, KAYANG 01000 PERLIS NO.55,KUATERS MADA BEHOR LATEH, KANGAR 01000 PERLIS NO. 18 TAMAN SURIA 5 JITRA 06000 KEDAH NO. 58 JALAN 7 TAMAN PAUH INDAH PAUH ARAU 02600 PERLIS 131, KAMPUNG PIDA 3 SEMUT GATAL, TAMBUN TULANG, ARAU, PERLIS. 02600 PERLIS NO.9 JALAN MASMUDA 5 TAMAN MASMUDA KANGAR 01000 PERLIS NO. 48, KG. BELAKANG KILANG, SUNGAI SIPUT, KUALA PERLIS, 02000 PERLIS NO 64, JLN SEKOLAH TUNJONG, BESERI, PERLIS 02400 PERLIS KM 4, JALAN SERIAB, KANGAR 01000 PERLIS 88A, BT 1, JLN SANTAN 01000 PERLIS NO 8, LORONG 16, TAMAN SRI WANG, FASA II, ARAU 02600 PERLIS NO 8, LORONG JAMBU MERAH, KANGAR 01000 PERLIS A21 LORONG HAJI SAMAN BATU 4 1/4 JALAN KAKI BUKIT KANGAR 01000 PERLIS 48, KG BOHOR MALI, JALAN BOHOR MASJID, 10 NUR DIANA BINTI ROSLAN 11 NURUL QAMARINA BINTI NOR AZZAMI 12 NURUL FARHANA BT NORDIN 13 NURAISYA BT AZIZAN 14 FATIN FAZIRA BINTI ROZAIDI 15 MASRIAH BINTI MOHD SALLEH 16 HILMAN HANIF BIN MANSOR 17 HAIRUL IKHWAN BIN CHE HASNOOL 18 NURUL AIDA BT SHAKIR 5 19 NURIL ALIF B AZMAN MUHAMMAD SAYYID HAZIM BIN MUHD. 20 NOOR 21 MUHAMAD FITRI B. ROSLAN 22 MUHAMMAD IZZAT AKMAL BIN FOAZI 23 NOR FATIN NABILA BINTI YUSRI WAN MUHAMMAD HADI BIN WAN AHMAD 24 HAZMI 25 NURUDDIN BIN MOHAMAD KAMAL 26 NURUL SYASYA BINTI ABDUL RAHAMAN 27 SITI NUR IZZATI BINTI JUMRI 28 KU AIFAA TASNIM BINTI KU SAIDIN 29 NUR NAZUHA BINTI ZULKIFLI KUALA PERLIS 02000 PERLIS NO 100B, JALAN PADANG NYU, ARAU 02600 PERLIS NO.37A, PIDA 3,JALAN SANGLANG, KODIANG, KEDAH 06100 PERLIS K-19 PEKAN SIMPANG EMPAT, 02700 PERLIS NO. 10 JALAN 7 TAMAN SANTAN 2 02400 PERLIS 22, JALAN ROSLI TALIB, KAMPUNG KURUNG TENGAR 02000 PERLIS NO 278, JLN CENGAL, 2/8, TMN CENGAL INDAH, KULIM 09000 KEDAH NO. 26, LORONG 1, TAMAN SRI WANG FASA 1, 02600 ARAU, PERLIS 02600 PERLIS BATU 4, JALAN SIMPANG EMPAT 01000 PERLIS NO 17 LORONG 5, TAMAN ANGSANA BUKIT KETERI 02450 PERLIS Bt 1 1/4, JLN DATO KAYAMAN, BKT KETERI 02450 PERLIS NO 9, JALAN 10, TAMAN SANTAN II, KANGAR 01000 PERLIS KPG KENANGAN SIMPANG AMPAT, SIMPANG AMPAT, PERLIS 02700 PERLIS 6C, KG PADANG BESAR MUKIM KURUNG ANAI, ARAU 02600 PERLIS 88 JALAN CHIN ALI KUBANG GAJAH ARAU 02600 PERLIS 174, KAMPUNG BELAKANG KILANG, KUALA PERLIS, PERLIS. 02000 PERLIS KAMPUNG TANJUNG BULUH, MUKIM SERIAB, KANGAR, PERLIS 01000 TIADA MAKLUMAT P/S NO 89, JALAN SURAU, KAMPUNG ABI PADANG MACHANG, KANGAR 01000 PERLIS NO.32,LORONG HAJI OSMAN JALAN SANTAN, 0100 KANGAR,PERLIS 01000 PERLIS A-1-4 KUARTERS KTMB PADANG BESAR (U) JALAN KG.KOLAM 02100 PERLIS KEPALA TITI TOK PULAU PAUH SANGLANG 02700 SIMPANG EMPAT PERLIS 30 MUHAMMAD AMIR FIRDAUS B NORISHAM 31 MUHAMMAD NIZAM BIN IBRAHIM 32 NURDIYANA SYAHIRA BINTI AHMAD SHAFIR 33 KHAIRUL MUSFIRAH BINTI ABD KARIM 34 NOR SYAKILA BT ISMAIL 35 NURUL AMIRAH BINTI SAHIDI 36 FARRAH NUR ISWANIE BT.JASNI 37 NUR AIN HASSANAH BINTI KHAIRUNSAM 38 NOR ATIKAH BINTI MANSOR 02700 PERLIS NO 1, KG. SERIAB KANGAR 01000 PERLIS 39 NUR IZZATI BINTI ABD MALEK 6 40 ABDUL HAKEEM BIN ADAM LOT 535, KG DATO UTAN AJI, KANGAR 01000 PERLIS Table 3 a. Insert this row on the top NO NAME ADDRESS POSTCODE DISTRICT STATE b. Separate the data (address) according to the title on the first row above c. Find and Replace all the SHORT FORM into correct spelling (e.g: LRG = LORONG, BT = BATU, KG = KAMPUNG d. Filter all data by DISTRICT where "KANGAR". e Filter all data by STATE where "PERLIS" f. Sort all data by SECOND COLUMN into Ascending Order & Sort all data by NAME and ADDRESS to view in Row Labels. h. Sort all data by DISTRICT and STATE to view in Row Labels. i. Use align center for all the data. SELECT ALL DATA and create ONE (1) BAR GRAPH to display all statistic data