Website Home Page |

Excel Assignments List

| Froyo Technologies Public Resources

| Product ID | Product Name  | Category   | Price | Quantity |

|------------|---------------|------------|-------|----------|

| 1          | Laptop        | Electronics| 1000  | 5        |

| 2          | T-shirt       | Clothing   | 20    | 10       |

| 3          | Smartphone    | Electronics| 500   | 8        |

| 4          | Headphones    | Electronics| 200   | 15       |

| 5          | Jeans         | Clothing   | 50    | 12       |

| 6          | Tablet        | Electronics| 700   | 6        |

| 7          | Dress Shirt   | Clothing   | 30    | 20       |

| 8          | Camera        | Electronics| 1200  | 3        |

| 9          | Sneakers      | Clothing   | 80    | 7        |

| 10         | Smart Watch   | Electronics| 300   | 10       |

 
Task :

1. Create a table to manage product inventory with columns for Product ID, Product Name, Category, Price, and Quantity.
2. Calculate the total value of each product (Price * Quantity).
3. Use data validation to create a drop-down list for selecting categories.
4. Apply conditional formatting to highlight products with a price above $500.
5. Insert a column chart to visualize the quantity of each product

To perform the tasks outlined in Assignment using Excel, follow these step-by-step instructions:

Steps to Perform:

1.      Create a Table:

• Enter the sample data into Excel starting from cell A1.
• Select the data range.
• Go to Insert tab > Table to convert the range into a table.

2.      Calculate Total Value of Each Product:

• In cell F2 (next to "Quantity" column header), enter the formula =C2*D2 to calculate the total value of the first product.
• Use the fill handle to copy the formula down to calculate for all products.

3.      Data Validation for Categories:

• Select the cells in the "Category" column (C2 for the provided data).
• Go to Data tab > Data Validation.
• Choose List under Allow, and in the Source box, enter Electronics, Clothing to create a dropdown list with these categories.

4.      Conditional Formatting for Prices Above $500:

• Select the range of prices (D2).
• Go to Home tab > Conditional Formatting > Highlight Cells Rules > Greater Than....
• Enter 500 and choose a formatting style (e.g., light red fill).

5.      Insert Column Chart:

• Select the range of data including headers (A1).
• Go to Insert tab > Charts group > Choose Column Chart > Select a suitable style.