PLEASE ANSWER ALL QUESTIONS IN EXCEL. PLEASE HAVE THE ANSWER IN AN EXCEL TABLE SHOWING THE COMPUTATION. THE DATA ABOVE IS ALL THAT WAS PROVIDED FOR THE QUESTIONS. THANK YOU FOR YOUR TIME! :)

P1911 fx D E F G - J K L M N O P R 1 Dollars Y Locatio- 94 $283.88 east 95 $ 286.68 midwest 95 $287.80 midwest 95 $ 286.76 midwest 95 $287.15 west 2 3 Name Date - Product - Units 314 Jen 5/15/2004 eye liner 722 Hallagan 6/13/2006 lip gloss 797 Hallagan 8/18/2006 foundation 1259 Hallagan 4/8/2006 lip gloss 1619 Hallagan 7/29/2005 eye liner 1895 1896 1897 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 4. Find all the transactions involving sales of at least 60 units during 2004 for which the per-unit price was a maximum of $3.10 5. Find all the foundation transactions during the first three months of 2004 for which the per-unit price was larger than the average price received for foundation during the entire time period. 8. Find all of the top-30 sales (by units) occurring in 2005 that involved lip gloss or mascara. P1911 fx D E F G - J K L M N O P R 1 Dollars Y Locatio- 94 $283.88 east 95 $ 286.68 midwest 95 $287.80 midwest 95 $ 286.76 midwest 95 $287.15 west 2 3 Name Date - Product - Units 314 Jen 5/15/2004 eye liner 722 Hallagan 6/13/2006 lip gloss 797 Hallagan 8/18/2006 foundation 1259 Hallagan 4/8/2006 lip gloss 1619 Hallagan 7/29/2005 eye liner 1895 1896 1897 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 4. Find all the transactions involving sales of at least 60 units during 2004 for which the per-unit price was a maximum of $3.10 5. Find all the foundation transactions during the first three months of 2004 for which the per-unit price was larger than the average price received for foundation during the entire time period. 8. Find all of the top-30 sales (by units) occurring in 2005 that involved lip gloss or mascara