In Excel, what is the result of the formula =LEFT(Microsoft,3)? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, what is the result of the formula =LEFT(Microsoft,3)?

A. Mic

B. Soft

C. Micro

D. Microsoft

Answer: Option A

Solution (By JKSSB Mock Tests)

LEFT extracts a specified number of characters from the left side of a text string. LEFT(Microsoft,3) returns Mic.

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 tab in MS Word contains the 'Page Borders' option?

A. Layout

B. Design

C. Home

D. Insert

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Page Borders is found under the Design tab (formerly Page Layout) in the Page Background group. In newer versions it's under Design.

This question belongs to: Computer Microsoft Office

Question #2

Which of the following view layouts in MS PowerPoint is specifically optimized for reviewing presentation slides sequentially as a continuous reading text book script?

A. Slide Show view

B. Notes Page structural mode

C. Reading View

D. Master Designer interface

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Reading View runs the presentation inside a resizable system window with basic control buttons, making it ideal for checking layout flows without entering a full-screen projection.

This question belongs to: Computer Microsoft Office

Question #3

What is the maximum length of a field name in MS Access?

A. 128 characters

B. 32 characters

C. 255 characters

D. 64 characters

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Access field names can be up to 64 characters.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs