1. What is a Dialog Box? (संवाद बॉक्स क्या है?)

Dialog Box एक छोटा window होता है जो spreadsheet में advanced formatting और detailed options के लिए खुलता है।

• यह toolbar/ribbon buttons से ज्यादा control देता है।

• Example: Excel में Ctrl + 1 दबाने से Format Cells Dialog Box खुलता है।

---

2. Why Use Dialog Boxes for Formatting Values? (संवाद बॉक्स का प्रयोग क्यों करें?)

Toolbar icons से केवल quick formatting (जैसे Bold, Italic, Font Color) possible है,
लेकिन dialog box से आप complete और precise formatting कर सकते हैं।

Dialog Box से आप कर सकते हैं:
✅ Exact decimal places set करना
✅ Specific currency symbol (₹, $, £, ¥) लगाना
✅ Custom date/time format चुनना
✅ Professional borders & patterns लगाना
✅ Cells को protect करना

---

3. Main Dialog Box: Format Cells (फ़ॉर्मेट सेल्स संवाद बॉक्स)

Shortcut: Ctrl + 1
इसमें 6 main tabs होते हैं:

(i) Number Tab (संख्या टैब)

• Numeric values को format करने के लिए।

• Options:

  • General (default)

  • Number (decimal, comma separator)

  • Currency (₹, $, £)

  • Accounting (currency align)

  • Date & Time (dd/mm/yyyy, hh:mm AM/PM)

  • Percentage (0.85 → 85%)

  • Fraction, Scientific (½, 3.2E+04)

  • Custom (Roll No. 001)

(ii) Alignment Tab (संरेखण टैब)

• Text/Numbers की cell में position control करता है।

• Options: Left, Center, Right / Top, Middle, Bottom

• Wrap Text, Shrink to Fit, Merge Cells

• Text Orientation (rotate text)

(iii) Font Tab (फ़ॉन्ट टैब)

• Text का style change करने के लिए।

• Options: Bold, Italic, Size, Color

• Effects: Strikethrough, Superscript, Subscript

(iv) Border Tab (सीमा टैब)

• Cell के चारों तरफ line बनाने के लिए।

• Thin, Thick, Dotted, Double lines

• Custom Borders

(v) Fill Tab (भराव टैब)

• Cell background color change करना।

• Gradient, Pattern, Textures

(vi) Protection Tab (सुरक्षा टैब)

• Cell security के लिए।

• Locked (edit prevent)

• Hidden (formulas hide)

---

4. Other Useful Dialog Boxes (अन्य महत्वपूर्ण संवाद बॉक्स)

(a) Conditional Formatting → Example:

• Marks < 33 → Red background

• Marks ≥ 80 → Green background

(b) Data Validation → Example:

• केवल whole numbers (1–100)

• केवल specific dates (01-01-2025 to 31-12-2025)

(c) Find & Replace / Go To Special → Specific values locate और format करने के लिए।

---

5. Advantages of Dialog Boxes (लाभ)

• Detailed control देता है

• Number/Date/Time का customization possible

• Spreadsheet professional दिखता है

• Multiple cells में एक साथ formatting possible

• Data clear, readable और attractive बनता है

---

6. Practical Example (व्यावहारिक उदाहरण)

• Student Marks table → Format Cells → Number Tab → 0 decimals

• Conditional Formatting → failed (<33) = Red color

• Alignment → Center headings

• Font → Bold headings + color change

• Border → Draw table borders

• Fill → Yellow header row

Result → Professional & neat marksheet

---

✨ Summary (सारांश)

• Dialog Box = advanced formatting का window.

• सबसे important: Format Cells (Ctrl + 1) → 6 tabs.

• Other: Conditional Formatting, Data Validation.

• Dialog Boxes से spreadsheet clear, attractive, professional बनती है।

1. What is a Dialog Box?

A Dialog Box is a small window that appears in a spreadsheet when we want to perform advanced formatting or set detailed options.

• It provides more control compared to quick toolbar/ribbon buttons.

• Example: In MS Excel, pressing Ctrl + 1 opens the Format Cells Dialog Box.

---

2. Why Use Dialog Boxes for Formatting Values?

Toolbar icons allow quick formatting (bold, italic, font color), but dialog boxes allow complete and precise formatting.

With dialog boxes, we can:
✅ Set exact decimal places
✅ Apply specific currency symbols (₹, $, £, ¥)
✅ Choose custom date/time formats
✅ Apply professional borders & patterns
✅ Protect cells from editing

---

3. Main Dialog Box: Format Cells

Shortcut: Ctrl + 1
This dialog box has 6 main tabs:

(i) Number Tab

• Used to format numeric values.

• Options:

  • General: Default format, no special formatting.

  • Number: Set decimal places, use comma separator.

  • Currency: Show numbers with currency symbol (₹, $, £).

  • Accounting: Aligns currency symbols neatly.

  • Date & Time: Display values as date/time.

  • Percentage: Convert to percentage (0.85 → 85%).

  • Fraction/Scientific: Show fractions or scientific notation (3.2E+04).

  • Custom: Create your own format (e.g., “Roll No. 001”).

(ii) Alignment Tab

• Controls text positioning in a cell.

• Options:

  • Horizontal: Left, Center, Right

  • Vertical: Top, Middle, Bottom

  • Wrap Text

  • Shrink to Fit

  • Merge Cells

  • Text Orientation (rotate text)

(iii) Font Tab

• Controls style of text.

• Options:

  • Font Style: Regular, Bold, Italic

  • Font Size

  • Underline (single/double)

  • Font Color

  • Effects: Strikethrough, Superscript, Subscript

(iv) Border Tab

• Draws lines around cells.

• Options:

  • Line Styles: Thin, Thick, Dotted, Double

  • Border Placement: Around cell, inside table, top/bottom/left/right

  • Custom Borders

(v) Fill Tab

• Colors the background of cells.

• Options:

  • Fill Color

  • Fill Effects (gradient, pattern, textures)

  • Pattern Color & Style

(vi) Protection Tab

• Used for worksheet security.

• Options:

  • Locked: Prevent editing

  • Hidden: Hide formulas

---

4. Other Useful Dialog Boxes

(a) Conditional Formatting – Apply rules like:

• Marks < 33 → Red background

• Marks ≥ 80 → Green background

(b) Data Validation – Control data entry:

• Whole numbers only (1–100)

• Dates between 01-01-2025 and 31-12-2025

(c) Find & Replace / Go To Special – Helps locate and format specific values.

---

5. Advantages of Dialog Boxes

• Provides detailed control

• Allows customization (number, date, time)

• Creates professional spreadsheets

• Saves time (apply formatting to multiple cells)

• Makes data clear, readable, and attractive

---

6. Practical Example

Student Marks Spreadsheet:

1. Format Cells → Number Tab → 0 decimal places

2. Conditional Formatting → failed (<33) = red color

3. Alignment → Center headings

4. Font Tab → Bold + change font color

5. Border Tab → Borders around table

6. Fill Tab → Yellow header row

Result: A professional, neat marksheet.

---

✨ Summary

• Dialog Box = small window with advanced formatting options.

• Main: Format Cells (Ctrl + 1) with 6 tabs.

• Other: Conditional Formatting, Data Validation.

• Dialog boxes make spreadsheets clear, attractive, professional.