Question
The given bar graph shows the export of jute by a
company over the years 2011 to 2017. Which of the following pairs of years has the maximum percentage of decrease in export?Solution
To find the difference in each pair of years, 2011 - 2012 = 11.4 - 10.8 = 0.6 2012 - 2013 = 9.5 - 11.4 = - 1.9 2013 - 2014 = 9.9 - 9.5 = 0.4 2014 - 2015 = 7.8 - 9.9 = - 2.1 2015 - 2016 = 5.2 - 7.8 = - 2.6 2016 - 2017 = 6.5 - 5.2 = 1.3 Percentage Decrease = (Old Value - New Value)/Old Value x 100 From the above, we know that there was a decrease in export in the years 2012 - 2013, 2014 - 2015 and 2015 - 2016. In all these years, 2015 - 2016 has the maximum amount of decrease = -2.6/5.2 x 100 = 50% ∴ The maximum percentage of decrease in export was in the year 2015 - 2016.
Which Excel function is used to count the number of cells in a range that meet specified criteria?
Which of the following is the Shortcut key for Find?
The document can be zoom maximum upto
To make the selected text bold, the shortcut key is ____
In MS Excel 365, which of the following is an example of absolute reference pointing to cell A1?
Which formatting feature in MS Word 365, is used to emphasise text by making it bold, italic or underlined in documents?
Which of the following file format can be added to a PowerPoint show?
Turn on _____, which allows word to break lines between the syllables of words.
Which one of the following shortcut key is used to insert a page break?
Which shortcut key is used to center-align text in Microsoft Word?