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 row 102

B. The second column

C. The first column of the range A2:C10

D. The entire range

Answer: Option C

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

Share Report

Which field type in an MS Access table automatically generates a brand new sequential or randomized number every time a new row is appended?

A. OLE Object

B. Number

C. AutoNumber

D. Calculated

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The AutoNumber data type automatically inserts a unique, incremented numeric value whenever a new record is added to the table database.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Access, to import data from an Excel file, you can use:

A. Database Tools -> Import

B. Create tab -> Table from Excel

C. External Data tab -> Import Excel

D. Home tab -> Get External Data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The External Data tab provides import and link options.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Access, which property defines the pattern for data entry (like phone number)?

A. Validation Rule

B. Default Value

C. Input Mask

D. Format

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Input Mask controls entry format.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs