Question 1

What is the total sales of Electronics category across all four quarters?

Accepted Answer

Step 1: Add all Electronics sales across Q1, Q2, Q3, and Q4.
Step 2: 120 + 150 + 180 + 210 = 660 lakhs.
Answer: 660 lakhs

Question 2

What is the ratio of Q2 sales of Product B to Q2 sales of Product D?

Accepted Answer

Step 1: Q2 sales of Product B = 110 lakhs. Step 2: Q2 sales of Product D = 150 lakhs. Step 3: Ratio = 110 : 150 = 11 : 15 (dividing both by 10).

Question 3

What is the ratio of Q2 sales of Gamma to Q2 sales of Delta?

Accepted Answer

Step 1: Q2 sales of Gamma = 55 lakhs. Step 2: Q2 sales of Delta = 25 lakhs. Step 3: Ratio = 55 : 25 = 11 : 5.

Question 4

What is the average quarterly sales of Product C?

Accepted Answer

Step 1: Add all quarterly sales of Product C: 80 + 90 + 100 + 110 = 380 lakhs. Step 2: Divide by number of quarters: 380 ÷ 4 = 95 lakhs.

Question 5

Which product has the highest sales in Q4?

Accepted Answer

Step 1: Compare Q4 sales of all products: Product A = 180, Product B = 130, Product C = 110, Product D = 150, Product E = 105. Step 2: Product A has the highest sales of 180 lakhs in Q4.

Question 6

Which company has the highest sales in Q3?

Accepted Answer

Step 1: Compare Q3 sales: Alpha=60, Beta=40, Gamma=60, Delta=30, Epsilon=70. Step 2: Epsilon has the highest at 70 lakhs.

Question 7

What is the total sales of Alpha company across all four quarters?

Accepted Answer

Step 1: Add all quarterly sales of Alpha = 40 + 50 + 60 + 70 = 220 lakhs ₹

Question 8

What is the average quarterly sales of Delta company?

Accepted Answer

Step 1: Total sales of Delta = 20 + 25 + 30 + 35 = 110 lakhs. Step 2: Average = 110 ÷ 4 = 27.5 lakhs.

Question 9

By what percentage did Product E's sales increase from Q1 to Q4?

Accepted Answer

Step 1: Q1 sales of Product E = 60 lakhs, Q4 sales = 105 lakhs. Step 2: Increase = 105 - 60 = 45 lakhs. Step 3: Percentage increase = (45 ÷ 60) × 100 = 75%.

Question 10

What is the ratio of Q4 sales of Books & Media to Q4 sales of Sports & Outdoors?

Accepted Answer

Step 1: Q4 sales of Books & Media = 35 lakhs.
Step 2: Q4 sales of Sports & Outdoors = 70 lakhs.
Step 3: Ratio = 35 : 70 = 1 : 2.
Answer: 1:2

Question 11

By what percentage did Store B's sales increase from January to May?

Accepted Answer

Step 1: Store B's January sales = 30 lakhs, May sales = 50 lakhs.
Step 2: Increase = 50 - 30 = 20 lakhs.
Step 3: Percentage increase = (20 ÷ 30) × 100 = 66.67% ≈ 66⅔% or approximately 67%.

Question 12

Which store showed a consistent decrease in sales from January to May?

Accepted Answer

Step 1: Check the trend for each store across months.
Step 2: Store C shows: 60 → 58 → 56 → 54 → 52 (consistent decrease of 2 lakhs each month).
Step 3: All other stores show increases or remain constant.

Question 13

What is the average monthly sales of Store D over the five months?

Accepted Answer

Step 1: Add all sales values for Store D: 40 + 42 + 44 + 46 + 48 = 220 lakhs.
Step 2: Divide by number of months: 220 ÷ 5 = 44 lakhs.

Question 14

What is the difference between the total sales of Store E and Store C over all five months?

Accepted Answer

Step 1: Total sales of Store E = 50 + 55 + 60 + 65 + 70 = 300 lakhs.
Step 2: Total sales of Store C = 60 + 58 + 56 + 54 + 52 = 280 lakhs.
Step 3: Difference = 300 - 280 = 20 lakhs.

Question 15

Which product category had the highest total sales across all four quarters?

Accepted Answer

Step 1: Calculate total sales for each category:
- Electronics: 120 + 150 + 180 + 210 = 660
- Clothing: 80 + 100 + 120 + 140 = 440
- Home & Kitchen: 60 + 75 + 90 + 105 = 330
- Sports & Outdoors: 40 + 50 + 60 + 70 = 220
- Books & Media: 20 + 25 + 30 + 35 = 110
Step 2: Electronics has the highest total of 660 lakhs.
Answer: Electronics

