In Excel, the function =MID("EXAMINATION",4,3) returns: MCQ with Answer and Explanation

In Excel, the function =MID("EXAMINATION",4,3) returns:
A. EXA
B. INA
C. AMI
D. MIN
Answer: Option D
Solution (By JKSSB Mock Tests)
MID starting at position 4 for length 3: characters 4='A',5='I',6='N'? Wait, EXAMINATION: 1 E,2 X,3 A,4 M,5 I,6 N,7 A,8 T,9 I,10 O,11 N. So position 4 is M, so string M, I, N -> MIN. Yes.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS Access, a 'query' object is used to:
A. Retrieve, filter, and perform calculations on data from tables
B. Store data
C. Automate repetitive tasks
D. Print formatted output

Correct Answer: Option A


Explanation:
Queries manipulate data.

This question belongs to: Computer Microsoft Office
Question #2
In Excel, which function is used to calculate the number of days between two dates?
A. DATEDIF
B. All of the above
C. DAYS
D. NETWORKDAYS

Correct Answer: Option B


Explanation:
DAYS, DATEDIF, and NETWORKDAYS all can calculate days between dates (NETWORKDAYS counts working days). So all are valid.

This question belongs to: Computer Microsoft Office
Question #3
In PowerPoint, what is the purpose of the 'Slide Show' tab?
A. To review spelling
B. To insert media
C. To set up and control slide show settings, rehearsals, and monitors
D. To design slides

Correct Answer: Option C


Explanation:
Slide Show tab manages presentation delivery.

This question belongs to: Computer Microsoft Office