Entering and editing data in Excel - Real Business Scenario

Scenario Mode

👤 Your Role: You are an office assistant at a small retail company.

📋 Request: Your manager wants you to create a simple product inventory list and update it with new stock information.

📊 Data: You have a list of products with their IDs, names, quantities in stock, and prices. You need to enter this data into Excel and then update the quantities when new stock arrives.

🎯 Deliverable: A completed Excel sheet with the product inventory data entered correctly and updated quantities reflecting new stock.

Sample Data

Product ID	Product Name	Quantity	Price ($)
101	Notebook	50	2.50
102	Pen	100	1.20
103	Stapler	30	5.00
104	Marker	75	1.80
105	Folder	40	3.00

1

Step 1: Open a new Excel workbook and create a table with headers: Product ID, Product Name, Quantity, Price ($).

Type headers in cells A1 to D1: "Product ID", "Product Name", "Quantity", "Price ($)".

Expected Result

Headers appear in the first row of the sheet.

2

Step 2: Enter the product data into the table starting from row 2.

Enter the following data: A2: 101, B2: Notebook, C2: 50, D2: 2.50 A3: 102, B3: Pen, C3: 100, D3: 1.20 A4: 103, B4: Stapler, C4: 30, D4: 5.00 A5: 104, B5: Marker, C5: 75, D5: 1.80 A6: 105, B6: Folder, C6: 40, D6: 3.00

Expected Result

All product data is entered correctly in rows 2 to 6.

3

Step 3: Update the quantity of 'Pen' to 120 because new stock arrived.

Click cell C3 and change the value from 100 to 120.

Expected Result

Quantity for Pen updates to 120.

4

Step 4: Add a new product 'Eraser' with Product ID 106, Quantity 60, and Price $0.80.

Enter in row 7: A7: 106, B7: Eraser, C7: 60, D7: 0.80

Expected Result

New product Eraser is added in row 7.

5

Step 5: Save the workbook with the name 'ProductInventory.xlsx'.

Use File > Save As and enter the file name.

Expected Result

Workbook saved with the correct name.

Final Result

Product ID | Product Name | Quantity | Price ($)
---------------------------------------------
101        | Notebook     | 50       | 2.50
102        | Pen          | 120      | 1.20
103        | Stapler      | 30       | 5.00
104        | Marker       | 75       | 1.80
105        | Folder       | 40       | 3.00
106        | Eraser       | 60       | 0.80

✓The quantity for Pen was updated to reflect new stock.

✓A new product Eraser was added to the inventory.

✓The inventory list is complete and saved for future use.

Bonus Challenge

Format the Quantity and Price columns to have center alignment and set the Price column to show two decimal places.

Show Hint

Select the Quantity and Price columns, use the alignment options to center text, and apply number formatting to Price with two decimals.