Function Sumif, Sumifs, Averageif, Averageifs Functions 1. For each product, determine the total number of units and dollar volume sold. 2. Determine the total revenue earned before December 10, 2005. 3. Determine the total units sold by salespeople whose last names begin with C. 4. Determine the total revenue earned by people who have five letters in their names. 5. How many units were sold by people other than Colleen? 6. How many units of makeup were sold from January 15, 2004, through February 15, 2005? 7. The file NBA.xlsx contains the following information: Columns A and B list the name of each NBA team and a code number for each team. For example, team 1 is Atlanta, and so on. Column Clists the home team for each game. Column D lists the visiting team for each game. Column E lists points scored by the home team. Column F lists points scored by the visiting team. From this data, compute for each team the average number of points the team scored per game and the average number of points the team gave up. 8. The file Toysrus.xlsx contains sales revenue (in millions of dollars) during each quarter for the years 1997-2001 and the first two quarters of 2002. Use this data to compute a seasonal index for each quarter of the year. For example, if average sales during the first quarter were 80 percent of the overall average sales per quarter, the first quarter would have a seasonal index of 0.8. 9. How much revenue was made on sales transactions involving at least 50 units of makeup? 10. The file Sumifrows.xlsx contains sales data during several winter, spring, summer, and fall quarters. Determine average sales during the winter, spring, summer, and fall quarters. 11. How many units of lip gloss did Cici sell in 20047 12. What was the average number of units of foundation sold by Emilee? 13. What was the average dollar size of a foundation sale made by Betsy after the end of 2004? 14. In transactions in which Ashley sold at least 40 units of lipstick, what was the total dollar amount? 15. Create a table that contains sales of each product made by each person. 16. Create a table that, when you enter a year in your worksheet, contains sales of each prod- uct by person during that year. File Home Insert Page Layout Formulas Data Review View Help Matchthesecond [Protected View] - Excel Tell me what you want to do Enable Editing PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Sign in E3 fx dan A B C D E F G H J K L M N P R S 1 2 3 4 5 6 7 dan dave erica dan greg 8 9 10 11 12 max greg christian ryan erica 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 File Home Insert Page Layout Formulas Data Review View Help Matchthesecond [Protected View] - Excel Tell me what you want to do Enable Editing PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Sign in E3 fx dan A B C D E F G H J K L M N P R S 1 2 3 4 5 6 7 dan dave erica dan greg 8 9 10 11 12 max greg christian ryan erica 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 File Home Insert Page Layout Formulas Data Review View Help Matchthesecond [Protected View] - Excel Tell me what you want to do Enable Editing PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Sign in E3 fx dan A B C D E F G H J K L M N P R S 1 2 3 4 5 6 7 dan dave erica dan greg 8 9 10 11 12 max greg christian ryan erica 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 File Home Insert Page Layout Formulas Data Review View Help Matchthesecond [Protected View] - Excel Tell me what you want to do Enable Editing PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Sign in E3 fx dan A B C D E F G H J K L M N P R S 1 2 3 4 5 6 7 dan dave erica dan greg 8 9 10 11 12 max greg christian ryan erica 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 File Home Insert Page Layout Formulas Data Review View Help Matchthesecond [Protected View] - Excel Tell me what you want to do Enable Editing PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Sign in E3 fx dan A B C D E F G H J K L M N P R S 1 2 3 4 5 6 7 dan dave erica dan greg 8 9 10 11 12 max greg christian ryan erica 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 File Home Insert Page Layout Formulas Data Review View Help Matchthesecond [Protected View] - Excel Tell me what you want to do Enable Editing PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Sign in E3 fx dan A B C D E F G H J K L M N P R S 1 2 3 4 5 6 7 dan dave erica dan greg 8 9 10 11 12 max greg christian ryan erica 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 File Home Insert Page Layout Formulas Data Review View Help Matchthesecond [Protected View] - Excel Tell me what you want to do Enable Editing PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Sign in E3 fx dan A B C D E F G H J K L M N P R S 1 2 3 4 5 6 7 dan dave erica dan greg 8 9 10 11 12 max greg christian ryan erica 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 File Home Insert Page Layout Formulas Data Review View Help Matchthesecond [Protected View] - Excel Tell me what you want to do Enable Editing PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Sign in E3 fx dan A B C D E F G H J K L M N P R S 1 2 3 4 5 6 7 dan dave erica dan greg 8 9 10 11 12 max greg christian ryan erica 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 File Home Insert Page Layout Formulas Data Review View Help Matchthesecond [Protected View] - Excel Tell me what you want to do Enable Editing PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Sign in E3 fx dan A B C D E F G H J K L M N P R S 1 2 3 4 5 6 7 dan dave erica dan greg 8 9 10 11 12 max greg christian ryan erica 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28