Question 16

By what percentage did Clothing sales increase from Q1 to Q4?

Accepted Answer

Step 1: Q1 Clothing sales = 80 lakhs, Q4 Clothing sales = 140 lakhs.
Step 2: Increase = 140 - 80 = 60 lakhs.
Step 3: Percentage increase = (60/80) × 100 = 75%.
Answer: 75%

Question 17

What is the percentage increase in sales of Beta from Q1 to Q4?

Accepted Answer

Step 1: Q1 sales = 30 lakhs, Q4 sales = 45 lakhs. Step 2: Increase = 45 - 30 = 15 lakhs. Step 3: Percentage increase = (15 ÷ 30) × 100 = 50%.

Question 18

What is the total sales of Product A across all four quarters?

Accepted Answer

Step 1: Add sales of Product A for all quarters: 120 + 140 + 160 + 180 = 600 lakhs rupees.

Question 19

What is the total sales of Store A across all five months?

Accepted Answer

Step 1: Add all sales values for Store A across January to May.
Step 2: 45 + 50 + 55 + 60 + 65 = 275 lakhs.

Question 20

In Q2, what is the difference between total sales of Smartphones and Tablets combined versus Software and Accessories combined (in lakhs)?

Accepted Answer

Step 1: Smartphones + Tablets in Q2 = 150 + 75 = 225 lakhs
Step 2: Software + Accessories in Q2 = 60 + 50 = 110 lakhs
Step 3: Difference = 225 - 110 = 115 lakhs
Answer: 115 lakhs

Question 21

What is the ratio of total sales of Company A to total sales of Company C over all four years?

Accepted Answer

Step 1: Total sales of Company A = 120 + 150 + 180 + 240 = 690 lakhs. Step 2: Total sales of Company C = 80 + 100 + 140 + 175 = 495 lakhs. Step 3: Ratio = 690 : 495. Simplify by dividing both by 15 → 46 : 33. Answer: 46 : 33.

Question 22

What is the total sales revenue for the Clothing category across all four quarters?

Accepted Answer

Step 1: Add all quarterly sales for Clothing category.
Step 2: Q1 + Q2 + Q3 + Q4 = 80 + 100 + 120 + 140 = 440 lakhs.

Question 23

What is the ratio of Q2 sales of Home & Kitchen to Q2 sales of Sports?

Accepted Answer

Step 1: Q2 sales of Home & Kitchen = 75 lakhs.
Step 2: Q2 sales of Sports = 50 lakhs.
Step 3: Ratio = 75:50 = 3:2 (dividing both by 25).

Question 24

By what percentage did Smartphones sales increase from Q1 to Q4?

Accepted Answer

Step 1: Q1 sales = 120 lakhs, Q4 sales = 210 lakhs
Step 2: Increase = 210 - 120 = 90 lakhs
Step 3: Percentage increase = (90 ÷ 120) × 100 = 75%
Answer: 75%

Question 25

The sales of Company A in 2023 is what percentage more than the sales of Company E in 2022?

Accepted Answer

Step 1: Sales of Company A in 2023 = 240 lakhs. Step 2: Sales of Company E in 2022 = 160 lakhs. Step 3: Difference = 240 − 160 = 80 lakhs. Step 4: Percentage more = (80 / 160) × 100 = 50%. Answer: 50%.

Question 26

What is the percentage increase in sales of Company E from 2019 to 2022?

Accepted Answer

Step 1: Sales of Company E in 2019 = 100 Lakhs. Step 2: Sales of Company E in 2022 = 200 Lakhs. Step 3: Increase = 200 - 100 = 100 Lakhs. Step 4: Percentage increase = (100 / 100) × 100 = 100%. Answer: 100%.

Question 27

What is the average quarterly sales (in lakhs) for Laptops across all four quarters?

Accepted Answer

Step 1: Add all quarterly sales for Laptops: 80 + 100 + 120 + 140 = 440 lakhs
Step 2: Divide by number of quarters: 440 ÷ 4 = 110 lakhs
Answer: 110 lakhs

Question 28

What is the ratio of total sales of Company A to total sales of Company B over all four years?

Accepted Answer

Step 1: Total sales of Company A = 120 + 150 + 180 + 210 = 660. Step 2: Total sales of Company B = 200 + 240 + 220 + 280 = 940. Step 3: Ratio = 660 : 940. Simplify by dividing both by 20 → 33 : 47. Answer: 33 : 47.

