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. FIND

B. Both A and B

C. SEARCH

D. POSITION

Answer: Option B

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

Share Report

Which of the following is a correct order to apply custom animation to an object in PowerPoint?

A. Insert tab -> Animation

B. Animations tab -> Add Animation -> select object

C. Select object -> Animations tab -> Add Animation

D. Design tab -> Animate

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
First select the object, then add animation from the Animations tab.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What is the shortcut key to insert a hyperlink in MS Word?

A. Ctrl + I

B. Ctrl + K

C. Ctrl + L

D. Ctrl + H

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + K inserts a hyperlink in Word, Excel, and PowerPoint.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What type of macro recording language is natively embedded under the advanced automation layers of Microsoft Excel and Word?

A. Visual Basic for Applications (VBA)

B. Python Automation Scripts

C. C++ Backend Libraries

D. JavaScript Object Framework

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
VBA (Visual Basic for Applications) is the standard programming language used to write, record, and execute automation macros across MS Office applications.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs