📘 LibreOffice Calc – Extra 10 Quick Revision Points (1–10)

1️⃣ Cell Referencing

  • Relative Reference: =A1+B1 → Copy करने पर adjust होता है
  • Absolute Reference: =$A$1+$B$1 → Copy करने पर नहीं बदलता

2️⃣ Basic Arithmetic Operations

  • Addition: =A1+B1
  • Subtraction: =A1-B1
  • Multiplication: =A1*B1
  • Division: =A1/B1

3️⃣ Common Functions

  • SUM, AVERAGE, MAX, MIN, COUNT, IF
  • Example: =SUM(A1:A10), =IF(A1>50,”Pass”,”Fail”)

4️⃣ Conditional Formatting

  • Cells को special formatting apply करना based on condition
  • Example: Highlight numbers >100 in red

5️⃣ Data Validation

  • Input restriction set करना
  • Example: Allow only numbers between 1–100

6️⃣ Freeze Rows / Columns

  • Header row या column हमेशा visible रखने के लिए
  • View → Freeze Rows / Columns

7️⃣ Protect Sheet / Workbook

  • Tools → Protect Sheet / Workbook
  • Prevent unwanted edits

8️⃣ Pivot Table

  • Data summarize करने के लिए powerful tool
  • Analyze large datasets quickly

9️⃣ Charts / Graphs Customization

  • Axis, Labels, Colors, Legend, Title customize करना
  • Visual representation enhance होती है

🔟 Import / Export Data

  • Import CSV, XLS, XLSX
  • Export to PDF, CSV, HTML for sharing