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.
A rectangular garden is bordered by a walkway of uniform width 5 metres. If the total area of the walkway is 1350 m², find the perimeter of the actual ...
If a triangle with base 6 cm has the same area as a circle with radius 6 cm, then the corresponding altitude (in cm) of the triangle is:Â
The perimeter of a rhombus is 52 m and its height is 7 m. Its area is:
- 'A hall has a floor covered with rectangular tiles, each measuring 90 cm by 50 cm. The hall’s dimensions are 720 cm in length and 3 meters in width. Find...
- The base area of a rectangular cistern is 1080 m², and it holds a volume of 32400 m³ of water. What is the depth of the water in the cistern?
A solid hemisphere of radius 6 cm is melted and recast into small solid right circular cones each of radius 3 cm and height 8 cm. How many cones are for...
The perimeter of a rectangular field is 60 metres and its area is 137.5 m2 . What is the length of the diagonal of this field?
The volume of a rectangular tank is 1680 m³, and the ratio of its length, width, and height is 7:6:5, respectively. What is the length of the rectangul...
Four cubes, each having a side of 6 cm, are placed next to each other in a straight line. What will be the total surface area of the resulting cuboid?
Two wires A and B are made of the same material and have the same length but different cross-sectional areas. If the resistance of wire A is 9 times the...
