Chapter 27 MS Excel English + Hindi

Excel Basic Formulas

एक्सेल बेसिक फॉर्मूला

Excel Basic Formulas

एक्सेल बेसिक फॉर्मूला

Formulas perform calculations in Excel. Common formulas include SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, TODAY, NOW, and CONCAT. This chapter connects the topic with classroom explanation, real examples, and hands-on practice.

Formulas Excel में calculation करते हैं. Common formulas हैं SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, TODAY, NOW और CONCAT. इस chapter में topic को classroom explanation, real examples और hands-on practice से समझाया गया है.

Excel Basic Formulas topic visual / एक्सेल बेसिक फॉर्मूला चित्र
Chapter image shows the exact topic parts for visual learning. / Chapter image में topic के parts साफ दिखाए गए हैं.

Tool Heading & Description / टूल शीर्षक और विवरण

Formula rules

Formula rules is used to enter, calculate, arrange, format, or present data in Excel.

Formula rules Excel में data enter, calculate, arrange, format या present करने में use होता है.

Equal sign

Equal sign is a main point of Excel Basic Formulas and should be understood before practical work.

Equal sign Excel Basic Formulas ka main point hai; practical se pehle iska meaning samajhna zaroori hai.

SUM

SUM is used to enter, calculate, arrange, format, or present data in Excel.

SUM Excel में data enter, calculate, arrange, format या present करने में use होता है.

AVERAGE

AVERAGE is used to enter, calculate, arrange, format, or present data in Excel.

AVERAGE Excel में data enter, calculate, arrange, format या present करने में use होता है.

MAX

MAX is used to enter, calculate, arrange, format, or present data in Excel.

MAX Excel में data enter, calculate, arrange, format या present करने में use होता है.

Learning Objectives / सीखने के लक्ष्य

  • Write formulas starting with equal sign.
  • Use SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, TODAY, NOW, and CONCAT.
  • Understand cell ranges in formulas.

Theory / Meaning / अर्थ

English MeaningFormulas perform calculations in Excel. Common formulas include SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, TODAY, NOW, and CONCAT.

Hindi MeaningFormulas Excel में calculation करते हैं. Common formulas हैं SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, TODAY, NOW और CONCAT.

Uses / उपयोग

  • Total marks, average marks, highest/lowest marks, count of entries, date, and joining text.

Step-by-Step Teaching / पढ़ाने के स्टेप्स

  1. Enter numbers in cells A1 to A5.
  2. Type =SUM(A1:A5) to find total.
  3. Use =AVERAGE(A1:A5), =MAX(A1:A5), and =MIN(A1:A5).
  4. Use COUNT for numbers and COUNTA for filled cells.
  5. Use TODAY and NOW for date/time.
  6. Use CONCAT to join first and last name.

Teacher Explanation Notes / शिक्षक नोट्स

  • Every formula must start with = sign; repeat this rule often.
  • Teach typing formulas and using mouse selection both ways.

Practical Work / प्रैक्टिकल कार्य

  • Create a marks table and calculate Total, Average, Highest, Lowest, and Count.
  • Add today's date using TODAY formula.

Homework / गृहकार्य

  • Write syntax and use of SUM, AVERAGE, MAX, MIN, COUNT, and IF.
  • Practice five simple formula examples.

Short Test Questions / छोटे टेस्ट प्रश्न

  1. Which sign starts a formula?
  2. What does SUM do?
  3. What does AVERAGE do?
  4. What does MAX return?
  5. What does COUNT count?

Viva Questions / मौखिक प्रश्न

  1. =SUM(A1:A5) ka matlab kya hai?
  2. TODAY formula kya show karta hai?
  3. COUNTA aur COUNT me difference kya hai?

Real Image + Image Prompt / वास्तविक चित्र + इमेज प्रॉम्प्ट

Excel Basic Formulas educational image / एक्सेल बेसिक फॉर्मूला educational image
Suggested file: excel-formulas.jpg | सुझाया गया file name: excel-formulas.jpg

Create an educational Excel formulas image showing sample cells and formulas: SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, TODAY, NOW, CONCAT with Hindi and English explanations.