Administrative Professional (CAP) · Question
In Microsoft Excel, what is the 'VLOOKUP' function primarily used for?
VLOOKUP (Vertical Lookup) is an Excel function designed to search for a value in the first column of a table and return a corresponding value from another colum
Start free practice for Administrative Professional (CAP)
200 questions · no signup required · 40 free questions per day
Question: In Microsoft Excel, what is the 'VLOOKUP' function primarily used for?
Answer options:
- To count the number of cells that contain numbers ✅ To look up and retrieve data from a specific column in a table
- To calculate the sum of values in a vertical range
- To validate data entry in a column
Correct answer: To look up and retrieve data from a specific column in a table
Explanation: VLOOKUP (Vertical Lookup) is an Excel function designed to search for a value in the first column of a table and return a corresponding value from another column in the same row.
Start free practice for Administrative Professional (CAP)
200 questions · no signup required · 40 free questions per day
More about Administrative Professional (CAP)
Related Questions
- Which tab in Microsoft PowerPoint is used to apply predefined animation effects to individual objects on a sli
- When writing an internal memo, what tone is generally most appropriate?
- What is the primary purpose of a 'register' in records management?
- Which of the following is an example of an open-ended question?
- What is the purpose of using 'track changes' in Microsoft Word?
- In Microsoft PowerPoint, what feature allows you to display your slides on a projector while viewing your note
More for Administrative Professional (CAP) candidates
FAQs
Question explanations
- Which tab in Microsoft PowerPoint is used to apply predefined animation effects to individual objects on a sli
- When writing an internal memo, what tone is generally most appropriate?
- What is the primary purpose of a 'register' in records management?
- Which of the following is an example of an open-ended question?
Ready to practice?
Free, no signup required. Build a wrong-question list as you go.
Start Free Administrative Professional (CAP) Practice →Related courses
Other Canadian certifications candidates often prepare for alongside this one.