Question 1

What is the average monthly sales (in lakhs ₹) of Clothing category from January to June?

Accepted Answer

Step 1: Sum of Clothing sales = 32 + 35 + 38 + 40 + 42 + 45 = 232 lakhs. Step 2: Average = 232 ÷ 6 = 38.67 lakhs ≈ 39 lakhs (rounded).

Question 2

By what amount (in lakhs) do Electronics sales exceed Sports & Outdoors sales?

Accepted Answer

Step 1: Electronics = 28% and Sports & Outdoors = 16%. Step 2: Difference in percentage = 28% - 16% = 12%. Step 3: Difference in sales value = 12% of 5,000 = (12/100) × 5,000 = 600 lakhs.

Question 3

In Q2, what is the difference between the sales of Store A and Store D?

Accepted Answer

Step 1: Find Q2 sales of Store A = 150 lakhs. Step 2: Find Q2 sales of Store D = 110 lakhs. Step 3: Difference = 150 - 110 = 40 lakhs. Answer: 40 lakhs

Question 4

What is the total sales (in lakhs ₹) of Electronics category from January to June 2023?

Accepted Answer

Step 1: Add all Electronics sales from Jan to Jun: 45 + 48 + 50 + 52 + 55 + 60 = 310 lakhs ₹

Question 5

What is the total sales (in lakhs ₹) of the South region for the first quarter (January to March)?

Accepted Answer

Step 1: Identify South region sales for January, February, March from Table 1.
Step 2: January (South) = 38 lakhs, February (South) = 42 lakhs, March (South) = 48 lakhs.
Step 3: Total = 38 + 42 + 48 = 128 lakhs ₹.

Question 6

If the profit margin for Home & Garden is 30%, what is the profit earned (in lakhs ₹) in March from this category?

Accepted Answer

Step 1: Home & Garden sales in March = 32 lakhs. Step 2: Profit = 32 × 30% = 32 × 0.30 = 9.6 lakhs ₹

Question 7

What is the ratio of Year 1 Q4 production to Year 2 Q4 production?

Accepted Answer

Step 1: From Table 2, Year 1 Q4 production = 180 thousand units, Year 2 Q4 production = 200 thousand units.
Step 2: Ratio = 180 : 200 = 9 : 10 (dividing both by 20).

Question 8

By what percentage did Store B's sales increase from Q1 to Q4?

Accepted Answer

Step 1: Store B's Q1 sales = 30 lakhs, Q4 sales = 50 lakhs. Step 2: Increase = 50 - 30 = 20 lakhs. Step 3: Percentage increase = (20/30) × 100 = 66.67%. Answer: 66.67%

Question 9

Which region had the highest total sales across all four months (January to April)?

Accepted Answer

Step 1: Calculate total sales for each region from Table 1.
North: 45 + 50 + 55 + 60 = 210 lakhs
South: 38 + 42 + 48 + 50 = 178 lakhs
East: 32 + 35 + 40 + 45 = 152 lakhs
West: 50 + 55 + 60 + 65 = 230 lakhs
Step 2: West region has the highest total of 230 lakhs.

Question 10

What is the sales value (in lakhs) of the Electronics category?

Accepted Answer

Step 1: Electronics accounts for 28% of total sales. Step 2: Total sales = ₹5,000 lakhs. Step 3: Electronics sales = 28% of 5,000 = (28/100) × 5,000 = 1,400 lakhs.

Question 11

What is the combined sales value (in lakhs) of Clothing and Books & Media categories?

Accepted Answer

Step 1: Clothing = 22% and Books & Media = 16% of total sales. Step 2: Combined percentage = 22% + 16% = 38%. Step 3: Combined sales = 38% of 5,000 = (38/100) × 5,000 = 1,900 lakhs.

Question 12

What is the total sales of Store C across all four quarters?

Accepted Answer

Step 1: Add all quarterly sales of Store C. Step 2: 80 + 100 + 120 + 140 = 440 lakhs. Answer: 440 lakhs

Question 13

What is the total sales of Store C across all four quarters?

Accepted Answer

Step 1: Add all quarterly sales of Store C. Step 2: 60 + 65 + 70 + 75 = 270 lakhs. Answer: 270 lakhs

Question 14

What is the average sales of Store D across all four quarters?

Accepted Answer

Step 1: Add all quarterly sales of Store D: 40 + 42 + 44 + 46 = 172 lakhs. Step 2: Divide by 4 quarters = 172/4 = 43 lakhs. Answer: 43 lakhs

Question 15

Which store had the highest total sales across all four quarters?

Accepted Answer

Step 1: Calculate total sales for each store. Store A: 45+50+55+60 = 210. Store B: 30+35+40+50 = 155. Store C: 60+65+70+75 = 270. Store D: 40+42+44+46 = 172. Store E: 50+55+60+65 = 230. Step 2: Store C has the highest total of 270 lakhs. Answer: Store C

Question 16

By what percentage did Books category sales increase from January to June?

Accepted Answer

Step 1: Books sales in Jan = 12 lakhs, in Jun = 20 lakhs. Step 2: Increase = 20 - 12 = 8 lakhs. Step 3: Percentage increase = (8 ÷ 12) × 100 = 66.67%

Question 17

What is the average production (in thousands) for Q2 across all three years?

Accepted Answer

Step 1: From Table 2, Q2 production: Year 1 = 135, Year 2 = 155, Year 3 = 175 thousand units.
Step 2: Average = (135 + 155 + 175) / 3 = 465 / 3 = 155 thousand units.

Question 18

What is the ratio of Store A's Q4 sales to Store D's Q4 sales?

Accepted Answer

Step 1: Store A's Q4 sales = 60 lakhs. Store D's Q4 sales = 46 lakhs. Step 2: Ratio = 60:46. Step 3: Simplify by dividing both by 2 = 30:23. Answer: 30:23

Question 19

By what percentage did the West region's sales increase from January to April?

Accepted Answer

Step 1: West region sales in January = 50 lakhs, April = 65 lakhs.
Step 2: Increase = 65 - 50 = 15 lakhs.
Step 3: Percentage increase = (15 / 50) × 100 = 30%.

Question 20

What is the sales value (in lakhs) of the Home & Kitchen category?

Accepted Answer

Step 1: Home & Kitchen accounts for 18% of total sales. Step 2: Total sales = ₹5,000 lakhs. Step 3: Home & Kitchen sales = 18% of 5,000 = (18/100) × 5,000 = 900 lakhs.

IBPS Clerk Data Interpretation Questions

IBPS Clerk Data Interpretation — Past Exam Questions

Study by Subtopic — Data Interpretation

Study Next — Quantitative Aptitude Topics