The MATCH function returns the relative position of a value in a range of cells. It is useful for locating data without retrieving the actual value. Knowledge Booster: 1. VLOOKUP retrieves data from a specific column. 2. CHOOSE selects a value based on index number. 3. MATCH is often paired with INDEX for advanced lookups. 4. Use MATCH for flexible and efficient data searches.
A shopkeeper bought article ‘A’ for Rs. ‘x’ and marked it 20% above its cost price and sold it for Rs. 3000. Marked price of article ‘B’ is ...
A dealer buys three different fruits A, B & C at the rate of Rs. 50, Rs. 40 and Rs. x per kg respectively. The quantity (by weight) of B bought by him i...
A loss of 15% is made by selling an article. Had it been sold for Rs.75 more, there would have been a profit of 10%. What would be the selling price of ...
If the price of rice has increased from Rs 40 per kg to Rs. 60 per kg, by how much percent a person has to decrease his consumption so that his expendit...
Mohan bought a new car from the showroom and after one year he sold it to Shyam at a profit of 20 percent. Shyam sold the same car to Sumit at the loss...
Article ‘P’, if sold at a profit of 15% earns a profit of Rs. 405. If article ‘P’ is marked 70% above its cost price and then sold after offerin...
A Shopkeeper gives 5 articles free on the purchase of every 15 articles. He also allow a discount of 20% to customer and still earn 20% profit. Find the...
A person invests ₹20,000 in a scheme that offers 20% profit in the first year and 25% profit in the second year(On total amount including interest). W...
Axe and Wye purchases the Bikes at same price and later on Zed purchase both the bikes at the same price of Rs. 72000. But the profit % of Axe was A% wh...
A shopkeeper sold an article at a discount of 11%. If he had given a discount of 6% in place of 11%, then he would have earned Rs. 112 more. If the cost...
