Entering and editing data in Google Sheets - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants you to create a simple product list with prices and quantities. They also want you to update the quantities when new stock arrives.

📊 Data: You have a list of products with their prices and current quantities in stock.

🎯 Deliverable: A Google Sheets spreadsheet with product names, prices, and quantities. You will enter the data and then update quantities as new stock arrives.

Sample Data

Product	Price	Quantity
Apples	1.20	50
Bananas	0.80	30
Oranges	1.00	20
Milk	2.50	10
Bread	1.50	15
Eggs	3.00	12

1

Step 1: Open Google Sheets and create a new blank spreadsheet.

Expected Result

A new blank spreadsheet is ready for data entry.

2

Step 2: Enter the column headers in the first row: Product in A1, Price in B1, Quantity in C1.

Expected Result

Cells A1, B1, and C1 show the headers 'Product', 'Price', and 'Quantity' respectively.

3

Step 3: Enter the product names in cells A2 to A7: Apples, Bananas, Oranges, Milk, Bread, Eggs.

Expected Result

Cells A2 to A7 contain the product names as listed.

4

Step 4: Enter the prices in cells B2 to B7 matching each product: 1.20, 0.80, 1.00, 2.50, 1.50, 3.00.

Expected Result

Cells B2 to B7 contain the correct prices for each product.

5

Step 5: Enter the quantities in cells C2 to C7 matching each product: 50, 30, 20, 10, 15, 12.

Expected Result

Cells C2 to C7 contain the correct quantities for each product.

6

Step 6: Format the Price column (B2:B7) as currency: Select B2:B7, then click Format > Number > Currency.

Expected Result

Prices in B2:B7 display with currency symbol and two decimal places.

7

Step 7: Update the quantity of Bananas when 20 more arrive: Click cell C3 and change the value from 30 to 50.

Expected Result

Cell C3 now shows 50, reflecting the new stock quantity.

8

Step 8: Update the quantity of Milk when 5 more arrive: Click cell C5 and change the value from 10 to 15.

Expected Result

Cell C5 now shows 15, reflecting the new stock quantity.

Final Result

Product   | Price  | Quantity
--------- | ------ | --------
Apples    | $1.20  | 50
Bananas   | $0.80  | 50
Oranges   | $1.00  | 20
Milk      | $2.50  | 15
Bread     | $1.50  | 15
Eggs      | $3.00  | 12

✓You successfully entered product names, prices, and quantities.

✓You formatted prices to show currency.

✓You updated quantities to reflect new stock arrivals.

Bonus Challenge

Add a new column 'Total Value' that multiplies Price by Quantity for each product.

Show Hint

In cell D1, enter 'Total Value'. In D2, enter the formula =B2*C2 and copy it down to D7.