- Foundation
- About 13 min
- 5 practice questions
Finding missing values in tables
Rebuild missing entries in a table from totals, averages, percentages and ratios given in the question, and check the result.
If something looks wrong, please tell us.
Some DI tables have blanks. The question gives a total, an average, a percentage or a ratio, and you must find the missing figure before answering anything else. This is working backwards, and it is a common 'twist' in exam sets. The method is simple: turn every statement into an equation with one unknown.
The toolkit
- Total known: missing value = total - sum of the known values.
- Average known: total = average × number of items, then subtract the known values.
- Percentage known: if x% of the total equals a given amount, total = amount ÷ x × 100.
- Ratio known: if A : B = m : n and A is known, B = A × n ÷ m.
Worked example 1: totals and a comparison
Four plants P, Q, R, S made a total of 560 (thousand units). P made 120 and R made 150. Q made 20% more than P. Find S.
| Plant | P | Q | R | S | Total |
|---|---|---|---|---|---|
| Output | 120 | ? | 150 | ? | 560 |
Q = 120 × 1.20 = 144. Then S = 560 - (120 + 144 + 150) = 560 - 414 = 146. Check: 120 + 144 + 150 + 146 = 560.
Worked example 2: a percentage gives the total
A family's monthly budget is shown as percentages: Rent 35%, Food 25%, Education 15%, Others 10% and Savings (not given). Rent is ₹16,800. Find the savings in rupees.
The percentages shown add up to 35 + 25 + 15 + 10 = 85, so Savings = 100 - 85 = 15%. Total budget = 16,800 ÷ 35 × 100 = ₹48,000. Savings = 15% of 48,000 = ₹7,200. Always find the missing percentage first, then the total.
Worked example 3: an average gives a total
The average sale of five days is ₹42 (thousand). Four days were 38, 45, 40 and 50. Find the fifth day. Total of five days = 5 × 42 = 210. Total of four days = 38 + 45 + 40 + 50 = 173. Fifth day = 210 - 173 = 37.
A routine for blank-cell questions
- Write down every figure the question gives, including those in the question text.
- Decide which statement has exactly one unknown, and solve that first.
- Feed the answer into the next statement.
- Check by adding the row or column again, or by recalculating the percentage.
Be careful with phrases such as '20% more than P'. The base is P, so the factor is 1.20. '20% less than P' would use 0.80.
Sometimes one missing value depends on another. Suppose a row total is 300, two cells are unknown but one is twice the other, and the known cells add up to 90. Let the smaller unknown be x. Then x + 2x = 300 - 90 = 210, so 3x = 210 and x = 70. The two cells are 70 and 140, and 70 + 140 + 90 = 300 confirms it. Writing the unknown as x and building one equation is safer than guessing.
Turn every sentence into one equation with one unknown, and solve them in order of difficulty.
Key takeaways
- Missing value = total - the known parts.
- Total from an average = average × count.
- Total from a percentage = amount ÷ percentage × 100.
- Always check by adding back.
Check your understanding
-
1. The average of six numbers is 15. Five of them add up to 80. What is the sixth number?
- 5
- 15
- 20
- 10
Show answer
Answer: D. Total of six = 6 × 15 = 90. Sixth = 90 - 80 = 10.
-
2. Education is 18% of a budget and costs ₹1,260. What is the total budget?
- ₹6,300
- ₹7,000
- ₹7,560
- ₹22,680
Show answer
Answer: B. Total = 1,260 ÷ 18 × 100 = ₹7,000. Check: 18% of 7,000 = 1,260.
-
3. Two shops sell in the ratio 3 : 5. The first sold 45 units. How many did the second sell?
- 27
- 75
- 60
- 90
Show answer
Answer: B. Each part = 45 ÷ 3 = 15. Second = 5 × 15 = 75.
-
4. A row of four numbers adds up to 200. Three of them are 45, 60 and 38. What is the fourth?
- 53
- 67
- 93
- 57
Show answer
Answer: D. Known sum = 45 + 60 + 38 = 143. Fourth = 200 - 143 = 57.
-
5. A company's sales in 2022 were 12% more than in 2021. The 2022 sales were ₹2,240 lakh. What were the 2021 sales?
- ₹2,000 lakh
- ₹1,971.2 lakh
- ₹2,008 lakh
- ₹2,508.8 lakh
Show answer
Answer: A. 2021 sales = 2,240 ÷ 1.12 = 2,000. Check: 2,000 × 1.12 = 2,240.
Sign in to keep track of the lessons you finish.