Question
Which Excel function is used to count the number of
cells within a range that meet a single specified criterion?Solution
COUNTIF
If the SP of book is 5 times of the discount. If percentage discount and percentage profit is equal. Then find the ratio of discount and CP?
The ratio between two numbers is 7:8. If each number is increased by 9, the ratio between then become 10:11, find the difference between numbers.
If ₹19,500 is divided among ‘A’, ‘B’, ‘C’, and ‘D’ in the ratio 6:8:5:7, then find the share of ‘C’.
...
The total number of phones to the total number of laptops in Stores A and B is in the ratio 120:13. Additionally, the number of laptops in Store A to t...The ratio of number of balls in bags A & B is 3:4. Seven Balls are taken from bag B and are dropped in bag A, number of balls are equal in each bag now...
- In class ‘D’, the number of girls is 50% of the number of boys. Class ‘E’ has 30% less number of boys than in class ‘D’ and 50% more total stud...
<p><p>A, B and C entered into a partnership by investing in the ratio of 7:4:5. At the end of the year, the total profit is in the r...
A reduction in number of workers in the ratio of 9 : 13 and an increment of wages in the ratio 23 : 21, then the total wage is increased by?
A and B together can complete a job in 12 days. A alone can complete it in 20 days. In how many days can B alone complete it? Also, in what ratio should...
A is thrice as efficient as B and C is twice as efficient as B. What is the ratio of number of days taken by A, B and C when they work individually?
