2.You have an Excel spreadsheet with a unique account numbers and addresses for 1,000 stores. You have a separate list with sales for each of those accounts. What functions would you use to combine these lists?

3.You've been given an Excel based sales report for multiple years, various products and several regions. The report has 100,000 lines of data. You've been asked to provide 3 summaries - one by year, one by product and one by region. What tool would you use to create this summary?

4.You are tasked to create a complete list of accounts serviced by your company. Youve been forwarded multiple lists, some having the same accounts. How would you insure that your compiled list has each store listed only once?

5.If a company distributes 16,000 copies of Vogue Magazine, issue #10, and sells 7,300 copies, what is the sell through?