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. SEARCH()

C. FIND()

D. MATCH()

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 Excel, the function =IFERROR(A1/B1, "Error") returns "Error" if:

A. A1/B1 results in any error value

B. If B1 is zero

C. Only if #DIV/0!

D. If A1 is blank

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
IFERROR catches all error types and returns specified value.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, which function is used to convert a text string that looks like a number into a number?

A. NUMBER

B. CONVERT

C. VALUE

D. TEXT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The VALUE function converts a text string that represents a number into a numeric value. TEXT does the opposite.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, to sort records in ascending order in a query, use:

A. Group By

B. Both A and B

C. ORDER BY ASC in SQL

D. Ascending order in the Sort row of the query design grid

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Both design grid sort and SQL ORDER BY ASC work.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs