Table
Comprehensive notes, formulas, and practice questions for Table.
Table
Table
What you'll learn
- How to extract and compute from data tables — rows, columns, totals, and missing cells.
- To calculate row/column totals, averages, growth rates, and rankings from tabular data.
- To handle multi-level headers and unit rows in exam-style tables.
- To spot inconsistencies and fill missing entries using row-column sum rules.
Key concepts
Level 1 — Foundations
Verbal: A table organises data in rows (e.g. years, students) and columns (e.g. subjects, regions). Intersection cell = one value.
Reading protocol:
- Read title and footnotes (units, *, missing = NA).
- Identify stub (row labels) vs column headers.
- Check if last row/column is Total.
Operations:
| Task | Method |
|---|---|
| Row total | Sum across columns in that row |
| Column total | Sum down that column |
| Missing cell | Total − known entries |
| Average of row | Row total ÷ number of data columns |
| Rank in column | Sort column values high→low |
Ratio from table: Compare two cells in same row (same year, two products) or same column (same product, two years).
Level 2 — Exam depth
Percent change from table: ((New − Old)/Old) × 100 using two cells in one column.
Weighted average trap: Average marks of Class A and B need student counts — not average of two class averages unless equal size.
Transpose reading: "Sales by region" table — region in rows vs columns changes nothing if you track labels.
Double totals: Grand total cell should equal sum of row totals and column totals — use as checksum.
Time series tables: Watch fiscal year vs calendar year labels in footnotes.
Worked example
Fill a missing cell using row and column totals
Q1 Q2 Q3 Total
Product A 12 ? 15 40
Product B 18 22 20 60
Total 30 35 35 100
Step 1 — A in Q2: row total 40 − 12 − 15 = **13**.
Step 2 — Verify column Q2: 13 + 22 = 35 ✓.
Rank products by annual total
From above, Product B total = 60, Product A = 40 → **B ranked 1st, A 2nd**.
If equal totals, tie rank; next rank skips (standard competition ranking) unless question says otherwise.
Common mistakes
| Mistake | Why it happens | Fix |
|---|---|---|
| Summing a Total row again into grand total | Double-counted | Exclude total rows when summing raw data |
| Averaging averages without weights | Equal-size assumed | Use (sum of all)/(count of all) |
| Misaligned row after sorting | Sorted numbers not names | Sort pairs (name, value) together |
| Wrong column for percent change | Mixed products | Percent change down one column only |
Quick check
- Row totals 50, 70; column totals match — grand total should be?
- Marks: Hindi 80, English 90, Maths ?; average 85 — find Maths.
- Why read footnotes before calculating profit from a revenue table?
- Stretch: Table gives % growth only — reconstruct absolute values possible? When?
Revision tip: Revisit adjacent topics in Data Interpretation before mixed practice on Table.
Open the Practice tab for graded questions on Table.
Exam strategy
Shade or bracket total rows/columns so you never add them into fresh sums. For growth-rate items, confirm whether the base year is the earlier column entry. When tables nest headers (region under zone), read the header hierarchy twice before picking a cell. If a cell is missing, solve using the simplest intersecting total — row total usually faster than column.
Key Takeaways (TL;DR)
- What you'll learn
- Key concepts
- Worked example
- Common mistakes
Master this topic with Drishti OS
Get unlimited mock tests, AI-powered mentorship, and complete video courses when you join.
Start Free Practice