Joolas is a small makeup company. In a Microsoft Office Excel 2007 worksheet, they track each sales transaction. Often, they want to answer questions such as:
How many dollars worth of lip gloss did Jen sell?
What was the average number of lipstick units sold each time Jen made a sale in the East region?
What was the total dollar amount of all makeup sold by Emilee or in the East region?
How many dollars worth of lipstick were sold by Colleen or Zaret in the East region?
How many lipstick transactions were not in the East region?
How many dollars worth of lipstick did Jen sell during 2004?
How many units of makeup were sold for a price of at least $3.20?
What is the total dollar amount each ...