Question 29

Which product category shows a consistent quarter-on-quarter growth of exactly 30 lakhs in each quarter?

Accepted Answer

Step 1: Check Smartphones: 150-120=30, 180-150=30, 210-180=30 ✓
Step 2: Check Laptops: 100-80=20, 120-100=20, 140-120=20 ✗
Step 3: Check Tablets: 75-60=15, 90-75=15, 105-90=15 ✗
Step 4: Check Accessories: 50-40=10, 60-50=10, 70-60=10 ✗
Step 5: Check Software: 60-50=10, 70-60=10, 80-70=10 ✗
Answer: Smartphones

Question 30

What is the percentage increase in sales of Epsilon from Q1 to Q4?

Accepted Answer

Step 1: Q1 sales of Epsilon = 60 lakhs, Q4 sales = 150 lakhs. Step 2: Increase = 150 - 60 = 90 lakhs. Step 3: Percentage increase = (90/60) × 100 = 150%.

Question 31

What is the ratio of Q4 sales of Alpha to Q4 sales of Gamma?

Accepted Answer

Step 1: Q4 sales of Alpha = 210 lakhs. Step 2: Q4 sales of Gamma = 140 lakhs. Step 3: Ratio = 210:140 = 3:2.

Question 32

By what percentage did Electronics sales increase from Q1 to Q4?

Accepted Answer

Step 1: Q1 sales = 120 lakhs, Q4 sales = 210 lakhs.
Step 2: Increase = 210 - 120 = 90 lakhs.
Step 3: Percentage increase = (90/120) × 100 = 75%.

Question 33

What is the ratio of total sales revenue of Alpha in 2020 and 2021 combined to the total sales revenue of Beta in 2022 and 2023 combined?

Accepted Answer

Step 1: Total sales of Alpha in 2020 and 2021 = 120 + 150 = 270 lakhs. Step 2: Total sales of Beta in 2022 and 2023 = 220 + 260 = 480 lakhs. Step 3: Required ratio = 270 : 480 = 9 : 16. Answer: 9 : 16

Question 34

In which year was the combined sales of Company B and Company E together the highest?

Accepted Answer

Step 1: Combined sales of B and E in each year — 2020: 200 + 100 = 300; 2021: 160 + 120 = 280; 2022: 220 + 160 = 380; 2023: 260 + 225 = 485. Step 2: The highest combined value is 485 in the year 2023. Answer: 2023.

Question 35

In which year was the total combined sales of all five companies the highest, and what was that total (in ₹ Lakhs)?

Accepted Answer

Step 1: Total sales in 2019 = 120 + 200 + 80 + 160 + 100 = 660 Lakhs. Step 2: Total sales in 2020 = 150 + 160 + 100 + 200 + 120 = 730 Lakhs. Step 3: Total sales in 2021 = 180 + 220 + 140 + 180 + 160 = 880 Lakhs. Step 4: Total sales in 2022 = 240 + 260 + 160 + 220 + 200 = 1080 Lakhs. Step 5: Highest total is in 2022 with ₹1080 Lakhs. Answer: 2022 with ₹1080 Lakhs.

Question 36

What is the average Q2 sales across all five companies?

Accepted Answer

Step 1: Q2 sales: Alpha = 150, Beta = 120, Gamma = 100, Delta = 140, Epsilon = 90. Step 2: Total = 150 + 120 + 100 + 140 + 90 = 600 lakhs. Step 3: Average = 600/5 = 120 lakhs.

Question 37

What is the average quarterly sales for Books across all four quarters?

Accepted Answer

Step 1: Sum of all Books sales = 20 + 25 + 30 + 35 = 110 lakhs.
Step 2: Average = 110 ÷ 4 = 27.5 lakhs.

Question 38

In Q3, which product category had sales equal to 50% of Electronics sales in that quarter?

Accepted Answer

Step 1: Electronics sales in Q3 = 180 lakhs.
Step 2: 50% of 180 = 90 lakhs.
Step 3: Check Q3 data: Home & Kitchen = 90 lakhs. This matches.

Question 39

What is the ratio of Q3 sales of Tablets to Q3 sales of Accessories?

Accepted Answer

Step 1: Q3 sales of Tablets = 90 lakhs
Step 2: Q3 sales of Accessories = 60 lakhs
Step 3: Ratio = 90 : 60 = 3 : 2 (dividing both by 30)
Answer: 3:2

Question 40

In 2022, the combined sales of Company A and Company D is what percentage of the combined sales of Company B and Company E in the same year?

Accepted Answer

Step 1: Combined sales of A and D in 2022 = 180 + 140 = 320. Step 2: Combined sales of B and E in 2022 = 220 + 260 = 480. Step 3: Percentage = (320 ÷ 480) × 100 = (2/3) × 100 = 66.67% ≈ 66⅔%. Answer: 66⅔%.

Question 41

The sales of Company B in 2021 is what percentage more or less than the sales of Company D in the same year?

Accepted Answer

Step 1: Sales of Company B in 2021 = 220 Lakhs. Step 2: Sales of Company D in 2021 = 180 Lakhs. Step 3: Difference = 220 - 180 = 40 Lakhs. Step 4: Percentage = (40 / 180) × 100 = 4000 / 180 = 22.22% ≈ 22.2%. Company B sales are 22.2% MORE than Company D. Answer: 22.2% more.

Question 42

By what percentage did the sales of Company D increase from 2020 to 2023?

Accepted Answer

Step 1: Sales of Company D in 2020 = 160 lakhs; in 2023 = 300 lakhs. Step 2: Increase = 300 − 160 = 140 lakhs. Step 3: Percentage increase = (140 / 160) × 100 = 87.5%. Answer: 87.5%.

Question 43

What is the average sales (in ₹ Lakhs) of Company C over all four years?

Accepted Answer

Step 1: Add the sales of Company C across all four years: 160 + 180 + 200 + 240 = 780. Step 2: Divide by the number of years (4): 780 ÷ 4 = 195. Answer: ₹195 Lakhs.

Question 44

In Q3, what is the difference between the combined sales of Electronics and Home & Kitchen and the combined sales of Books & Media and Sports & Outdoors?

Accepted Answer

Step 1: Electronics Q3 + Home & Kitchen Q3 = 320 + 180 = 500 lakhs
Step 2: Books & Media Q3 + Sports & Outdoors Q3 = 108 + 144 = 252 lakhs
Step 3: Difference = 500 - 252 = 248 lakhs
Answer: 248 lakhs

Question 45

What is the average quarterly sales of Home & Kitchen category for the entire year?

Accepted Answer

Step 1: Total sales of Home & Kitchen = 150 + 165 + 180 + 210 = 705 lakhs
Step 2: Average = 705 ÷ 4 = 176.25 lakhs
Answer: 176.25 lakhs

Question 46

In Q3, which product category's sales were closest to the average sales of all categories in that quarter?

Accepted Answer

Step 1: Calculate Q3 sales for each category: Electronics = 320, Clothing = 216, Home & Kitchen = 180, Sports & Outdoors = 156, Books & Media = 72
Step 2: Total Q3 sales = 320 + 216 + 180 + 156 + 72 = 944 lakhs
Step 3: Average Q3 sales = 944 ÷ 5 = 188.8 lakhs
Step 4: Find differences from average:
- Electronics: |320 - 188.8| = 131.2
- Clothing: |216 - 188.8| = 27.2
- Home & Kitchen: |180 - 188.8| = 8.8 (closest)
- Sports & Outdoors: |156 - 188.8| = 32.8
- Books & Media: |72 - 188.8| = 116.8
Answer: Home & Kitchen

Question 47

What is the ratio of total annual sales of Electronics to total annual sales of Books & Media?

Accepted Answer

Step 1: Calculate total annual sales for Electronics = 240 + 280 + 320 + 360 = 1200 lakhs
Step 2: Calculate total annual sales for Books & Media = 60 + 66 + 72 + 84 = 282 lakhs
Step 3: Find ratio = 1200 : 282 = 600 : 141 = 200 : 47
Answer: 200:47

Question 48

What is the average quarterly sales of Sports & Outdoors across all four quarters?

Accepted Answer

Step 1: Q1 + Q2 + Q3 + Q4 = 120 + 132 + 144 + 156 = 552 lakhs
Step 2: Average = 552 ÷ 4 = 138 lakhs
Answer: 138 lakhs

Question 49

By what percentage did Home & Kitchen sales increase from Q1 to Q4?

Accepted Answer

Step 1: Q1 sales = 150 lakhs, Q4 sales = 195 lakhs
Step 2: Increase = 195 - 150 = 45 lakhs
Step 3: Percentage increase = (45/150) × 100 = 30%
Answer: 30%

Question 50

By what percentage did the sales of Clothing category increase from Q1 to Q4?

Accepted Answer

