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

In Excel, which function is used to find the position of a substring within a string?
A. SEARCH
B. POSITION
C. FIND
D. Both A and B
Answer: Option D
Solution (By JKExamLibrary)
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

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error
In PowerPoint, the shortcut to open the 'Set Up Slide Show' dialog is:
A. Shift + F5
B. Ctrl + Shift + S
C. F5
D. Alt + S, T (ribbon shortcut)

Correct Answer: Option D


Explanation:
No direct single key; Alt+S, T is the key tip sequence.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In PowerPoint, the 'Animations' tab contains:
A. Transitions and timings
B. Entrance, Emphasis, Exit, Motion Paths
C. Chart animations
D. Slide layouts

Correct Answer: Option B


Explanation:
Animations tab for object animations.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In MS Word, which specialized feature must be activated to allow footnotes to automatically maintain separate, distinct numbering streams across different chapters?
A. Section Break
B. Style Separator
C. Bookmark
D. Page Break

Correct Answer: Option A


Explanation:
Section breaks divide a document into independent parts with their own formatting, headers, footers, margins, and footnote/endnote numbering properties.

This question belongs to: Computer Microsoft Office