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

1️⃣ Text Functions

  • LEFT(text, n): Text के first n characters
  • RIGHT(text, n): Text के last n characters
  • CONCATENATE(A1,B1): Cells का text जोड़ना

2️⃣ Date & Time Functions

  • TODAY(): Current date
  • NOW(): Current date and time
  • DATE(year, month, day): Specific date

3️⃣ Logical Functions

  • IF(condition, value_if_true, value_if_false)
  • Example: =IF(A1>50,”Pass”,”Fail”)

4️⃣ Lookup Functions

  • VLOOKUP(search_value, table_range, column_index, [approx_match])
  • HLOOKUP – Horizontal lookup

5️⃣ Mathematical Functions

  • ROUND(number, n): Round to n decimals
  • INT(number): Round down
  • ABS(number): Absolute value

6️⃣ Statistical Functions

  • AVERAGE(range) – Mean
  • MAX(range) – Maximum
  • MIN(range) – Minimum
  • COUNT(range) – Number of numeric cells

7️⃣ Data Grouping & Outlines

  • Data → Group rows/columns for better view
  • Collapse / Expand sections

8️⃣ Conditional Formatting in Calc

  • Format cells based on value
  • Example: Highlight values >100 in red

9️⃣ Sparklines

  • Mini charts inside a cell to show trends
  • Insert → Sparkline

🔟 Sheet Linking

  • Reference data from another sheet
  • Example: =Sheet2.A1