Which of the following is a valid Excel function to find the position of a substring (case-insensitive)? MCQ with Answer and Explanation

Question Report Error

Which of the following is a valid Excel function to find the position of a substring (case-insensitive)?

A. MATCH()

B. INSTR()

C. FIND()

D. SEARCH()

Answer: Option D

Solution (By JKExamLibrary)

SEARCH is case-insensitive. FIND is case-sensitive.

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 MS Word, the 'Ctrl + Alt + D' shortcut inserts:

A. A document property

B. An endnote

C. A footnote

D. A date

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
Ctrl+Alt+D inserts endnote.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

Which of the following is NOT a valid slide layout in MS PowerPoint?

A. Multi-Column

B. Section Header

C. Title Slide

D. Title and Content

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
PowerPoint has built-in layouts like Title Slide, Title and Content, Section Header, Comparison, etc. There is no 'Multi-Column' standard layout, though you can create columns manually.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

What is the shortcut to select all text in a document in MS Word?

A. Shift + Home

B. Ctrl + A

C. Ctrl + F5

D. Ctrl + S

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
Ctrl+A selects all.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs