1.44 Tech Tool: Spreadsheet Software Software Video: Spreadsheet Graph and Data Organization 1. Download the data file for this exercise.

2. Graph the items on-hand quantity.

3. Identify items with on-hand quantity less than the re-order quantity.

4. Sort items based on their on-hand quantity.

Hint: To answer the third question, use the pivot table tool to select item name, quantity on hand, and reorder point. Use an IF statement to identify items that must be reordered.