Select Medium / माध्यम चुनें:

CBSE • Class 7 • Computer Science • Ch 4

Estimated Time: 45 Mins

Study Progress: In Progress

Basics of Microsoft Excel

In Class 7 Computer Science, "Basics of Microsoft Excel" delivers hands-on digital literacy, procedural logic, and software mastery aligned with the 2026–27 CBSE curriculum.

Take Chapter CBT Test View All Chapters

Overview Core Concepts Summary Self Check Take MCQ Test

📊 Have You Ever Wondered?

How do accountants calculate monthly salaries for 10,000 employees in three seconds without making a single addition error? Microsoft Excel is the wor...

How do accountants calculate monthly salaries for 10,000 employees in three seconds without making a single addition error? Microsoft Excel is the world's standard electronic spreadsheet software.

Why This Chapter Matters

In Class 7 Computer Science, "Basics of Microsoft Excel" delivers hands-on digital literacy, procedural logic, and software mastery aligned with the 2026–27 CBSE curriculum.

Before You Begin (Prerequisites)

Tables of rows and columns.
Basic arithmetic (addition, subtraction, multiplication).
Graph charts.

What You Will Learn (Core Objectives)

Navigate an Excel workbook and worksheet (rows, columns, cells, active cell).
Explain cell references (e.g. A1, C10, $B$4).
Enter and format three types of data: labels (text), values (numbers), and formulas.
Construct mathematical formulas beginning with the equals sign ($=$).
Use essential built-in functions: SUM, AVERAGE, COUNT, MAX, and MIN.

Chapter Roadmap & Progression

1 1. The Grid Architecture of Excel

2 2. Cell References & The Golden For...

3 3. Five Essential Built-in Function...

Complete Concept Guide (100% Curriculum Coverage)

1. The Grid Architecture of Excel

An Excel file is called a Workbook, which contains multiple sheets called Worksheets. Each worksheet is a giant grid of Columns (labeled with letters: A, B, C... up to XFD) and Rows (labeled with numbers: 1, 2, 3... up to 1,048,576). The intersection of a row and a column is called a Cell.

2. Cell References & The Golden Formula Rule

Every cell has a unique address called a Cell Reference (e.g. $B5$ is column B, row 5).
The Golden Rule of Excel: Every single formula or function MUST begin with an equals sign ($=$)! E.g. =A1+B1.

3. Five Essential Built-in Functions

=SUM(A1:A10) → Adds all numbers in the cell range A1 to A10.
=AVERAGE(B1:B20) → Computes the arithmetic mean.
=COUNT(C1:C30) → Counts how many cells contain numbers.
=MAX(D1:D15) → Finds the highest value in the range.
=MIN(D1:D15) → Finds the lowest value in the range.

Visual Learning & Conceptual Map

Basics of Microsoft Excel Technical Architecture

Core commands, interface tools, and computational logic

Technical Framework

1. The Grid Architecture of Excel • 2. Cell References & The Golden Formula Rule • 3. Five Essential Built-in Functions

Chapter Summary & 10 Key Takeaways

Takeaway 1

Workbook: An Excel file containing multiple worksheet tabs.

Takeaway 2

Cell Address: Intersection of column letter and row number (e.g. C12).

Takeaway 3

Formula Rule: Must always begin with an equals sign (=).

Takeaway 4

Functions: Pre-built mathematical formulas (SUM, AVERAGE, COUNT, MAX, MIN).

Takeaway 5

AutoSum: One-click shortcut button to sum adjacent rows or columns.

Check Your Understanding (Diagnostic Practice Questions)

Diagnostic questions testing core conceptual clarity. Answers are hidden initially — solve each problem first, then click to reveal the step-by-step verified solution.

What must every formula or function in Excel begin with?

Reveal Answer & Explanation

Answer: An equals sign (=). Without it, Excel treats the entry as plain text.
Must begin with '='.

What is a Cell Reference? Give an example.

Reveal Answer & Explanation

Answer: It is the address of a cell formed by its column letter followed by its row number, such as B4 or D12.
Column letter and row number (B4).

Explain the difference between a formula and a function in Excel.

Reveal Answer & Explanation

Answer: A formula is a custom user-written mathematical expression (e.g. =A1+A2+A3); a function is a pre-defined built-in shortcut formula (e.g. =SUM(A1:A3)).
User expression vs built-in shortcut.

What does the function =AVERAGE(B1:B5) do?

Reveal Answer & Explanation

Answer: It calculates the arithmetic mean of all numeric values located in the cells from B1 through B5.
Calculates the average of the range.

What is the Name Box in the Excel interface?

Reveal Answer & Explanation

Answer: It is the box located to the left of the formula bar that displays the cell address of the currently active cell.
Displays active cell address.

Finished Studying This Chapter?

READY TO PRACTICE?

Timed CBT Practice Tests (Exam Simulator)

Put your concepts to the test with official curriculum-aligned Foundation and Advanced practice tests. Get instant accuracy scores, time metrics, and step-by-step verified explanations.

Foundation Test

15 MCQs • Core Concepts

Advanced Test

15 MCQs • HOTS & Traps