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. Which among following is types of excel data types ?

Numbers, Formulas, Labels
Data, Words, Numbers
Words, Number, Labels
Equations, Data, Numbers

Answer: Option A

2. In Paste Special dialog box, which of the following option is not available ?

Divide
Add
Subtract
Square root

Answer: Option D

3. What is shortcut to enter current date in cell in excel ?

Ctrl + ;
Alt + ;
Shift + &
Ctrl + $

Answer: Option A

4. With which of the following all formulas in excel starts ?

/
*
$
=

Answer: Option D

5. How do you change column width to fit the contents ?

Single-click the boundary to the left to the column heading
Double click the boundary to the right of the column heading
Press Alt and single click anywhere in the column
All of above

Answer: Option B

Read more from - MS Excel Questions Answers