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

Question

Share Report Error

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

A. INSTR()

B. FIND()

C. SEARCH()

D. MATCH()

Answer: Option C

Solution (By JKSSB Mock Tests)

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

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 MS Word, the 'Format Painter' tool is found on which tab?

A. Home

B. Insert

C. Design

D. Layout

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Format Painter is located in the Clipboard group on the Home tab. It copies formatting from one selection and applies it to another.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, what is the maximum number of characters in a Short Text field?

A. 1 GB

B. 256

C. 64000

D. 255

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Short Text holds up to 255 characters.

This question belongs to: Computer Microsoft Office

Question #3

In PowerPoint, the 'Design Ideas' feature suggests:

A. Animation effects

B. Professional layouts and design options for slides

C. Slide master edits

D. Transition timings

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Design Ideas (Office 365) provides automatic design suggestions.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs