📊 Excel Basics #4 – Understanding Cells & Ranges

A cell stores a single piece of data, while a range is a group of two or more cells. Most Excel formulas and features work with ranges.

📌 What is a Cell?

• A cell is the intersection of a row and a column.

• Each cell has a unique address.

Examples:

• "A1"

• "B5"

• "D10"

📌 What is a Range?

A range is a collection of cells.

Examples:

• "A1:A10" → Cells A1 through A10

• "A1:C10" → All cells from A1 to C10

• "B2:D5" → A rectangular group of cells

📌 Why are Ranges Important?

Ranges are used in almost every Excel formula.

Examples:

• "=SUM(A1:A10)" → Adds all values from A1 to A10.

• "=AVERAGE(B2:B20)" → Calculates the average.

• "=MAX(C1:C15)" → Returns the highest value.

• "=COUNT(D1:D100)" → Counts cells containing numbers.

📌 Selecting a Range

• Click and drag your mouse across cells.

• Or click the first cell, hold Shift, and click the last cell.

• Press Ctrl + A to select the entire data region.

💡 Example:

Product | Sales

Laptop | 50000

Mouse | 800

Keyboard | 1500

To calculate total sales:

"=SUM(B2:B4)"

Result: 52300

✅ Quick Tip:

• Instead of selecting cells one by one, use ranges. It makes formulas shorter, easier to read, and simpler to maintain.

Double Tap ❤️ For More