Certainly! Below is an example of an Excel sheet based on vegetables with 20 items, each having random values for quantity, price per unit, and total cost. Additionally, I'll include various features and columns that learners can use to practice different Excel formulas.

Here's a sample structure:

Vegetables Inventory

Key Features for Practice:

1. Basic Formulas:

   • Total Cost: =C2*D2 (for all rows)
   • Final Cost: =E2-(E2*F2/100) (for all rows)

2. Conditional Formatting:

   • Highlight cells in the Quantity column that are below 30.
   • Color-code Final Cost based on high (> $50), medium ($20-$50), and low (< $20) values.

3. Data Validation:

   • Restrict entries in the Discount (%) column to be between 0 and 20.
   • Create a dropdown list for the Category column with predefined categories (e.g., Root, Leafy, Fruit, Bulb, Gourd, etc.).

4. VLOOKUP/HLOOKUP:

   • Add a separate table listing Category and Category Description. Use VLOOKUP to fill in the Category Description for each item in the main table.

5. SUMIF/SUMIFS:

   • Calculate the total Final Cost for each category using SUMIF.

6. Pivot Tables:

   • Create a Pivot Table to summarize total Quantity, Total Cost, and Final Cost by Category.

7. Charts:

   • Create a bar chart to visualize the total Quantity of each vegetable.
   • Create a pie chart to show the distribution of Total Cost by Category.

8. Sorting and Filtering:

   • Sort the table by Final Cost in descending order.
   • Apply filters to show only vegetables with a Quantity greater than 50.