https://www.linkedin.com/learning/managing-and-analyzing-data-in-excel-office-365-excel-2019/ (Links to an external site.)

1. (2 points) What are at least two benefits that you see for using tables within Excel?
2. (2 points) How can you sort Excel data by the background colors in a cell?
3. (2 points) How can you sort the columns in order from left to right?
4. (2 points) How can you randomize the order of the data in Excel?
5. (2 points) If I have three columns of data in Excel: Store, Product Name, and Quantity Sold, how can I have Excel automatically add in rows into my spreadsheet under each store name summing up the quantity of parts sold for each store? Hint: Use the subtotal feature.