In Excel, which formula will return '5' from the text 'Excel5'? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which formula will return '5' from the text 'Excel5'?

A. =LEFT("Excel5",1)

B. =LEN("Excel5")

C. =RIGHT("Excel5",1)

D. =MID("Excel5",2,1)

Answer: Option C

Solution (By JKSSB Mock Tests)

RIGHT with 1 character returns '5'. LEFT returns 'E', MID could return 'x'.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

Which of the following is a 'view' available for slides in PowerPoint?

A. Slide Sorter

B. Normal

C. Outline

D. All of these

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
All are views.

This question belongs to: Computer Microsoft Office

Question #2

What is the shortcut key to open the 'Page Setup' dialog in MS Excel?

A. Alt + P, S, P

B. Ctrl + P

C. F5

D. Ctrl + Shift + P

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Alt+P,S,P opens Page Setup in Excel. Ctrl+Shift+P is not standard. Ctrl+P is Print. F5 is Go To.

This question belongs to: Computer Microsoft Office

Question #3

What will be the output of the MS Excel formula =LARGE(A1:A4, 2) if cell records carry A1=10, A2=50, A3=30, and A4=40?

A. 30

B. 50

C. #VALUE!

D. 40

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The LARGE function returns the k-th largest value in a dataset range. Sorting the range {10, 50, 30, 40} in descending order gives {50, 40, 30, 10}, where the 2nd largest value is 40.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs