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
Ans : B
Explanation: Microsoft Excel is an electronic worksheet or spreadsheet application which is used for organizing, storing, and manipulating and analyzing data. It is developed by Microsoft.
2. The area where data is stored is known as ?
A. rows
B. columns
C. fields
D. cells
View Answer
Ans : D
Explanation: The area where data is stored is known as cell.
3. Does each cell have unique address?
A. Yes
B. No
C. Can be yes or no
D. Can not say
View Answer
Ans : A
Explanation: Yes, each cell has a unique address depends on the row and column value of the cell.
4. How many format cells options there?
A. 4
B. 5
C. 6
D. 7
View Answer
Ans : C
Explanation: A cell can be formatted by using the format cells options. There are 6 format cells options: Number, Alignment, Font, Border, Fill and Protection.
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
Ans : D
Explanation: All of the above are the use of Comments.
6. Which of the following is not a type of charts?
A. bar
B. cell
C. pie
D. scattter
View Answer
Ans : B
Explanation: Cell is not a type of charts
7. How many ways to protect a workbook in Excel?
A. 0
B. 1
C. 2
D. 3
View Answer
Ans : D
Explanation: There are three ways to protect a workbook in Excel: Password protection for opening a workbook, Protection for adding, deleting, hiding and unhiding sheets and protection from changing size or position of windows.
8. Freeze Panes are used to lock?
A. rows
B. column
C. Both A and B
D. None of the above
View Answer
Ans : C
Explanation: Freeze Panes are used to lock any row or column. The locked row or column will be visible on the screen even after we scroll the sheet vertically or horizontally.
9. ______________ is used to count any cell value containing numbers, text, logical values, etc.
A. COUNT
B. COUNTA
C. COUNTBLANK
D. COUNTIF
View Answer
Ans : B
Explanation: COUNTA or Count All is used to count any cell value containing numbers, text, logical values, etc. any type of value excluding blanks.
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
Ans : A
Explanation: True, Charts are used to enable graphical representation of the data in Excel.
Discussion