Workbook, worksheet, and cell structure in Excel - Real Business Scenario

Scenario Mode

👤 Your Role: You are a junior data analyst at a retail company.

📋 Request: Your manager wants you to organize sales data by product categories in different worksheets and explain how the workbook and cells are structured.

📊 Data: You have sales data for three product categories: Electronics, Clothing, and Home Goods. Each category has sales amounts for January and February.

🎯 Deliverable: Create a workbook with three worksheets named Electronics, Clothing, and Home Goods. Enter the sales data in each worksheet starting from cell A1. Then explain how the workbook, worksheets, and cells are organized.

Sample Data

Product	January Sales	February Sales
Electronics	1200	1350
Clothing	800	950
Home Goods	600	700

1

Step 1: Open a new Excel workbook.

No formula needed.

Expected Result

A new blank workbook opens with default worksheet names like Sheet1.

2

Step 2: Rename the first worksheet to 'Electronics'.

Right-click the sheet tab and select 'Rename', then type 'Electronics'.

Expected Result

The first worksheet tab is named 'Electronics'.

3

Step 3: Create two more worksheets and rename them to 'Clothing' and 'Home Goods'.

Click the '+' icon to add sheets, then rename each by right-clicking the tab.

Expected Result

The workbook now has three worksheets named Electronics, Clothing, and Home Goods.

4

Step 4: In the 'Electronics' worksheet, enter the headers 'Product', 'January Sales', and 'February Sales' in cells A1, B1, and C1.

Type directly into cells: A1='Product', B1='January Sales', C1='February Sales'.

Expected Result

Headers appear in the first row of the Electronics worksheet.

5

Step 5: Enter the sales data for Electronics starting in row 2: A2='Electronics', B2=1200, C2=1350.

Type directly into cells.

Expected Result

Sales data for Electronics is entered correctly.

6

Step 6: Repeat steps 4 and 5 for the 'Clothing' worksheet with data: A2='Clothing', B2=800, C2=950.

Type headers and data in the Clothing worksheet.

Expected Result

Clothing worksheet has headers and sales data entered.

7

Step 7: Repeat steps 4 and 5 for the 'Home Goods' worksheet with data: A2='Home Goods', B2=600, C2=700.

Type headers and data in the Home Goods worksheet.

Expected Result

Home Goods worksheet has headers and sales data entered.

8

Step 8: Explain the workbook structure: The workbook is the entire Excel file containing multiple worksheets.

No formula needed.

Expected Result

Learner understands that the workbook holds all worksheets.

9

Step 9: Explain the worksheet structure: Each worksheet is a tab with a grid of cells organized by columns (A, B, C...) and rows (1, 2, 3...).

No formula needed.

Expected Result

Learner understands worksheets are separate pages with cells arranged in rows and columns.

10

Step 10: Explain the cell structure: Each cell is identified by its column letter and row number, like A1 or B2, and can hold data or formulas.

No formula needed.

Expected Result

Learner understands how to locate and reference cells.

Final Result

Workbook: Retail Sales.xlsx

[Electronics] [Clothing] [Home Goods]

Electronics Worksheet:
A1: Product       B1: January Sales    C1: February Sales
A2: Electronics   B2: 1200             C2: 1350

Clothing Worksheet:
A1: Product       B1: January Sales    C1: February Sales
A2: Clothing      B2: 800              C2: 950

Home Goods Worksheet:
A1: Product       B1: January Sales    C1: February Sales
A2: Home Goods    B2: 600              C2: 700

Bonus Challenge

Add a new worksheet named 'Summary' that calculates total sales for each category by summing January and February sales.

Show Hint

Use formulas like =B2+C2 in the Summary worksheet to add sales from each category.