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

In Excel, which function would you use to find the position of 'at' in the text 'Education'?
A. FIND("at", "Education")
B. MATCH("at", "Education")
C. Both A and B
D. SEARCH("at", "Education")
Answer: Option C
Solution (By JKExamLibrary)
Both SEARCH and FIND return the starting position. 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
Which of the following field types in MS Access supports linking external multimedia structures, files, or objects created in third-party software applications directly into a table row?
A. Hyperlink
B. Calculated field type
C. OLE Object
D. Attachment

Correct Answer: Option C


Explanation:
OLE Object (Object Linking and Embedding) allows files like spreadsheets, images, sounds, or document structures created in external applications to be embedded inside Access databases.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In Excel, the function =LARGE(A1:A10, 2) returns:
A. The average of top two
B. The second largest value in the range
C. The smallest value
D. The largest value

Correct Answer: Option B


Explanation:
LARGE(array, k) returns k-th largest.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In MS PowerPoint, which view allows you to see all the slides in a presentation as thumbnails arranged in horizontal rows for easy reordering?
A. Slide Sorter View
B. Outline View
C. Presenter View
D. Reading View

Correct Answer: Option A


Explanation:
Slide Sorter View displays all slides in the presentation as miniature thumbnails, allowing users to easily reorder, delete, or organize slides into sections.

This question belongs to: Computer Microsoft Office