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.

Practice

1. What happens when you press the Enter key after typing data in a Google Sheets cell?

easy

A. The data is deleted and the cell remains selected.

B. The data is saved but the selection does not move.

C. The data is saved and the selection moves to the cell on the right.

D. The data is saved and the selection moves to the cell below.

Solution

1. Step 1: Understand the Enter key behavior

   Pressing Enter saves the typed data in the current cell.

2. Step 2: Observe the cursor movement after Enter

   After saving, the selection moves down to the cell below.

3. Final Answer:

   The data is saved and the selection moves to the cell below. -> Option D

4. Quick Check:

   Enter key saves and moves down = B [OK]

Hint: Enter saves data and moves down one cell [OK]

Common Mistakes:

• Thinking Enter moves right instead of down
• Assuming data is deleted on Enter
• Believing selection stays on the same cell

2. Which of the following is the correct way to start editing a cell's content in Google Sheets?

easy

A. Click the cell once and press Enter key.

B. Press the Delete key while the cell is selected.

C. Double-click the cell or press F2 key.

D. Right-click the cell and select 'Copy'.

Solution

1. Step 1: Identify how to enter edit mode

   Double-clicking a cell or pressing F2 lets you edit its content.

2. Step 2: Check other options

   Delete clears content, Enter saves data, and Copy duplicates data, none start editing.

3. Final Answer:

   Double-click the cell or press F2 key. -> Option C

4. Quick Check:

   Edit mode starts with double-click or F2 = A [OK]

Hint: Double-click or press F2 to edit a cell [OK]

Common Mistakes:

• Pressing Enter to start editing instead of saving
• Using Delete to edit instead of clear
• Confusing Copy with editing

3. If cell A1 contains the text "Hello" and you type "World" in cell A2 and press Tab, what will happen?

medium

A. The text "World" is saved in A2 and the selection moves to cell B2.

B. The text "World" is saved in A2 and the selection moves to cell A3.

C. The text "World" is deleted and the selection stays on A2.

D. The text "World" is saved in A1 and the selection moves to B1.

Solution

1. Step 1: Understand Tab key behavior after typing

   Pressing Tab saves the data and moves the selection right to the next cell in the same row.

2. Step 2: Apply to given cells

   Typing "World" in A2 and pressing Tab saves it in A2 and moves selection to B2.

3. Final Answer:

   The text "World" is saved in A2 and the selection moves to cell B2. -> Option A

4. Quick Check:

   Tab saves and moves right = C [OK]

Hint: Tab saves data and moves right one cell [OK]

Common Mistakes:

• Thinking Tab moves down instead of right
• Assuming data is deleted on Tab
• Confusing cell references for data entry

4. You typed "123" in cell B1 but want to change it to "456". Which step will NOT correctly edit the cell content?

medium

A. Select cell B1, press Tab, then type "456".

B. Select cell B1, type "456", then press Enter.

C. Select cell B1, press Delete, then type "456" and press Enter.

D. Double-click cell B1, change to "456", then press Enter.

Solution

1. Step 1: Review each editing method

   Options B, C, and D correctly allow editing and saving new data.

2. Step 2: Analyze Select cell B1, press Tab, then type "456".

   Pressing Tab moves selection without editing; typing after Tab edits new cell, not B1.

3. Final Answer:

   Select cell B1, press Tab, then type "456". -> Option A

4. Quick Check:

   Tab moves away, so editing original cell fails = A [OK]

Hint: Tab moves away; use Enter or double-click to edit [OK]

Common Mistakes:

• Pressing Tab to edit instead of move
• Not double-clicking to enter edit mode
• Assuming Delete alone edits content

5. You have a list of names in column A. You want to quickly replace all names with uppercase versions by editing each cell. Which method is the fastest and most efficient?

hard

A. Double-click each cell, retype the name in uppercase, then press Enter.

B. Use the formula =UPPER(A1) in a new column and copy down.

C. Press Delete on each cell, then type uppercase names manually.

D. Select all cells, type uppercase names, then press Enter once.

Solution

1. Step 1: Consider manual editing speed

   Options A and C require editing each cell manually, which is slow.

2. Step 2: Evaluate bulk editing options

   Select all cells, type uppercase names, then press Enter once. is invalid because typing in multiple selected cells overwrites all with same text.

3. Step 3: Use formula for automation

   Use the formula =UPPER(A1) in a new column and copy down. uses =UPPER(A1) formula to convert text to uppercase automatically and can be copied down quickly.

4. Final Answer:

   Use the formula =UPPER(A1) in a new column and copy down. -> Option B

5. Quick Check:

   Formula automates uppercase conversion = D [OK]

Hint: Use =UPPER() formula to convert text quickly [OK]

Common Mistakes:

• Trying to type uppercase manually for many cells
• Typing in multiple selected cells at once
• Deleting cells instead of editing