Question Detail

VLOOKUP function used to ?

Finds related records
Looks up text that contain "v"
Check if two cells are identical
None of above

Answer: Option A

Similar Questions :

1. When creating a vertical page break ?

The active cell must be in row 1
The active cell must be A1
The active cell must be in row 10
The active cell must be in column A

Answer: Option A

2. If you press ___, the cell accepts your typing as its contents ?

Tab
Ctrl+Enter
Enter
Alt+Enter

Answer: Option C

3. Which types of charts can excel produce ?

Line graphs and pie charts only
Bar charts, line graphs and pie charts
Bar charts and line graphs only
Only line graphs

Answer: Option B

4. Which shortcut can be used to Switch between open workbooks ?

Ctrl + F2
Ctrl + F6
Ctrl + F8
Ctrl + F10

Answer: Option B

5. On an excel sheet the active cell in indicated by ?

A dotted border
A dark wide border
A blinking border
By italic text

Answer: Option B

Read more from - MS Excel Questions Answers