In Excel, which function would you use to find the position of 'at' in the text 'Education'? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function would you use to find the position of 'at' in the text 'Education'?

A. MATCH("at", "Education")

B. FIND("at", "Education")

C. SEARCH("at", "Education")

D. Both A and B

Answer: Option D

Solution (By JKSSB Mock Tests)

Both SEARCH and FIND return the starting position. 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 Access, which of the following is a valid way to set a primary key?

A. Both A and B

B. Set in Datasheet View

C. Right-click the field in Design View and select Primary Key

D. Use the Primary Key button in Design View

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
You can set primary key by right-clicking or clicking the Primary Key button in Design View.

This question belongs to: Computer Microsoft Office

Question #2

What is the shortcut to open the 'Replace' dialog in MS Excel?

A. F5

B. Ctrl + H

C. Ctrl + R

D. Ctrl + F

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+H for Replace.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, which function returns the year from a date?

A. DAY()

B. YEAR()

C. YEARFRAC()

D. MONTH()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
YEAR(serial_number) returns year.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs