Workbook, worksheet, and cell structure in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a workbook in Excel?

A workbook is the entire Excel file that contains one or more worksheets. Think of it like a book that holds many pages.

beginner

What is a worksheet in Excel?

A worksheet is a single page inside a workbook. It has rows and columns where you enter and organize your data.

beginner

How do you identify a cell in Excel?

A cell is identified by its column letter and row number, like A1 or B5. The column is the letter on top, and the row is the number on the side.

beginner

What is the intersection of a row and a column called?

The intersection of a row and a column is called a cell. It is where you enter data or formulas.

beginner

How can you switch between worksheets in a workbook?

You can switch worksheets by clicking the sheet tabs at the bottom of the Excel window. Each tab has the worksheet's name.

What does a workbook contain?

A Multiple worksheets

B Only one worksheet

C Only cells

D Only formulas

A workbook contains multiple worksheets, like pages in a book.

How is a cell identified in Excel?

A By row number only

B By column letter and row number

C By column letter only

D By worksheet name

A cell is identified by its column letter and row number, for example, B3.

Where do you find the worksheet tabs in Excel?

A At the bottom of the window

B At the top of the window

C On the right side

D In the ribbon menu

Worksheet tabs are located at the bottom of the Excel window.

What is the main purpose of a worksheet?

A To create charts only

B To save the Excel file

C To format the workbook

D To store data in rows and columns

A worksheet stores data organized in rows and columns.

Which of these is NOT part of Excel's cell structure?

A Column letter

B Row number

C Worksheet tab

D Cell address

Worksheet tab is not part of a cell's address; it identifies the sheet.

Explain the relationship between a workbook, worksheet, and cell in Excel.

Think of a workbook as a book, worksheets as pages, and cells as boxes on the page.

Describe how you would find and select a specific cell in Excel.

Cells are named by column letter plus row number.

Practice

1. What is a workbook in Excel?

easy

A. A formula used to calculate values

B. A single cell in a worksheet

C. A chart created from data

D. A file that contains one or more worksheets

Solution

1. Step 1: Understand workbook definition

   A workbook is the Excel file you open or save. It holds all your data.

2. Step 2: Differentiate workbook from other elements

   Worksheets are inside a workbook; cells and charts are parts of worksheets.

3. Final Answer:

   A file that contains one or more worksheets -> Option D

4. Quick Check:

   Workbook = file with worksheets [OK]

Hint: Remember: Workbook = Excel file, Worksheet = tab inside [OK]

Common Mistakes:

• Confusing workbook with a single cell
• Thinking workbook is a formula
• Mixing workbook with charts

2. Which of these is the correct way to refer to a cell in Excel?

easy

A. A1

B. 1A

C. Row1ColA

D. Cell(1, A)

Solution

1. Step 1: Recall cell naming convention

   Excel cells are named by column letter first, then row number, like A1.

2. Step 2: Check each option

   Only A follows the correct pattern: letter then number.

3. Final Answer:

   A1 -> Option A

4. Quick Check:

   Cell name = Column letter + Row number [OK]

Hint: Column letter first, then row number for cell names [OK]

Common Mistakes:

• Swapping row and column order
• Using function-like syntax
• Writing full words instead of letters and numbers

3. If you enter the number 10 in cell B2 and the formula =B2+5 in cell C2, what will be the value shown in C2?

medium

A. 5

B. 15

C. B2+5

D. 10

Solution

1. Step 1: Understand cell reference in formula

   The formula =B2+5 adds 5 to the value in cell B2.

2. Step 2: Calculate the result

   Since B2 contains 10, the formula calculates 10 + 5 = 15.

3. Final Answer:

   15 -> Option B

4. Quick Check:

   10 + 5 = 15 [OK]

Hint: Formula adds referenced cell value plus number [OK]

Common Mistakes:

• Thinking formula shows text instead of result
• Adding row and column numbers instead of cell value
• Ignoring the plus sign in formula

4. You typed the formula =A1+B1 in cell C1, but it shows an error. Which of these could fix the problem?

medium

A. Delete the formula and type numbers directly in C1

B. Change the formula to =A1-B1

C. Make sure A1 and B1 contain numbers, not text

D. Rename the worksheet

Solution

1. Step 1: Identify cause of formula error

   Formula errors often happen if referenced cells have text instead of numbers.

2. Step 2: Choose fix that addresses error

   Ensuring A1 and B1 contain numbers will allow =A1+B1 to calculate correctly.

3. Final Answer:

   Make sure A1 and B1 contain numbers, not text -> Option C

4. Quick Check:

   Numbers needed in referenced cells [OK]

Hint: Check referenced cells have numbers, not text [OK]

Common Mistakes:

• Changing formula operation without reason
• Deleting formula instead of fixing data
• Thinking worksheet name affects formula

5. You have a workbook with three worksheets named Jan, Feb, and Mar. In cell A1 of Feb, you want to show the value from cell B2 of Jan. Which formula should you enter in Feb!A1?

hard

A. =Jan!B2

B. =B2!Jan

C. =Feb!JanB2

D. =B2

Solution

1. Step 1: Understand cross-worksheet reference syntax

   To get a value from another worksheet, use =SheetName!CellAddress.

2. Step 2: Apply to given sheets and cells

   From Feb, to get Jan sheet's B2 cell, write =Jan!B2.

3. Final Answer:

   =Jan!B2 -> Option A

4. Quick Check:

   Cross-sheet reference = SheetName!Cell [OK]

Hint: Use SheetName!Cell to reference other sheets [OK]

Common Mistakes:

• Reversing sheet and cell order
• Using invalid syntax with exclamation mark
• Omitting sheet name for cross-sheet reference