Which of the following functions in MS Excel is used to find the relative position of a specified item within a given range of cells? MCQ with Answer and Explanation

Question

Which of the following functions in MS Excel is used to find the relative position of a specified item within a given range of cells?

A. MATCH

B. INDEX

C. OFFSET

D. VLOOKUP

Answer: Option A

Solution (By JKSSB Mock Tests)

The MATCH function searches for a specified value in a cell range and returns the relative row or column position of that item.

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

In Word, which of the following is used to create a watermark?

A. Design > Watermark

B. Review > Watermark

C. Insert > Watermark

D. Page Layout > Watermark

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Watermark is under the Design tab (or Page Layout in older).

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Word, which of the following is used to create a table of authorities?

A. View > Table of Authorities

B. References > Table of Authorities

C. Insert > Table of Authorities

D. Review > Table of Authorities

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Table of Authorities is in the References tab, used for legal citations.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In PowerPoint, the 'Animations' tab contains:

A. Transitions and timings

B. Chart animations

C. Slide layouts

D. Entrance, Emphasis, Exit, Motion Paths

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Animations tab for object animations.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs