easyFPSCNTSCSSPPSCMS Office & Productivity
Answer explanation
Explanation included
Practice quiz ready
Continue practising this MCQ topic
Use these links to review the full topic, start a timed quiz, or open the exam hub connected with this question.
Related MS Office & Productivity MCQs
View all1In Ms Excel Ready made templates are available under _______ tab ?2What Power point feature will you use to apply motion effects to different objects of a slide ?3You can edit existing Excel data by pressing the:________ key?4To go to a specific location in a document we use :5You can edit an embedded organization chart object by_______________?6Which of the following is not a way to create a new presentation?
Answer and explanation
Correct Answer: A: VLOOKUP retrieve data base on specified criteria from the most left column of the table, searching vertically down for a specified value.
Explanation: The correct answer is A: VLOOKUP retrieves data based on specified criteria from the most left column of the table, searching vertically down for a specified value. The 'V' stands for vertical, meaning it searches down the first column of a table array. It then returns a value from the same row in a column you specify.
Continue practice
More MS Office & Productivity MCQs with answers
Use these links to review related questions, practise the full topic, or open the exam preparation pages connected with this MCQ.
Related questions
- In Ms Excel Ready made templates are available under _______ tab ?
- What Power point feature will you use to apply motion effects to different objects of a slide ?
- You can edit existing Excel data by pressing the:________ key?
- To go to a specific location in a document we use :
- You can edit an embedded organization chart object by_______________?
- Which of the following is not a way to create a new presentation?