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

In Match 2, the table gives Arjun = 81 and Rahul = 99. To find the difference, subtract the smaller value from the larger one. Rahul is larger, so difference = 99 – 81 = 18. Check: 81 + 18 = 99, which matches Rahul’s value.

In 2017, the table gives Cotton = 181 and Spices = 159. To find the difference, subtract the smaller value from the larger one. Cotton is larger, so difference = 181 – 159 = 22. Check: 159 + 22 = 181, which matches Cotton’s value.

In 2020, the table lists a value for each of the 5 categories. The values are: Sugar = 85, Coffee = 167, Tea = 74, Spices = 124, Cotton = 46. Compare all 5 categories to find the smallest value. Cotton has the lowest value, at 46. So Cotton had the lowest quantity exported in 2020.

Look at the row for 2019 in the table. It has one value for each of the 5 categories: 25, 137, 189, 196 and 65. Add all 5 values together: 25 + 137 + 189 + 196 + 65 = 612. So the total quantity exported of all categories in 2019 is 612.

In 2018, the table gives Coffee = 21 and Sugar = 39. Write this as the ratio 21 : 39. The greatest common divisor of 21 and 39 is 3. Dividing both terms by 3 gives 7 : 13, the ratio in lowest terms.

The Sugar value was 152 in 2017 and 39 in 2018. Change = 39 – 152 = -113. Percentage change = (change / original value) x 100 = (-113 / 152) x 100 = -74.34%. Rounded, this is a 74% decrease from 2017 to 2018.

Look at the row for 2020 in the table. It has one value for each of the 5 categories: 54, 86, 201, 108 and 111. Add all 5 values together: 54 + 86 + 201 + 108 + 111 = 560. So the total quantity exported of all categories in 2020 is 560.

The total quantity exported of Spices across all 5 rows is 703. Average = total divided by the number of rows. Average = 703 / 5 = 140.6. Check: 140.6 multiplied by 5 gives back approximately 703.

In 2023, the table lists a value for each of the 5 categories. The values are: Coffee = 170, Wheat = 52, Spices = 119, Jute = 171, Rice = 63. Compare all 5 categories to find the smallest value. Wheat has the lowest value, at 52. So Wheat had the lowest quantity exported in 2023.

The Jute column has a value for each of the 5 years. The values are: 2019 = 50, 2020 = 108, 2021 = 181, 2022 = 117, 2023 = 171. Compare these values to find the largest one. The highest value is 181, in 2021. So the quantity exported of Jute was highest in 2021.

The Jute column in the table has one value for each year. Reading down the column, the values are 51, 57, 153, 125 and 118. Add all 5 values together: 51 + 57 + 153 + 125 + 118 = 504. So the total quantity exported of Jute is 504.

First add each row across its 5 categories to get a row total. The row totals are 2017 = 502, 2018 = 483, 2019 = 517, 2020 = 764, 2021 = 744. Add these 5 row totals together: 502 + 483 + 517 + 764 + 744 = 3010. So the grand total quantity exported across all years and categories is 3010.

In 2020, the table lists a value for each of the 5 categories. The values are: Jute = 125, Wheat = 162, Tea = 177, Coffee = 92, Rice = 208. Compare all 5 categories to find the largest value. Rice has the highest value, at 208. So Rice had the highest quantity exported in 2020.

The Wheat column has a value for each of the 5 years. The values are: 2017 = 150, 2018 = 200, 2019 = 42, 2020 = 162, 2021 = 206. Compare these values to find the largest one. The highest value is 206, in 2021. So the quantity exported of Wheat was highest in 2021.

In 2021, the table gives Rice = 168 and Coffee = 163. To find the difference, subtract the smaller value from the larger one. Rice is larger, so difference = 168 – 163 = 5. Check: 163 + 5 = 168, which matches Rice’s value.