Productivity & Collaboration Tools - Activity Week 4

 Spreadsheets are useful tools for sharing and analyzing data. The spreadsheet already shared with you contains a list of orders for office supplies, with information on the date of the sale, the salesperson, the region in which they operate, and details of the sale.

Open the spreadsheet. Make a new sheet within it with your name on it by clicking the ‘+’ button on the bottom left of the sheet. Rename this sheet with your name.

Use the spreadsheet and the data to answer the following questions in the sheet:

1. How much money was the largest order for?
2. What item was the largest order for?
3. Who sold the largest order?
4. Who sold the most altogether?
5. Which region sold the least altogether? 
6. What region is improving the most over time? 
7. What region is struggling to improve?
8. What is the average number of units sold in an order?
9. What is the average price of an order in the East region?
10. What is the standard deviation in order price?

Helpful functions, accessed by beginning a cell with an “=“ sign:

• AVERAGE
• MIN
• MAX
• STDEV
• QUERY

Example:

• =QUERY(A:G,"SELECT A,B,D,E,F,G WHERE C=‘Abdi’”,1)

                 returns all the sales of the sales rep named “Abdi”.

You can also nest functions. Example:

• =MAX(QUERY(A:G,”SELECT G WHERE C=‘Abdi’”,1))

                 Returns the largest sale from the sales rep named “Abdi”.