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

In Excel, what is the result of the formula =LEFT(Microsoft,3)?
A. Mic
B. Micro
C. Microsoft
D. Soft
Answer: Option A
Solution (By JKExamLibrary)
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

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error
In MS Word, to view two parts of a document simultaneously, use:
A. Window -> New Window
B. Both A and B
C. Review -> Compare
D. View -> Split

Correct Answer: Option B


Explanation:
Split divides one window into two panes; New Window opens a second window of same document.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In Access, which of the following is a valid data type for storing yes/no values?
A. Boolean
B. Yes/No
C. Logical
D. All of the above

Correct Answer: Option B


Explanation:
The data type in Access is called 'Yes/No' (or sometimes 'Boolean' in other databases). Access uses Yes/No. So B is correct.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In MS Word, which feature allows you to create a list of captions for figures, tables, and equations?
A. Index
B. Table of Figures
C. Table of Contents
D. Bibliography

Correct Answer: Option B


Explanation:
Table of Figures generates a list of figures based on captions. Captions are inserted for figures.

This question belongs to: Computer Microsoft Office