Question
In Microsoft Excel, what does the function VLOOKUP
do?Solution
VLOOKUP searches for a value in a specified column and returns a corresponding value from another column. It is commonly used for looking up information in tables.
A certain sum at CI amounts to Rs 1800 in 3 yr and to Rs 2700 in 6 yr. Then the sum is ?
An amount is invested at a compound interest rate of 21% per annum, with compounding occurring once every 10 months. After 20 months, the interest earne...
Jaideep invested two equal sums at 12% simple interest p.a. for 8 years and 10 years respectively. If the difference in interest earned is Rs.14,...
- A sum of money grows to Rs. 2,800 in 3 years and Rs. 3,280 in 5 years under simple interest. What is the original principal amount?
A certain sum of money becomes 5 times of itself in 20 years at simple interest. In how many years does it become double of itself at the same rate of s...
A man invested Rs. 8,000 at simple interest of 'x%' p.a. and received Rs. 16,000 after 2 years. If he had invested Rs. 24,000 at simple interest of 'x%'...
A man deposited Rs. ‘x + 850’ at 12% per annum simple interest and earned Rs. 552 as interest after 2 years. Find the interest earned by him if he d...
The total investment by P and Q is Rs. 7500. P invests his amount at a simple interest rate of 30% per annum for 4 years, while Q invests his amount at ...
A and B started a business with initial investments of Rs. 28000 and Rs. 30000 respectively. After one year, a profit of Rs. 5800 is earned. A being a w...
A sum of money, invested for 8 years on 5% per annum simple interest, amounted to ₹287 on maturity.
What was the sun invested in?
Relevant for Exams:
