Question
If you wished to limit what you would see on an Excel
worksheet, what data function would you use?Solution
(b); Filter is used in your Excel data, if you only want to display records that meet certain criteria.
A shopkeeper charges sales tax of x% up to Rs, 2000 and above it he charges y%. A customer pays a total tax of Rs. 320, when he purchases the goods wort...
- Sneha spent 18% of her income on donations and out of the remaining amount, she spent 22% on household expenses, 28% on shopping, 12% on transportation, an...
- In a tree plantation, 62% of the trees are pine trees. The number of oak trees is 45% of the pine trees, and the number of maple trees is 66% of the oak tr...
Out of 840 students in a college, the proportion of boys to girls is 3:4. In the midterm exam, 15% of boys and 10% of girls failed. How many students fa...
In an assembly election, a candidate got 60% of the total valid votes. 2% of the total votes were declared invalid. If the total number of voters is 126...
If 20% of a = b and then b is:
In a colony, there are 90 APL families and 46 BPL families. Each APL and BPL family got blankets equal to 25% and 75%, respectively of total number of f...
The boys and girls in a college are in the ratio 3:2. If 15% of the boys and 25% of the girls are adults, then adults are approximately how much % less ...
Income of A is 55% of the Income of B and A together. The saving of B is 32% of his Income and equals to Rs. 8100. Find the difference between the incom...
The income of ‘A’ increases by 20% every year. If the present income of ‘A’ is Rs. 17280 and his expenditure 2 years ago from now was Rs. 10000,...
