Question
If the sales of Product C increase by 50% and the sales
of Product D decrease by 20%, what will be the new total sales of all products combined? A pie chart shows the distribution of total sales (in ₹1,200,000) among four products: Product A, Product B, Product C, and Product D.Solution
First, calculate the sales for each product based on the given percentages. Sales for Product A = 40% of ₹1,200,000 = (40 / 100) × ₹1,200,000 = ₹480,000. Sales for Product B = 30% of ₹1,200,000 = (30 / 100) × ₹1,200,000 = ₹360,000. Sales for Product C = 20% of ₹1,200,000 = (20 / 100) × ₹1,200,000 = ₹240,000. Sales for Product D = 10% of ₹1,200,000 = (10 / 100) × ₹1,200,000 = ₹120,000. Now, calculate the new sales amounts after the changes: New sales for Product C = ₹240,000 + (50% of ₹240,000) = ₹240,000 + ₹120,000 = ₹360,000. New sales for Product D = ₹120,000 - (20% of ₹120,000) = ₹120,000 - ₹24,000 = ₹96,000. Now, calculate the new total sales: New total sales = Sales of Product A + Sales of Product B + New sales of Product C + New sales of Product D = ₹480,000 + ₹360,000 + ₹360,000 + ₹96,000 = ₹1,296,000. Correct Answer: d) ₹1,296,000
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?