Question:
Understanding Excel - Identifying Variables
Details: Your Aunt Sally has entered all of her stuffed animal data into an Excel workbook. She took your advice and used headings to organize the information. She now wants to have the information sorted in the fields Name, Date Purchased, Purchase Price, Color, Size, and Location for each of her stuffed animals. In addition, her husband, your Uncle Bob, wants to know how much money she has invested in this hobby, and her daughter wants to know the date she started this collection.
Sally would also like to be able to quickly identify what stuffed animals were bought before the year 2000. Advise her regarding how she can accomplish these tasks.