Microsoft Excel MCQ Questions & Answers

Microsoft Excel MCQs : This section focuses on "Microsoft Excel". These Multiple Choice Questions (MCQ) should be practiced to improve the Microsoft Technologies skills required for various interviews (campus interview, walk-in interview, company interview), placements, entrance exams and other competitive examinations.

1. _____________ is an electronic worksheet or spreadsheet application which is used for organizing, storing, and manipulating and analyzing data.

A. Microsoft Word
B. Microsoft Excel
C. Microsoft Silverlight
D. Microsoft Office

View Answer


2. The area where data is stored is known as ?

A. rows
B. columns
C. fields
D. cells

View Answer


3. Does each cell have unique address?

A. Yes
B. No
C. Can be yes or no
D. Can not say

View Answer


4. How many format cells options there?

A. 4
B. 5
C. 6
D. 7

View Answer


5. What is the use of Comments?

A. Comments are used to clarify the purpose of the cells
B. Comments are used to clarify a formula used in the cell
C. Comments are used to leave notes for others users about a cell
D. All of the above

View Answer


6. Which of the following is not a type of charts?

A. bar
B. cell
C. pie
D. scattter

View Answer


7. How many ways to protect a workbook in Excel?

A. 0
B. 1
C. 2
D. 3

View Answer


8. Freeze Panes are used to lock?

A. rows
B. column
C. Both A and B
D. None of the above

View Answer


9. ______________ is used to count any cell value containing numbers, text, logical values, etc.

A. COUNT
B. COUNTA
C. COUNTBLANK
D. COUNTIF

View Answer


10. Charts are used to enable graphical representation of the data in Excel.

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say

View Answer





Discussion


* You must be logged in to add comment.