Step 1: Q1 sales of Clothing = 180 lakhs
Step 2: Q4 sales of Clothing = 240 lakhs
Step 3: Increase = 240 - 180 = 60 lakhs
Step 4: Percentage increase = (60/180) × 100 = 33.33%
Answer: 33.33% or 33⅓%

Question 51

What is the ratio of total sales of Electronics in Q1 and Q2 combined to total sales of Clothing in Q3 and Q4 combined?

Accepted Answer

Step 1: Electronics Q1 + Q2 = 240 + 280 = 520 lakhs
Step 2: Clothing Q3 + Q4 = 216 + 234 = 450 lakhs
Step 3: Ratio = 520:450 = 52:45
Answer: 52:45

Question 52

Which company had the highest sales in Q4?

Accepted Answer

Step 1: Compare Q4 sales of all companies: Alpha = 70, Beta = 45, Gamma = 60, Delta = 35, Epsilon = 75. Step 2: Epsilon has the highest Q4 sales at 75 lakhs ₹.

Question 53

Which store had the lowest sales in February?

Accepted Answer

Step 1: Check February column for all stores.
Step 2: Store A = 50, Store B = 35, Store C = 65, Store D = 30, Store E = 45.
Step 3: Store D has the lowest value of 30 lakhs.

Question 54

What is the average monthly sales of Store B across all five months?

Accepted Answer

Step 1: Add all values for Store B: 30 + 35 + 40 + 45 + 50 = 200 lakhs.
Step 2: Divide by number of months: 200 ÷ 5 = 40 lakhs.

Question 55

By what percentage did Store A's sales increase from January to May?

Accepted Answer

Step 1: Store A's sales in January = 45 lakhs, in May = 70 lakhs.
Step 2: Increase = 70 - 45 = 25 lakhs.
Step 3: Percentage increase = (25/45) × 100 = 55.56% ≈ 55.6%.
Step 4: Rounding to nearest whole number = 56% (approximately).

Question 56

What is the total sales of Beta company across all four quarters?

Accepted Answer

Step 1: Add all quarterly sales of Beta: Q1 + Q2 + Q3 + Q4 = 30 + 35 + 40 + 45 = 150 lakhs ₹

Question 57

What is the total sales of Store C across all five months?

Accepted Answer

Step 1: Add all values for Store C across January to May.
Step 2: 60 + 65 + 70 + 75 + 80 = 350 lakhs rupees.

Question 58

What is the ratio of Delta's Q1 sales to Epsilon's Q1 sales?

Accepted Answer

Step 1: Delta's Q1 sales = 20 lakhs ₹. Step 2: Epsilon's Q1 sales = 60 lakhs ₹. Step 3: Ratio = 20 : 60 = 1 : 3.

Question 59

What is the difference between the total sales of Store C and Store D across all five months?

Accepted Answer

Step 1: Total sales of Store C = 60 + 65 + 70 + 75 + 80 = 350 lakhs.
Step 2: Total sales of Store D = 25 + 30 + 35 + 40 + 45 = 175 lakhs.
Step 3: Difference = 350 - 175 = 175 lakhs.

Question 60

What is the total sales of Store C across all five months?

Accepted Answer

Step 1: Add all sales values for Store C from January to May.
Step 2: 60 + 65 + 70 + 75 + 80 = 350 lakhs.

Question 61

Which store had the highest sales in March, and what was the amount?

Accepted Answer

Step 1: Compare March sales for all stores: Store A = 55, Store B = 40, Store C = 70, Store D = 35, Store E = 50.
Step 2: Store C has the highest sales in March with 70 lakhs.

Question 62

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

Accepted Answer

Step 1: Q1 sales = 40 lakhs ₹, Q4 sales = 70 lakhs ₹. Step 2: Increase = 70 - 40 = 30 lakhs ₹. Step 3: Percentage increase = (30 ÷ 40) × 100 = 75%.

Question 63

What is the average quarterly sales of Gamma company?

Accepted Answer

Step 1: Total sales of Gamma = 50 + 55 + 55 + 60 = 220 lakhs ₹. Step 2: Average = 220 ÷ 4 = 55 lakhs ₹.

Question 64

What is the ratio of Q2 sales of Gamma to Q2 sales of Delta?

Accepted Answer

Step 1: Q2 sales of Gamma = 55 lakhs. Step 2: Q2 sales of Delta = 25 lakhs. Step 3: Ratio = 55 : 25 = 11 : 5

AFCAT Bar Charts

AFCAT Bar Charts — Past Exam Questions

Bar Charts— Rules & Concept

Key Points to Remember

Exam-Specific Tips

Bar Charts — Practice Questions

60-Second Revision — Bar Charts