Selecting cells, rows, and columns in Excel - Real Business Scenario

Scenario Mode

👤 Your Role: You are an office assistant managing a sales report.

📋 Request: Your manager wants you to highlight and select specific parts of the sales data to prepare for a presentation.

📊 Data: You have a table with sales data including Date, Product, Region, Units Sold, and Revenue columns for 10 sales entries.

🎯 Deliverable: You need to demonstrate how to select single cells, entire rows, and entire columns in the sales data sheet.

Sample Data

Date	Product	Region	Units Sold	Revenue
2024-01-01	Pen	East	100	200
2024-01-02	Notebook	West	150	450
2024-01-03	Pen	North	200	400
2024-01-04	Marker	South	120	360
2024-01-05	Notebook	East	130	390
2024-01-06	Pen	West	170	340
2024-01-07	Marker	North	110	330
2024-01-08	Notebook	South	140	420
2024-01-09	Pen	East	160	320
2024-01-10	Marker	West	180	540

1

Step 1: Select a single cell to view details.

Click on cell C3 (Region for the second sale).

Expected Result

Cell C3 is highlighted showing 'West'.

2

Step 2: Select an entire row to see all details of one sale.

Click the row number 3 on the left side to select the entire 3rd row.

Expected Result

Row 3 is highlighted showing data: 2024-01-02, Notebook, West, 150, 450.

3

Step 3: Select an entire column to analyze one type of data.

Click the column letter D at the top to select the entire 'Units Sold' column.

Expected Result

Column D is highlighted showing all units sold values.

Final Result

Selected Cells and Ranges:

  |   A       |   B       |   C      |   D        |   E      |
--+-----------+-----------+----------+------------+----------+
1 | Date      | Product   | Region   | Units Sold | Revenue  |
2 | 2024-01-01| Pen       | East     | 100        | 200      |
3 | 2024-01-02| Notebook  | West  <==| 150        | 450      | <== Single cell selected
4 | 2024-01-03| Pen       | North    | 200        | 400      | <== Entire row selected
5 | 2024-01-04| Marker    | South    | 120        | 360      |
6 | 2024-01-05| Notebook  | East     | 130        | 390      |
7 | 2024-01-06| Pen       | West     | 170        | 340      |
8 | 2024-01-07| Marker    | North    | 110        | 330      |
9 | 2024-01-08| Notebook  | South    | 140        | 420      |
10| 2024-01-09| Pen       | East     | 160        | 320      |
11| 2024-01-10| Marker    | West     | 180  <== Entire column selected

✓You can select a single cell by clicking it to focus on one piece of data.

✓Selecting a whole row helps you see all details of one sale at once.

✓Selecting a whole column lets you analyze one type of data across all sales.

Bonus Challenge

Try selecting multiple cells that are not next to each other.

Show Hint

Hold down the Ctrl key (Cmd on Mac) and click each cell you want to select.