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

In 2019, the table gives Mahindra = 219 and Maruti = 237. Write this as the ratio 219 : 237. The greatest common divisor of 219 and 237 is 3. Dividing both terms by 3 gives 73 : 79, the ratio in lowest terms.

The Maruti value was 106 in 2020 and 101 in 2021. Change = 101 – 106 = -5. Percentage change = (change / original value) x 100 = (-5 / 106) x 100 = -4.72%. Rounded, this is a 5% decrease from 2020 to 2021.

The total tourists visiting of Udaipur across all 5 rows is 967. Average = total divided by the number of rows. Average = 967 / 5 = 193.4. Check: 193.4 multiplied by 5 gives back approximately 967.

In 2020, the table lists a value for each of the 5 categories. The values are: Goa = 261, Kochi = 173, Shimla = 351, Udaipur = 379, Darjeeling = 397. Compare all 5 categories to find the smallest value. Kochi has the lowest value, at 173. So Kochi had the lowest tourists visiting in 2020.

The Darjeeling column has a value for each of the 5 years. The values are: 2019 = 462, 2020 = 397, 2021 = 116, 2022 = 233, 2023 = 85. Compare these values to find the largest one. The highest value is 462, in 2019. So the tourists visiting of Darjeeling was highest in 2019.

The Darjeeling column in the table has one value for each year. Reading down the column, the values are 462, 397, 116, 233 and 85. Add all 5 values together: 462 + 397 + 116 + 233 + 85 = 1293. So the total tourists visiting of Darjeeling is 1293.

First add each row across its 5 categories to get a row total. The row totals are 2019 = 921, 2020 = 1561, 2021 = 672, 2022 = 710, 2023 = 690. Add these 5 row totals together: 921 + 1561 + 672 + 710 + 690 = 4554. So the grand total tourists visiting across all years and categories is 4554.

In 2023, the table lists a value for each of the 5 categories. The values are: Goa = 121, Kochi = 199, Shimla = 33, Udaipur = 252, Darjeeling = 85. Compare all 5 categories to find the largest value. Udaipur has the highest value, at 252. So Udaipur had the highest tourists visiting in 2023.

The Nova Textiles column has a value for each of the 5 years. The values are: 2019 = 427, 2020 = 499, 2021 = 243, 2022 = 84, 2023 = 432. Compare these values to find the largest one. The highest value is 499, in 2020. So the revenue earned of Nova Textiles was highest in 2020.

In 2020, the table gives Metro Traders = 456 and Nova Textiles = 499. To find the difference, subtract the smaller value from the larger one. Nova Textiles is larger, so difference = 499 – 456 = 43. Check: 456 + 43 = 499, which matches Nova Textiles’s value.

The Sunrise Corp value was 358 in 2022 and 448 in 2023. Change = 448 – 358 = 90. Percentage change = (change / original value) x 100 = (90 / 358) x 100 = 25.14%. Rounded, this is a 25% increase from 2022 to 2023.

First add each row across its 5 categories to get a row total. The row totals are 2019 = 1564, 2020 = 1821, 2021 = 1619, 2022 = 860, 2023 = 1504. Add these 5 row totals together: 1564 + 1821 + 1619 + 860 + 1504 = 7368. So the grand total revenue earned across all years and categories is 7368.

The total revenue earned of all categories in 2023 is 1504. Average = total divided by the number of categories. Average = 1504 / 5 = 300.8. Check: 300.8 multiplied by 5 gives back approximately 1504.

In 2019, the table gives Infotech Ltd = 414 and Sunrise Corp = 301. Percentage formula: (Infotech Ltd / Sunrise Corp) x 100. (414 / 301) x 100 = 137.54%. Rounded to the nearest whole number, that is 138%.

The total tourists visiting of all categories in 2016 is 952. Average = total divided by the number of categories. Average = 952 / 5 = 190.4. Check: 190.4 multiplied by 5 gives back approximately 952.

The Jaipur value was 396 in 2016 and 308 in 2017. Change = 308 – 396 = -88. Percentage change = (change / original value) x 100 = (-88 / 396) x 100 = -22.22%. Rounded, this is a 22% decrease from 2016 to 2017.

In 2016, the table gives Kochi = 83 and Ooty = 193. Write this as the ratio 83 : 193. The greatest common divisor of 83 and 193 is 1. Dividing both terms by 1 gives 83 : 193, the ratio in lowest terms.

The total tourists visiting of Jaipur across all 5 rows is 1150. Average = total divided by the number of rows. Average = 1150 / 5 = 230. Check: 230 multiplied by 5 gives back exactly 1150.

In 2018, the table lists a value for each of the 5 categories. The values are: Jaipur = 77, Kochi = 246, Ooty = 116, Shimla = 166, Manali = 244. Compare all 5 categories to find the largest value. Kochi has the highest value, at 246. So Kochi had the highest tourists visiting in 2018.

In Q4, the table gives Biography = 75 and Non-Fiction = 29. Write this as the ratio 75 : 29. The greatest common divisor of 75 and 29 is 1. Dividing both terms by 1 gives 75 : 29, the ratio in lowest terms.

The total books sold of Children’s across all 5 rows is 410. Average = total divided by the number of rows. Average = 410 / 5 = 82. Check: 82 multiplied by 5 gives back exactly 410.

In Match 4, the table gives Manoj = 83 and Vikram = 94. Percentage formula: (Manoj / Vikram) x 100. (83 / 94) x 100 = 88.30%. Rounded to the nearest whole number, that is 88%.

In Match 4, the table lists a value for each of the 5 categories. The values are: Rohit = 63, Arjun = 134, Vikram = 94, Manoj = 83, Rahul = 120. Compare all 5 categories to find the largest value. Arjun has the highest value, at 134. So Arjun had the highest runs scored in Match 4.

In Match 5, the table lists a value for each of the 5 categories. The values are: Rohit = 101, Arjun = 114, Vikram = 39, Manoj = 76, Rahul = 139. Compare all 5 categories to find the smallest value. Vikram has the lowest value, at 39. So Vikram had the lowest runs scored in Match 5.

The Vikram column in the table has one value for each match. Reading down the column, the values are 40, 16, 67, 94 and 39. Add all 5 values together: 40 + 16 + 67 + 94 + 39 = 256. So the total runs scored of Vikram is 256.