Correct Answer: =INDEX(MATCH())
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Excel Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Excel MCQ Questions
The Char() formula does the reverse of which worksheet formula?
How would you summarize sales data in a PivotTable by product name?
If a cell contains a value that does not begin with the correct operator, Excel evaluates it as...
Which Windows Keyboard Shortcut unhides any hidden rows within the selection.
What command reveals which cells must contain data for the function in the currently selected cell to work?
To show the actual formula instead of Cell Values which function can be used?
Tables offer following advantages?
What will be displayed if custom format is [>8/15/16]'OVERDUE!';mm/dd/yy and cell contains 8/23/2016?
Which one of the following get displayed if custom numeric format is set as follows and cell has 123456? 'Acct'# 00-0000;;;;'Don't enter dash'
If cell A2 has a full name (Fristname, Middle Initial and Lastname) like 'Karen E. McRich' which of the following formula will extract the lastname?