如何在表格中添加各种办公家具的品牌名称和价格?
Table Structure:
| Item Name | Brand Name | Price | |---|---|---| | Desk | IKEA | 100 | | Chair | Herman Miller | 200 | | Printer | Canon | 300 | | Monitor | Dell | 400 |
Instructions:
- Create a new column named "Brand Name".
- Enter the brand names of the office furniture in the "Brand Name" column.
- Enter the prices of the office furniture in the "Price" column.
- You can use a combination of cell references, formulas, and conditional formatting to create a visually appealing and informative table.
Tips:
- Use descriptive brand names that are relevant to the furniture.
- Use consistent formatting for easy readability.
- Add a header row to the table for clarity.
- Consider using a data validation list to ensure that the prices are valid numbers.
Example:
| Item Name | Brand Name | Price |
|---|---|---|
| Desk | IKEA | 100 |
| Chair | Herman Miller | 200 |
| Printer | Canon | 300 |
| Monitor | Dell | 400 |