\begin{tabular}{|c|c|c|c|c|c|} \hline Onder ID & Product & Categery & Amount & Date & Country \\ \hline 1 & Carrots & Vegetables. & $4,270 & 1/6/16 & United Staier \\ \hline 2 & Broccoli & Yegetables: & $8,239 & 1/7/16 & United Kingdom \\ \hline 3 & Banana & Fruit & 5617 & 1/8/16 & United States \\ \hline 4 & Banana & Fruit & 58,384 & 1/10/16 & Canada \\ \hline 5 & Beans & Vegetables & $2,626 & 1/10/16 & Germany \\ \hline 6 & Orange & Fruit & $3,610 & 1/11/16 & United States \\ \hline? & Broccoli & Vegetables & $9,062 & 1711/16 & Australia \\ \hline 8 & Banana & Fruit & $6,906 & 1/16/16 & New Zealand \\ \hline 9 & Apple & Fruit & $2,417 & 1/16/16 & France \\ \hline 10 & Apple & Fruit & $7,431 & 1/16/16 & Canada \\ \hline 11 & Banana & Fruit & $8,250 & 1/16/16 & Germany \\ \hline 12 & Broccoli & Vegetables & $7,012 & 1/18/16 & United States \\ \hline 13 & Carrots & Vegetables & $1,903 & 1/20/6 & Germany \\ \hline 14 & Broccoli & Vegetables & $2,824 & 1/22/16 & Canada \\ \hline is & Apple & Fruit & 56,946 & 1/24/16 & France \\ \hline 16 & Banana & Fruit & 52,320 & 1/27/16 & United Kingdom \\ \hline 17 & Banana & Fruit & $2,116 & 1/28/16 & United States \\ \hline 18 & Banana & Fruit & $1,135 & 1/30/16 & United Kingdom \\ \hline 19 & Broccoli & Vegetables & $3,595 & 1/30/16 & United Kingdom \\ \hline 20 & Apple & Fruit & $1,161 & 2/2/16 & United States \\ \hline 21 & Orange & Fruit & $2,256 & 2/4/16 & France \\ \hline 22 & Banans & Fruit & $1,004 & 2/11/16 & New Zealand \\ \hline 23 & Banana & Fruit & $3,642 & 2/14/16 & Canada \\ \hline 24 & Banama & Fruit & 54,582 & 2/17/16 & United States \\ \hline 25 & Bcans & Vegetables & $3,559 & 2/17/16 & Uniled Kingdom \\ \hline 26 & Carrots & Vegetablex & $5,154 & 2/17/16 & Australia \\ \hline 27 & Mango & Fruit & $7,388 & 2/18/16 & France \\ \hline 28 & Beans & Vegetables & 57,163 & 2/18/16 & 5 United States \\ \hline 29 & Beans & Vegetables & $5,101 & 2/20/16 & Germany \\ \hline 30 & Apple & Fruit & $7,602 & 2/21/16 & France \\ \hline 31 & Mango & Fruit & $1,641 & 2/22/16 & United States \\ \hline 32 & Apple & Fruit & $8,892 & 2/23/16 & Australia \\ \hline 33 & Apple & Fruit & 52,060 & 2/29/16 & France \\ \hline 34 & Broccoli & Vegctables & $1,557 & 2/29/16 & Germany \\ \hline 35 & Apple & Fruit & $6,509 & 3/1/16 & France \\ \hline 36 & Apple & Fruit & 55,718 & 3/4/16 & Australia \\ \hline 37 & Apple & Fruit & 57,655 & 3/5/16 & United States \\ \hline 38 & Carrots & Vegetables & 59.116 & 3/5/16 & United Kingdom \\ \hline 39 & Banana & Fruit & $2,795 & 3/15/16 & Uaited States \\ \hline 40 & Banana & Fruit & $5,084 & 3/15/16 & United States \\ \hline 41 & Carrots & Vegetables & $8,941 & 3/15/16 & United Kingdom \\ \hline 42 & Broccoli & Vegetables & $5,341 & 3/16/16 & France \\ \hline 43 & Banana & Fruit & $135 & 3/19/6 & Canada \\ \hline 44 & Banana & Fruit: & $9,400 & 3/19/16 & Australia \\ \hline 45 & Beans & Vegctables: & 56,045 & 3/21/16 & Germany \\ \hline 46 & Apple & Fruit & 55,820 & 3/22/16 & New Zcaland \\ \hline 47 & Orange & Frait & 58,887 & 3/23/6 & Germiny \\ \hline 48 & Orango & Fruit & $6,982 & 3/24/16 & Unitad States \\ \hline \end{tabular} Download HW 1 and create the necessary Pivot Table to answer these questions: How many orders of Bananas were placed with a value between $6,000 and $6,999 ? How many total orders of Vegetables were placed with a value between $2,000 and $2,999 ? What percentage of broccoli orders had values between $7,500 and \$9,999? (Keep two decimal places) What is the total sales dollars of Oranges? (whole dollars)
