In MS Excel, what is the value returned by the formula =MID(COMPETITIVE, 4, 3)?
A. PETI
B. PET
C. COMP
D. ETI
Answer: Option B
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.
Explanation:
The MAX function returns the largest numeric value in a range. LARGE can return the nth largest, MAXA includes logical values, MAXIFS finds max based on criteria.
No comments yet. Be the first to start the discussion!