Question:
Your Uncle Larry has entered all of his video game collection data into an Excel workbook. He took your advice and used headings to organize the information. He now wants to have the information sorted in the fields Name, Date Purchased, Purchase Price, Color, Size, and Location for each of his video games. In addition, his wife, your Aunt Mary, wants to know how much money he has invested in this hobby, and his son wants to know the date he started this collection. Larry would also like to quickly be able to identify which video games were bought before the year 2000. Advise him regarding how he can accomplish these tasks.