Tabulation: Formulas, Shortcuts and Solved Examples — MCQs with Answers (Set 2)

Look at the row for Match 2 in the table. It has one value for each of the 5 categories: 91, 38, 115, 60 and 54. Add all 5 values together: 91 + 38 + 115 + 60 + 54 = 358. So the total runs scored of all categories in Match 2 is 358.

The total employees working of Support across all 5 rows is 1513. Average = total divided by the number of rows. Average = 1513 / 5 = 302.6. Check: 302.6 multiplied by 5 gives back approximately 1513.

In 2018, the table lists a value for each of the 5 categories. The values are: Logistics = 411, R&D = 184, HR = 164, IT = 292, Support = 307. Compare all 5 categories to find the smallest value. HR has the lowest value, at 164. So HR had the lowest employees working in 2018.

The HR column in the table has one value for each year. Reading down the column, the values are 280, 164, 260, 284 and 77. Add all 5 values together: 280 + 164 + 260 + 284 + 77 = 1065. So the total employees working of HR is 1065.

In 2018, the table lists a value for each of the 5 categories. The values are: Logistics = 411, R&D = 184, HR = 164, IT = 292, Support = 307. Compare all 5 categories to find the largest value. Logistics has the highest value, at 411. So Logistics had the highest employees working in 2018.

The Logistics column has a value for each of the 5 years. The values are: 2017 = 69, 2018 = 411, 2019 = 155, 2020 = 194, 2021 = 384. Compare these values to find the largest one. The highest value is 411, in 2018. So the employees working of Logistics was highest in 2018.

In 2018, the table gives Tea = 41 and Sugar = 51. To find the difference, subtract the smaller value from the larger one. Sugar is larger, so difference = 51 – 41 = 10. Check: 41 + 10 = 51, which matches Sugar’s value.

The total quantity exported of all categories in 2017 is 720. Average = total divided by the number of categories. Average = 720 / 5 = 144. Check: 144 multiplied by 5 gives back exactly 720.

In 2014, the table gives Spices = 160 and Rice = 48. Percentage formula: (Spices / Rice) x 100. (160 / 48) x 100 = 333.33%. Rounded to the nearest whole number, that is 333%.

The total employees working of all categories in 2013 is 1717. Average = total divided by the number of categories. Average = 1717 / 5 = 343.4. Check: 343.4 multiplied by 5 gives back approximately 1717.

The Finance value was 147 in 2016 and 50 in 2017. Change = 50 – 147 = -97. Percentage change = (change / original value) x 100 = (-97 / 147) x 100 = -65.99%. Rounded, this is a 66% decrease from 2016 to 2017.

In 2015, the table gives Finance = 302 and HR = 375. Write this as the ratio 302 : 375. The greatest common divisor of 302 and 375 is 1. Dividing both terms by 1 gives 302 : 375, the ratio in lowest terms.

The total employees working of Sales across all 5 rows is 1919. Average = total divided by the number of rows. Average = 1919 / 5 = 383.8. Check: 383.8 multiplied by 5 gives back approximately 1919.

In Q3, the table lists a value for each of the 5 categories. The values are: Poetry = 115, Fiction = 50, Academic = 75, Biography = 114, Comics = 96. Compare all 5 categories to find the largest value. Poetry has the highest value, at 115. So Poetry had the highest books sold in Q3.

In Q2, the table lists a value for each of the 5 categories. The values are: Poetry = 83, Fiction = 185, Academic = 51, Biography = 135, Comics = 66. Compare all 5 categories to find the smallest value. Academic has the lowest value, at 51. So Academic had the lowest books sold in Q2.

The Manoj column in the table has one value for each match. Reading down the column, the values are 118, 89, 104, 92 and 24. Add all 5 values together: 118 + 89 + 104 + 92 + 24 = 427. So the total runs scored of Manoj is 427.

In Match 3, the table gives Rohit = 107 and Manoj = 104. To find the difference, subtract the smaller value from the larger one. Rohit is larger, so difference = 107 – 104 = 3. Check: 104 + 3 = 107, which matches Rohit’s value.

In Match 3, the table lists a value for each of the 5 categories. The values are: Vikram = 81, Aditya = 106, Manoj = 104, Rohit = 107, Karan = 34. Compare all 5 categories to find the smallest value. Karan has the lowest value, at 34. So Karan had the lowest runs scored in Match 3.

Look at the row for Match 3 in the table. It has one value for each of the 5 categories: 81, 106, 104, 107 and 34. Add all 5 values together: 81 + 106 + 104 + 107 + 34 = 432. So the total runs scored of all categories in Match 3 is 432.

In Match 5, the table gives Rohit = 137 and Karan = 43. Write this as the ratio 137 : 43. The greatest common divisor of 137 and 43 is 1. Dividing both terms by 1 gives 137 : 43, the ratio in lowest terms.

The total books sold of Biography across all 5 rows is 243. Average = total divided by the number of rows. Average = 243 / 5 = 48.6. Check: 48.6 multiplied by 5 gives back approximately 243.

The Biography column has a value for each of the 5 quarters. The values are: Q1 = 55, Q2 = 39, Q3 = 15, Q4 = 66, Q5 = 68. Compare these values to find the largest one. The highest value is 68, in Q5. So the books sold of Biography was highest in Q5.

In Match 5, the table lists a value for each of the 5 categories. The values are: Rahul = 22, Suresh = 57, Aditya = 10, Karan = 74, Vikram = 44. Compare all 5 categories to find the largest value. Karan has the highest value, at 74. So Karan had the highest runs scored in Match 5.

The Karan column has a value for each of the 5 matchs. The values are: Match 1 = 98, Match 2 = 122, Match 3 = 112, Match 4 = 137, Match 5 = 76. Compare these values to find the largest one. The highest value is 137, in Match 4. So the runs scored of Karan was highest in Match 4.

In Match 3, the table gives Karan = 112 and Rahul = 35. To find the difference, subtract the smaller value from the larger one. Karan is larger, so difference = 112 – 35 = 77. Check: 35 + 77 = 112, which matches Karan’s value.