In MS Excel, what is the value returned by the formula =MID(COMPETITIVE, 4, 3)?
A. PETI
B. COMP
C. ETI
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.
Explanation:
No direct single shortcut; you can use Alt+P, S, P. Or from Page Layout tab. I'll ask: Which tab contains Page Setup group? Answer: Page Layout. So I'll adjust.
Which keyboard shortcut allows an operator to insert an automatic line break inside an individual cell grid without moving the active cursor down into a new cell box in MS Excel?
Explanation:
Pressing Alt + Enter inserts a manual line break (starts a new line of text) inside the current cell, automatically enabling text wrapping.
No comments yet. Be the first to start the discussion!