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. COMP
C. PET
D. PETI
Answer: Option C
Solution (By JKExamLibrary)
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.

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
What is the maximum zoom percentage scale allowed natively in Microsoft Word?
A. 500%
B. 400%
C. 1000%
D. 200%

Correct Answer: Option A


Explanation:
MS Word allows a maximum document zoom scale of 500%, whereas MS Excel and PowerPoint are capped at 400%.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In Excel, the function =ISBLANK(A1) returns:
A. TRUE only if A1 contains a formula returning empty
B. Both A and B
C. TRUE if A1 is empty, FALSE otherwise
D. FALSE if A1 has a space

Correct Answer: Option B


Explanation:
ISBLANK returns TRUE if cell is empty. A cell with a space is not empty, so FALSE.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In Excel, to create a drop-down list in a cell, use:
A. Conditional Formatting -> List
B. Data Validation -> List
C. Home -> Sort & Filter
D. Insert -> Drop-down

Correct Answer: Option B


Explanation:
Data Validation with List restriction creates a drop-down.

This question belongs to: Computer Microsoft Office