Chapter 2 Formula and functions | Part 1 |Easy explanation with practical | Class 7 Computer |

Опубликовано: 21 Февраль 2026
на канале: Tejpal Maurya

139,751

2.1k

#class7 #chapter2_Formula_and_function #tejpalmaurya #excel_formulas
In this part 1 video of chapter 2 ( Formula and functions) of class 7 computer, I have explained the following topics related to excel on given timestamps:
00:39 Introduction of formula and functions
01:20 what are formulas in excel
2:35 elements of formula
5:32 Creating basic formula in excel
7:55 Using compound formula in excel
11:46 Using formula on text
14:33 Cell Range
16:53 Using cell range in formula
18:30 Naming a range
21:25 using a named range in formula
23:35 Using cell reference and its types
24:41 Types of cell reference in excel
25:00 Relative cell reference in excel
28:07 Absolute cell reference in excel
31:11 Mixed Cell reference in Excel

if you like this video please do subscribe to my channel

links to other chapters of class 7 computer
Chapter 1 Explanation Video
   • Chapter 1 Number System | Class 7 Computer...

watch Chapter 1 Solutions /Question Answers based video
   • Class 7 Computer || Chapter -1 Number Syst...

Chapter 2 Solutions / Question Answers
   • Class 7 Computer || Chapter 2 Solutions ||...

Video Related to chapter 2
   • Class 7 Computer Chapter 2 | Cell Referenc...

Chapter 3 Explanation Videos
   • Class 7 Computer | Chapter 3 - Advanced fe...

Chapter 3 Solutions / Question Answers
   • Class 7 Computer || Chapter-3 Advanced Fea...

Chapter 4 Explanation Videos
Part 1
   • Class 7 Computer | Chapter 4  Log on to An...
Part 2
   • Class 7 Computer | Chapter 4  Log on to An...
Part 3
   • Class 7 Computer | Chapter 4 | Log on to A...

Chapter 4 Solutions / Question Answers
   • Class 7 Computer | Chapter-4 Log on to Ani...

Chapter 5 Explanation Videos
Part 1
   • Chapter 5 Working with Layers | Class 7 Co...
Part 2
   • Chapter 5 -Working with Layers | Part-2 | ...
Part 3
   • Masking a Layer in Animate Cc | Chapter 5 ...

Chapter 5 Solutions / Question Answers
   • Class 7 Computer | Chapter 5 Solutions | W...

Chapter 6 Explanation Videos
Part 1
   • Class 7 Computer | Chapter 6 Introducing P...
Part 2
   • Chapter 6 Introducing Python |  Part 2 | C...

Chapter 6 Solutions / Question Answers
   • Chapter 6 Solutions/ Question Answer with ...

watch explanation part of chapter 7
Part 1
   • Chapter 7 More on Python | Part 1 | Class ...
Part 2
   • Chapter 7 More on Python | Part 2 | Class ...

Watch Solutions/ Question Answer video of chapter 7
   • Chapter 7 Question Answers /Solutions with...

Watch Explanation Part 1 of Chapter 8 More on CSS3
   • Class 7 Computer | Chapter 8 More on CSS 3...
Watch Explanation Part 2 of Chapter 8 More on CSS 3
   • Chapter 8 More on CSS 3 | Part 2 | Class 7...
Solutions/Question Answers of Chapter 8
   • Chapter 8 More on CSS3 Question Answer | S...

Watch Part 1 of chapter 9 Using list and Tables in HTML
   • Chapter 9 Using list and tables in HTML 5 ...
Watch Part 2 of chapter 9 Using list and Tables in HTML
   • Chapter 9 Using list and tables in HTML | ...