Create formulas to answer the questions below.

Questions: 1. Calculate the number of vendors that sell Kiwis. Create your formula

2. Calculate Total Sales dollars, excluding the two highest and two lowest amounts. Create your formula

3. Calculate total Cases Sold (all types of fruit) by vendors with "Fruit" included in their name. Create your formula

4. Calculate Total Sales dollars for Atlanta and Macon combined. Create your formula

5. Calculate the total Cases Sold of Apples by the North GA region. Create your formula in cell M7.

Answer 4th. & 5th most importantly.

A B E F G H J Item ID 100 200 300 400 500 100 200 300 400 500 100 1 ReglD Region CityID City 2 0010 North GA 0100 Atlanta 3 0010 North GA 0100 Atlanta 4 0010 North GA 0100 Atlanta 5 0010 North GA 0100 Atlanta 6 0010 North GA 0100 Atlanta 7 0010 North GA 0100 Atlanta 8 0010 North GA 0100 Atlanta 9 0010 North GA 0100 Atlanta 10 0010 North GA 0100 Atlanta 11 0010 North GA 0100 Atlanta 12 0010 North GA 0100 Atlanta 13 0010 North GA 0100 Atlanta 14 0010 North GA 0100 Atlanta 15 0010 North GA 0100 Atlanta 16 0010 North GA 0100 Atlanta 17 0010 North GA 0100 Atlanta 18 0010 North GA 0100 Atlanta 19 0010 North GA 0100 Atlanta 20 0010 North GA 0100 Atlanta 21 0010 North GA 0100 Atlanta 22 0010 North GA 0200 Blue Ridge 23 0010 North GA 200 Blue Ridge 24 0010 North GA 0200 Blue Ridge 25 0010 North GA 0200 Blue Ridge 26 0010 North GA 0200 27 0010 North GA 300 Clarkesville 28 0010 North GA 0300 Clarkesville 29 0010 North GA 0300 Clarkesville VendorID 00100 00100 00100 00100 00100 00200 00200 00200 00200 00200 00300 00300 00300 00300 00300 00400 100400 00400 00400 00400 00500 00500 00500 00500 00500 00600 00600 00600 roncon Vendor Fruit R Us Fruit R Us Fruit R Us Fruit R Us Fruit R Us Bob's Fruit Bob's Fruit Bob's Fruit Bob's Fruit Bob's Fruit Fruitju Fruitju Fruitju Fruitju Fruitju Orange U Glad Orange U Glad Orange U Glad Orange U Glad Orange U Glad Mountain Fruit Mountain Fruit Mountain Fruit Mountain Fruit Mountain Fruit Fruit Direct Fruit Direct Fruit Direct 1200 300 400 500 100 200 300 400 500 100 200 300 400 Product Oranges Apples Kiwis Bananas Mixed Berries Oranges Apples Kiwis Bananas Mixed Berries Oranges Apples Kiwis Bananas Mixed Berries Oranges Apples Kiwis Bananas Mixed Berries Oranges Apples Kiwis Bananas Mixed Berries Oranges Apples Kiwis Cases Sold Total Sales 6168 $61,680 6079 $85,106 6058 $66,638 6868 $75,548 1996 $29,940 7818 $93,816 1565 $21,910 9967 $99,670 9842 $98,420 8993 $89,930 4933 $54,263 7704 $1,07,856 5519 $71,747 8442 $1,26,630 889 $11,557 6551 $72,061 2605 $31,260 3317 $43,121 7411 $81,521 6227 $93,405 6415 $89,810 6426 $83,538 8035 $1,12,490 5075 $60,900 3064 $36,768 686 $9,604 8203 $82,030 3920 $58,800 Blue Ridge 1500 100 200 300 00 aan rann nca 07AAC A B E F G H J Item ID 100 200 300 400 500 100 200 300 400 500 100 1 ReglD Region CityID City 2 0010 North GA 0100 Atlanta 3 0010 North GA 0100 Atlanta 4 0010 North GA 0100 Atlanta 5 0010 North GA 0100 Atlanta 6 0010 North GA 0100 Atlanta 7 0010 North GA 0100 Atlanta 8 0010 North GA 0100 Atlanta 9 0010 North GA 0100 Atlanta 10 0010 North GA 0100 Atlanta 11 0010 North GA 0100 Atlanta 12 0010 North GA 0100 Atlanta 13 0010 North GA 0100 Atlanta 14 0010 North GA 0100 Atlanta 15 0010 North GA 0100 Atlanta 16 0010 North GA 0100 Atlanta 17 0010 North GA 0100 Atlanta 18 0010 North GA 0100 Atlanta 19 0010 North GA 0100 Atlanta 20 0010 North GA 0100 Atlanta 21 0010 North GA 0100 Atlanta 22 0010 North GA 0200 Blue Ridge 23 0010 North GA 200 Blue Ridge 24 0010 North GA 0200 Blue Ridge 25 0010 North GA 0200 Blue Ridge 26 0010 North GA 0200 27 0010 North GA 300 Clarkesville 28 0010 North GA 0300 Clarkesville 29 0010 North GA 0300 Clarkesville VendorID 00100 00100 00100 00100 00100 00200 00200 00200 00200 00200 00300 00300 00300 00300 00300 00400 100400 00400 00400 00400 00500 00500 00500 00500 00500 00600 00600 00600 roncon Vendor Fruit R Us Fruit R Us Fruit R Us Fruit R Us Fruit R Us Bob's Fruit Bob's Fruit Bob's Fruit Bob's Fruit Bob's Fruit Fruitju Fruitju Fruitju Fruitju Fruitju Orange U Glad Orange U Glad Orange U Glad Orange U Glad Orange U Glad Mountain Fruit Mountain Fruit Mountain Fruit Mountain Fruit Mountain Fruit Fruit Direct Fruit Direct Fruit Direct 1200 300 400 500 100 200 300 400 500 100 200 300 400 Product Oranges Apples Kiwis Bananas Mixed Berries Oranges Apples Kiwis Bananas Mixed Berries Oranges Apples Kiwis Bananas Mixed Berries Oranges Apples Kiwis Bananas Mixed Berries Oranges Apples Kiwis Bananas Mixed Berries Oranges Apples Kiwis Cases Sold Total Sales 6168 $61,680 6079 $85,106 6058 $66,638 6868 $75,548 1996 $29,940 7818 $93,816 1565 $21,910 9967 $99,670 9842 $98,420 8993 $89,930 4933 $54,263 7704 $1,07,856 5519 $71,747 8442 $1,26,630 889 $11,557 6551 $72,061 2605 $31,260 3317 $43,121 7411 $81,521 6227 $93,405 6415 $89,810 6426 $83,538 8035 $1,12,490 5075 $60,900 3064 $36,768 686 $9,604 8203 $82,030 3920 $58,800 Blue Ridge 1500 100 200 300 00 aan rann nca 07AAC