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

1️⃣ Sorting Data

  • Data → Sort Ascending / Descending
  • Multiple column sorting possible

2️⃣ Filtering Data

  • Standard Filter: Specific criteria apply करना
  • AutoFilter: Quick selection of rows

3️⃣ Named Ranges

  • Cells या Range को नाम देना
  • Example: =SUM(Sales) instead of =SUM(A1:A10)

4️⃣ AutoFill

  • Cells में sequence जल्दी fill करना
  • Example: 1,2,3 → drag → 4,5,6

5️⃣ Merge & Split Cells

  • Merge: Multiple cells को एक cell में combine
  • Split: Merge cells को वापस separate

6️⃣ Row / Column Operations

  • Insert / Delete Row & Column
  • Resize Row Height / Column Width

7️⃣ Sheet Navigation

  • Move to next / previous sheet
  • Shortcut: Ctrl+PageUp / Ctrl+PageDown

8️⃣ Hyperlinks in Calc

  • Insert → Hyperlink
  • Link to external website या internal sheet

9️⃣ Print Setup

  • Page Orientation: Portrait / Landscape
  • Margins, Header/Footer setup
  • Print Preview before printing

🔟 Shortcuts in Calc

  • Ctrl+C → Copy
  • Ctrl+V → Paste
  • Ctrl+X → Cut
  • Ctrl+S → Save
  • Ctrl+Z → Undo
  • Ctrl+Y → Redo