In MS Excel, what is the value returned by the formula =MID(COMPETITIVE, 4, 3)? MCQ with Answer and Explanation

In MS Excel, what is the value returned by the formula =MID(COMPETITIVE, 4, 3)?
A. ETI
B. PETI
C. COMP
D. PET
Answer: Option D
Solution (By JKSSB Mock Tests)
The MID function extracts characters from the middle of a text string. Starting at position 4 of COMPETITIVE ('P') and extracting 3 characters yields PET.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
What is the shortcut key to create a new presentation in MS PowerPoint?
A. Ctrl + N
B. Ctrl + S
C. Ctrl + M
D. Ctrl + O

Correct Answer: Option A


Explanation:
Ctrl + N creates a new blank presentation. Ctrl + M inserts a new slide. Ctrl + O opens a presentation. Ctrl + S saves.

This question belongs to: Computer Microsoft Office
Question #2
Which data type field property option in MS Access lets you create a drop-down choice list that pulls options either from an existing table source or a hardcoded value set?
A. Lookup Wizard
B. Calculated Field choice
C. Hyperlink Field Type
D. Attachment properties

Correct Answer: Option A


Explanation:
The Lookup Wizard establishes a lookup field that displays a clean dropdown list of choices derived dynamically from another database table reference or static list parameter.

This question belongs to: Computer Microsoft Office
Question #3
In MS Word, the 'Draft' view shows the document with:
A. Web page preview
B. Outline structure
C. Minimal formatting, no page breaks
D. Full formatting and page layout

Correct Answer: Option C


Explanation:
Draft view (previously Normal view) shows the document with minimal formatting, does not show headers/footers or page breaks, and uses a continuous layout.

This question belongs to: Computer Microsoft Office