In Excel, the function =VLOOKUP(102, A2:C10, 2, FALSE) searches for 102 in: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the function =VLOOKUP(102, A2:C10, 2, FALSE) searches for 102 in:

A. The first column of the range A2:C10

B. The second column

C. The entire range

D. The row 102

Answer: Option A

Solution (By JKSSB Mock Tests)

VLOOKUP searches the first column of the table_array.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1

In Excel, which function calculates the number of cells that contain numbers in a range?

A. SUM()

B. COUNT()

C. COUNTA()

D. COUNTIF()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
COUNT counts numeric cells. COUNTA counts non-empty cells of any type.

This question belongs to: Computer Microsoft Office

Question #2

In PowerPoint, the shortcut to open the 'Set Up Slide Show' dialog is:

A. Shift + F5

B. Ctrl + Shift + S

C. F5

D. Alt + S, T (ribbon shortcut)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
No direct single key; Alt+S, T is the key tip sequence.

This question belongs to: Computer Microsoft Office

Question #3

In MS Word, to create a table by drawing, use:

A. Home -> Table

B. Insert -> Table -> Draw Table

C. Layout -> Draw Table

D. Design -> Table -> Draw

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Insert tab -> Table -> Draw Table.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs