Which Excel function is used to find the position of a specific value within a range?

Microsoft Word (38) Microsoft Excel (22) Microsoft PowerPoint (23) Microsoft Access (5) HTML (61) Comptuer Hardware (37) Operating System (25) TSC (50) Software Engineering (4) Computer Network (11)

Microsoft Excel

Which Excel function is used to find the position of a specific value within a range?

FIND()
SEARCH()
POSITION()
MATCH()

341

Answer : D) MATCH()

The MATCH() function in Excel is used to find the position (or relative row or column number) of a specific value within a range

Join Discussion

Comment *

Please Login to Post a Comment

Sign in with Google

RELATED MCQS

Which ribbon tab in Excel contains tools for changing the font, font size, and font color of cell contents?

What is the purpose of the "Transpose" option in Excel?

Which of the following is not the correct method of editing the cell content?

Which Excel function is used to find the position of a specific value within a range?

What is the keyboard shortcut to create a default chart from the selected data in Excel?

In Excel, what does the formula "=SUM(A1:A5)" do?

Which command will you choose to convert a column of data into row?