Roll No = 164972 Name: Abdullah

Draw Pivot table and pivot chart on the following yearly data of Fruits data in $: Fruits Countries Exports Apple Pakistan 20000 Banana Iran 35000 Cherries India 60111 Melon Nigeria 46875 Orange China 98653 Grapes Libya 98564 Mango Spain 23654 Strawberries Turkey 12568 Pomegranates Ireland 12564 Pineapple Canada 75623 Raspberry USA 69875 Papaya Norway Roll No* Apricot Greece 75888 Fig Cuba 69336 Imports Local Sales Wastage Dealers 236 2564 25 Ali 786 3657 36 Kashif Your 256 Roll No* 34 Name** 988 659 78 Harris 444 365 56 Nouman 236 2564 52 Khalid Roll No* 3697 36 Saad 897 2365 98 Ramzan 368 4856 96 Sadia 499 85 Alia 655 3654 57 Naila 222 2222 22 Sobia 367 1555 16 Kashif 775 2698 0 Akbar Contact 000234 000697 000455 000666 000324 000365 456000 000879 000654 000321 000987 000555 000669 000696 9875 That also shows Cherries status in the Pivot table. (Marks-10)