Here is an exercise involving a Shopping List. This is the same exercise as the Shopping List Exercise for Word. It works much better using Excel.
- Open an Excel spreadsheet.
- Imagine that you are making a detailed shopping list for food items. Put the following columns in your worksheet.
- Food Item,
- Brief Description,
- Quanity,
- Estimated cost,
- Corresponding Meal (e.g. Breakfast, Lunch, Dinner) for the food item. (Consider that simple case that you will have the item for only one meal)
- Importance,
- Expected Store of Purchase
- Enter 5 food items into the table and make an entry in each column.
- Sort the items in alphabetic order by Item
Additional Questions: - What could be a suitable layout for a table to show which food items are eaten at several meals, and what are those meals.
- What could be a suitable layout for a table to keep track of how much you enjoyed each food item, so that you would buy it again.
- What could be a suitable layout for a table to document if you bought the item at a different store?
|
|