Home » webmcqs (page 23)

webmcqs

What does the VLOOKUP function do?

A. Finds related records
B. Looks up text that contain ‘v’
C. Checks whether text is the same in one cell as in the next
D. All of above

Option: C

You can use drag-and-drop to embed excel worksheet data in a word document

A. By dragging a range of excel data to the word button on the taskbar while pressing Shift key
B. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
C. By dragging a range of excel data to the word button on the taskbar while pressing Alt key
D. None of above

Option: B

VLOOKUP function used to?

A. Finds related records
B. Check if two cells are identical
C. Looks up text that contain “v”
D. None of above

Option: A