What is the one number divided by the other? How to find the best salesperson? What is the average sales client?

Name: Comm 310 Lab 1 Notes Week 1
Brand: StudySoup
SKU: 2695432
Price: 45.00 USD
Availability: InStock
Rating: 5 (1 reviews)

Excel: Sum- in cell below type “=sum” then put a parenthesis, highlighted all wanted cells and then close the parenthesis, press enter Average- = one number divided by the other, literally click number, put a “/” and click the second number. Finding best salesperson- highlight all headers → data → filter → little triangle for 2016 new clients → click descending, repeat for each column you need the answer to ** then you see the best person at the top aka highest number, and the worst (or lowest number) at the bottom Avg sales per client - made new cell column for average sales per client, found average by dividing new sales by new clients but just for the first row. Then bring mouse to bottom right corner of that cell after pres