What is a Row?

• A row is a horizontal series of cells in a worksheet.

• Rows are identified by numbers on the left side of the worksheet (e.g., 1, 2, 3, …).

• Each row runs from left to right across the worksheet.

• A single row can contain multiple cells, and each cell in a row can store data (text, numbers, formulas, etc.).

Example:

• Row 1: A1, B1, C1, D1, …

• Row 2: A2, B2, C2, D2, …

What is a Column?

• A column is a vertical series of cells in a worksheet.

• Columns are identified by letters at the top of the worksheet (e.g., A, B, C, …).

• Each column runs from top to bottom in the worksheet.

• A single column can contain multiple cells, and each cell in a column can store data.

Example:

• Column A: A1, A2, A3, A4, …

• Column B: B1, B2, B3, B4, …

Key Differences Between Rows and Columns

How Rows and Columns Work Together

• The intersection of a row and a column is called a cell.

• Each cell is identified by its cell reference, which combines the column letter and row number (e.g., B3 is the cell in Column B, Row 3).

• Together, rows and columns create a structured grid where you can input, organize, and analyze data.

Example:

• In a table of student data:

  • Each row represents a student.

  • Each column represents an attribute (e.g., Name, Age, Grade).

What is a Cell in Excel?

A cell is the most basic building block of an Excel worksheet. It is the intersection point of a row and a column, where you can input, store, and manipulate data. Each cell is uniquely identified by its cell reference, which combines the column letter and row number (e.g., B5 is the cell in Column B, Row 5).

Key Features of a Cell

1. Cell Reference

   • Every cell has a unique address, called a cell reference, which is a combination of the column letter and row number.

   • Example: The cell in Column C and Row 4 is referenced as C4.

2. Data Storage

   • A cell can store different types of data, including:

     • Text (e.g., names, labels)

     • Numbers (e.g., prices, quantities)

     • Formulas (e.g., =A1+B1)

     • Dates and Times

     • Boolean values (TRUE or FALSE)

3. Formatting

   • Cells can be formatted to change the appearance of data, such as:

     • Font style, size, and color

     • Cell borders and background colors

     • Number formatting (e.g., currency, percentages)

4. Active Cell

   • The active cell is the currently selected cell, highlighted by a bold border. You can input or edit data in the active cell.

How Cells Work in Excel

• Cells are organized in a grid format, with rows (numbered) and columns (lettered).

• Each cell can hold a single piece of data or a formula that performs calculations.

• Cells can reference other cells to create dynamic relationships. For example:

  • If A1 contains the value 10 and B1 contains the value 20, you can use a formula in C1 like =A1+B1 to display the result 30.