LibreOffice Calc questions appear in both Section A (MCQ) and Section B (subjective) of the IT 402 board exam. Students who understand how Calc functions work — not just what they're called — consistently score higher in this section than those who memorise names without understanding.
This is the most comprehensive LibreOffice Calc formula guide for CBSE Class 10 IT 402 — covering every function that has appeared or is likely to appear in board exams, with exact syntax and worked examples.
Understanding Calc Formula Basics
Every formula in LibreOffice Calc starts with an equals sign (=). Without the = sign, Calc treats the entry as text, not a formula.
Cell References: Calc refers to cells using column letter + row number: A1, B3, C10. When you write =A1+B1, Calc adds the values in cells A1 and B1.
Range: A range is a group of cells written as FirstCell:LastCell. For example, A1:A10 means all cells from A1 to A10.
Essential Formulas — Exam Reference Table
| Function | Syntax | What It Does | Example |
|---|---|---|---|
| SUM | =SUM(range) | Adds all values in a range | =SUM(A1:A10) → adds A1 through A10 |
| AVERAGE | =AVERAGE(range) | Calculates arithmetic mean | =AVERAGE(B1:B5) → average of B1–B5 |
| MAX | =MAX(range) | Returns the highest value | =MAX(C1:C20) → highest in C1–C20 |
| MIN | =MIN(range) | Returns the lowest value | =MIN(D1:D10) → lowest in D1–D10 |
| COUNT | =COUNT(range) | Counts cells with numbers | =COUNT(A1:A10) → how many cells have numbers |
| COUNTA | =COUNTA(range) | Counts non-empty cells | =COUNTA(A1:A10) → counts all non-empty cells |
| IF | =IF(condition,true,false) | Returns different values based on condition | =IF(A1>50,"Pass","Fail") |
| COUNTIF | =COUNTIF(range,criteria) | Counts cells matching a condition | =COUNTIF(A1:A10,">50") → cells with value above 50 |
| SUMIF | =SUMIF(range,criteria) | Sums cells matching a condition | =SUMIF(A1:A10,">50") → sum of values above 50 |
| NOW() | =NOW() | Returns current date and time | =NOW() → shows current timestamp |
| TODAY() | =TODAY() | Returns today's date | =TODAY() → shows today's date |
Deep Dive — The IF Function (Most Important for Exams)
The IF function is the most frequently tested Calc function in IT 402 exams. It tests a condition and returns one value if the condition is true and another if false.
Syntax: =IF(logical_test, value_if_true, value_if_false)
Example 1 (Pass/Fail): =IF(A1>=33,"Pass","Fail") — if the value in A1 is 33 or more, shows "Pass", otherwise shows "Fail"
Example 2 (Grade): =IF(A1>=75,"Distinction",IF(A1>=60,"First Class","Second Class")) — nested IF for multiple grade categories
Exam Tip: When writing IF formulas in board exam answers, always write out all three parts: condition, true value, false value. Many students forget the false value and lose marks.
Practical Questions from Board Exams
Type 1 — Write the formula to calculate
Q: A student has marks in cells B2 to B6. Write the formula to find the total marks.
A: =SUM(B2:B6)
Q: Write a formula to display "Passed" if marks in D3 are greater than or equal to 33, otherwise "Failed".
A: =IF(D3>=33,"Passed","Failed")
Type 2 — What will the formula output?
Q: If A1=70, A2=85, A3=60, what will =MAX(A1:A3) return?
A: 85
Q: If A1=70, A2=85, A3=60, what will =AVERAGE(A1:A3) return?
A: 71.67 (215 ÷ 3)
Type 3 — Identify the error
Q: A student wrote SUM(B1:B10) instead of =SUM(B1:B10). What will Calc display?
A: Calc will display the text "SUM(B1:B10)" as a string, not calculate the sum. The = sign is mandatory for any formula.
Chart Types in LibreOffice Calc
IT 402 also tests knowledge of chart creation and types. Key chart types to know:
- Bar Chart: Compares values across categories (e.g., sales in different months)
- Line Chart: Shows trends over time (e.g., temperature over a week)
- Pie Chart: Shows proportion/percentage of a whole (e.g., subject-wise marks distribution)
- Column Chart: Vertical bars — similar to bar chart, used for time-based comparisons
Common Exam Question: "Which chart type is best suited for showing the percentage contribution of each department to total sales?" Answer: Pie Chart — because it shows parts of a whole as percentages.
Keyboard Shortcuts in LibreOffice Calc (Sometimes Tested)
| Shortcut | Action |
|---|---|
| Ctrl + S | Save the file |
| Ctrl + Z | Undo last action |
| Ctrl + C / Ctrl + V | Copy / Paste |
| Ctrl + B | Bold |
| Ctrl + Home | Go to cell A1 |
| Ctrl + End | Go to last used cell |
| F2 | Edit selected cell |
💡 Exam Preparation Tip: Download LibreOffice for free (libreoffice.org) and spend 30 minutes actually typing these formulas in a real spreadsheet. Typing =SUM(A1:A10), pressing Enter, and seeing the result once is worth reading about it ten times. Hands-on practice makes recall automatic under exam pressure.
For Section B of IT 402, LibreOffice Calc questions are among the highest-scoring because they are direct and unambiguous — you either know the formula or you don't. Master these formulas and Section B Calc questions become free marks. Check the complete IT 402 2026 answer key on SkillYog to see how these formula questions were answered in the actual board exam.