Question
Which of the following functions in MS Excel 365 is used
to search for an item in a range of cells and then return the relative position of that item in the range?Solution
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.
- The average value of the property of Dev, Riya and Tanmay is Rs. 87 lacs. The value of the property of Dev is Rs. 33 lacs less than that of Riya, and Rs. 1...
There are five containers in a truck hold. The weight of the first container is 100 kg and the weight of the second container is 20% higher than the wei...
Sachin Tendulkar's average runs over 40 innings was 52. During his subsequent four innings, he scored 55, 42, 0, and 60 runs. To increase his average to...
A park has an average of 140 visitors on Sundays and 80 on other day. The average number of visitors in a month of 30 days starting with Sunday is
The average income of a group of 30 freelancers is Rs. 500. If 3 freelancers earning an average of Rs. 550 leave the group and 1 freelancer earning Rs. ...
Average weight of all the people in a group is 65 kg. When two people of weight 72 kg and 84 kg left the group, average weight reduces by 1 kg. Find the...
The average age of a group of 9 teachers is 50 years. When the principal retires, the average age of the remaining teachers drops to 45 years. Find the ...
The average age of R, S, T and U is 32 years and the average age of R and S is also 32 years. If U is 4 years older than T, then determine the age of T.
Average of 8 numbers is 50. If average of first four and last two numbers is 40 and 35, respectively then find the fifth number given that ratio of fift...
5 positive numbers are written on a piece of paper. Sum of first 3 numbers is 70 and ratio of the 4th and the 5th number is 2:3. If difference between t...
