In Excel, which function is used to find the position of a substring within a string? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to find the position of a substring within a string?

A. Both A and B

B. POSITION

C. SEARCH

D. FIND

Answer: Option A

Solution (By JKSSB Mock Tests)

FIND and SEARCH both return the position of a substring; FIND is case-sensitive, SEARCH is not. Both are valid.

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

What is the shortcut key to insert a new slide in MS PowerPoint?

A. Ctrl + D

B. Ctrl + M

C. Ctrl + N

D. Ctrl + Shift + N

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+M inserts a new slide. Ctrl+N creates a new presentation. Ctrl+D duplicates slide.

This question belongs to: Computer Microsoft Office

Question #2

In MS Excel, what type of cell reference style is used when a formula contains a cell formatted as $C$5?

A. Mixed Cell Reference

B. Relative Cell Reference

C. Absolute Cell Reference

D. External sheet reference link

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
An absolute cell reference locks both the column letter and the row number with dollar signs ($C$5), ensuring that the reference does not change when the formula is copied to another cell.

This question belongs to: Computer Microsoft Office

Question #3

What does the VLOOKUP function do in Excel?

A. Returns the current date and time

B. Counts the number of cells that meet a condition

C. Searches for a value in the first column of a table and returns a value in the same row from a specified column

D. Rounds a number to a specified number of digits

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
VLOOKUP looks up a value vertically. It searches down the first column and returns a value from another column in that row.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs