Chapter 24: Excel Number Formatting

Chapter Description / अध्याय विवरण

Excel Number Formatting

एक्सेल नंबर फॉर्मेटिंग

Number formatting changes how values appear, such as normal numbers, currency, percentage, date, and decimals. This chapter connects the topic with classroom explanation, real examples, and hands-on practice.

Number formatting values को दिखाने का तरीका बदलती है, जैसे normal number, currency, percentage, date और decimals. इस chapter में topic को classroom explanation, real examples और hands-on practice से समझाया गया है.

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

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

General

General is a main point of Excel Number Formatting and should be understood before practical work.

General Excel Number Formatting ka main point hai; practical se pehle iska meaning samajhna zaroori hai.

Number

Number is a main point of Excel Number Formatting and should be understood before practical work.

Number Excel Number Formatting ka main point hai; practical se pehle iska meaning samajhna zaroori hai.

Currency

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

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

Percentage

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

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

Date

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

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

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

Apply General, Number, Currency, Percentage, and Date formats.
Increase and decrease decimals.
Choose correct number format for a table.

Theory / Meaning / अर्थ

English MeaningNumber formatting changes how values appear, such as normal numbers, currency, percentage, date, and decimals.

Hindi MeaningNumber formatting values को दिखाने का तरीका बदलती है, जैसे normal number, currency, percentage, date और decimals.

Uses / उपयोग

Showing money in bills and salary sheets.
Showing marks percentage.
Showing dates in attendance and records.

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

Enter sample price values and apply Currency format.
Enter decimal values and increase/decrease decimal places.
Enter 0.75 and apply Percentage format.
Enter dates and apply Date format.
Compare General and Number formats.

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

Explain formatting changes display, not always the actual stored value.
Show percentage using 0.75 equals 75 percent to avoid confusion.

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

Create a monthly expense table with item, date, amount, and percentage share.
Apply correct formats to date, currency, and percentage columns.

Homework / गृहकार्य

Write examples of Currency, Percentage, Date, and Number format.
Make a bill table rough format in notebook.

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

What is Currency format?
What is Percentage format?
What does Increase Decimal do?
Where is Date format used?
What is General format?

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

Rupee amount ke liye kaunsa format use karenge?
Date column me date format kyon lagate hain?
Decimal places kya hote hain?

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

Excel Number Formatting educational image / एक्सेल नंबर फॉर्मेटिंग educational image — Suggested file: excel-cell-row-column.jpg | सुझाया गया file name: excel-cell-row-column.jpg

Create an educational Excel Number group image showing General, Number, Currency, Percentage, Date, Increase Decimal, and Decrease Decimal with example cells and Hindi-English labels.