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. Microsoft

B. Soft

C. Micro

D. Mic

Answer: Option D

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

Share Report

Which of the following formulas is valid in MS Excel to find the highest value from cells A1 through A10?

A. =MAXIMUM(A1:A10)

B. =MAX(A1:A10)

C. =TOP(A1:A10)

D. =HIGH(A1:A10)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The native function name to extract the maximum number from a given range of cells in Excel is MAX.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, the 'IF' function falls under which category?

A. Logical

B. Information

C. Text

D. Statistical

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
IF is a logical function.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Word, the 'Draft' view shows the document with:

A. Web page preview

B. Outline structure

C. Full formatting and page layout

D. Minimal formatting, no page breaks

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Draft view (previously Normal view) shows the document with minimal formatting, does not show headers/footers or page breaks, and uses a continuous layout.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs