D) JULI case
) 20% decreaseD ) 20% increase
11. Manoj's expenditure forms 60% of his total income. If his income increases by 20% and
expenditure increased by 10% then find the percentage change in his savings?
A) 35% decrease B) 35% increase C) 20% decrease D 20% increase
12 Thema
Answers
Answer:
If you want to find out what part of the total a few different products make, add up the results returned by several SUMIF functions, and then divide that number by the total. For example, the following formula calculates the percent of cherries and apples:
=(SUMIF(A2:A9, "cherries", B2:B9) + SUMIF(A2:A9, "apples", B2:B9)) / $B$10
For more information about the SUM function, please check out the following tutorials:
How to use the SUMIF function in Excel
Excel SUMIFS and SUMIF with multiple criteria
How to calculate percent change in Excel
Of all formulas for calculating percentage in Excel, a percent change formula is probably the one you would use most often.
Excel formula for percentage change (percentage increase / decrease)
To calculate percent change between values A and B, use the following formula:
Percent Change = (B - A) / A
When applying this formula to real data, it is important that you correctly determine which value is A and which is B. For example, yesterday you had 80 apples and how you have 100, meaning that now you have 20 apples more than before, which is 25% increase. If you had 100 apples and now you have 80, your number of apples has reduced by 20, which is 20% decrease.
Answer:
B)35%increase is answer