Consider the following scenario: You are an assistant to the accounting manager for a small company that sells sports equipment online. The manager needs an analysis of sales by product to be presented at Fridays managers meeting and asks you to gather and summarize the data.

How can you use Excel to complete this assignment? What information do you need to produce an accurate, useful analysis? What questions might you ask the accounting manager before starting on the assignment?