In Excel, the function to return the position of a substring within a string is: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the function to return the position of a substring within a string is:

A. Both A and B

B. MATCH()

C. FIND()

D. SEARCH()

Answer: Option A

Solution (By JKSSB Mock Tests)

Both FIND and SEARCH return the starting position of a substring. FIND is case-sensitive, SEARCH is not. MATCH is for ranges.

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 Word, which of the following is used to create a mail merge?

A. Mailings > Start Mail Merge

B. References > Mail Merge

C. Insert > Mail Merge

D. Review > Mail Merge

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Mail Merge is under the Mailings tab.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, which function returns the current date and time?

A. TIME()

B. TODAY()

C. DATE()

D. NOW()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
NOW() returns serial number of current date and time. TODAY() returns date only. DATE(year,month,day) constructs a date.

This question belongs to: Computer Microsoft Office

Question #3

In PowerPoint, which key can be used to zoom in on a slide during editing?

A. Alt + Plus

B. Ctrl + Plus (+)

C. Both A and B

D. Ctrl + Mouse wheel up

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Plus or Ctrl+Scroll up zooms in.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs