Problems


  1. Find all transactions in which Hallagan sold eye liner in the West region.

  2. Find all transactions that rank in the top five percent with regards to units sold.

  3. Find the top 20 revenue-generating transactions that involve foundation sales.

  4. Find all 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 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.

  6. Find all transactions in which Zaret or Betsy sold either lipstick or foundation.

  7. Find all unique combinations of product and salesperson’s name.

  8. Find all of the top 30 sales (by units) occurring in 2005 which involved lip gloss or mascara.

  9. Find all sales by Jen between August 10 and September 15, 2005.

  10. Find all sales of lipstick sold by Colleen where the number of units sold is higher than the average number of units in a lipstick transaction.

  11. Find all unique combinations of name, product, and location occurring during the first three months of 2006.

  12. Find all records in which the product cell is colored in yellow.




Microsoft Press - Microsoft Office Excel 2007. Data Analysis and Business Modeling
MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)
ISBN: 0735623961
EAN: 2147483647
Year: 2007
Pages: 200

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net