- Create a new Excel workbook.
- Add data to a table.
Spreadsheets are a powerful tool for organizing data. Consider a company that needs to track the technology purchased.
- Create an excel spreadsheet and enter the data from the table.
| Date | Product | Price | Qty | Total |
|---|---|---|---|---|
| 12/20/2020 | Headphones | $48.00 | 57 | $2,736.00 |
| 12/28/2020 | Headphones | $48.00 | 74 | $3,552.00 |
| 1/3/2021 | LED 65 | $780.00 | 13 | $10,140.00 |
| 1/3/2021 | Headphones | $48.00 | 9 | $432.00 |
| 1/5/2021 | Headphones | $48.00 | 10 | $480.00 |
| 1/7/2021 | OLED 45 | $48.00 | 77 | $30,800.00 |
| 1/8/2021 | LED 65 | $780.00 | 14 | $10,920.00 |
| 1/8/2021 | Headphones | $48.00 | 16 | $768.00 |
| 1/11/2021 | LCD 42 | $380.00 | 48 | $18,240.00 |
| 1/13/2021 | Plasma 65 | $855.00 | 12 | $10,260.00 |
| 1/13/2021 | Headphones | $48.00 | 85 | $4,080.00 |
| 1/15/2021 | Headphones | $48.00 | 158 | $7,584.00 |
| 1/17/2021 | LCD 42 | $380.00 | 55 | $20,900.00 |
| 1/17/2021 | Headphones | $48.00 | 115 | $5,520.00 |
| 1/21/2021 | Plasma 65 | $855.00 | 11 | $9,405.00 |
| 1/22/2021 | Headphones | $48.00 | 15 | $720.00 |
| 1/25/2021 | LCD 42 | $380.00 | 54 | $20,520.00 |
| 1/27/2021 | QLED 55 | $620.00 | 10 | $6,200.00 |
| 1/30/2021 | LED 55 | $550.00 | 10 | $5,500.00 |
| 2/4/2021 | LCD 32 | $170.00 | 43 | $7,310.00 |
| 2/7/2021 | QLED 55 | $620.00 | 15 | $9,300.00 |
| 2/9/2021 | OLED 45 | $400.00 | 37 | $14,800.00 |
| 2/11/2021 | Plasma 65 | $855.00 | 34 | $29,070.00 |
| 2/15/2021 | DLP 32 | $250.00 | 97 | $24,250.00 |
| 2/18/2021 | LED 65 | $780.00 | 54 | $42,120.00 |
| 2/21/2021 | LED 55 | $550.00 | 21 | $11,550.00 |
| 2/25/2021 | LCD 42 | $380.00 | 54 | $20,520.00 |
| 2/27/2021 | LCD 32 | $170.00 | 14 | $2,380.00 |
2. Modify the column widths so that the data is clearly visible.
3. Save this spreadsheet as LastName_Inventory.xls so we can modify it as we learn new things about Excel.