Microsoft Excel Basic MCQs (Short Quiz)
This is the quiz about basics of Microsoft Office Excel. Students and new learner's can test their knowledge
1. In excel, the intersection of a row and a column is called ----
Column
Value
Cell
Address
Correct Answer
Wrong Answer
2. Which chart is useful for comparing values over categories?
Line Chart
Column Chart
Dot Graph
Pie Chart
Correct Answer
Wrong Answer
3. ----- function in Excel tells the number of numeric entries .
NUM
SUM
COUNT
CHKNUM
Correct Answer
Wrong Answer
4. According to specified criteria , which feature displays only the data in column (s)?
Filtering
Formula
Sorting
Pivot
Correct Answer
Wrong Answer
5. Which can be used in statistical calculations and preparation of tables and graph?
Notepad
Adobe Photoshop
Excel
Power Point
Correct Answer
Wrong Answer
6. Which is appear in the bottom of the Excel window?
Name box
Title bar
Worksheet tabs
Formula bar
Correct Answer
Wrong Answer
7. ------ of the following is not a term pertaining to spreadsheets.
Character
Cell
Browser
Formula
Correct Answer
Wrong Answer
8. What are the basic rectangular building blocks of a spreadsheet?
Help button
Cells
Zoom slider
All of these
Correct Answer
Wrong Answer
9. A pre programmed formula in Excel is also known as ----
Graph
Range
Cell
Function
Correct Answer
Wrong Answer
10. -------- of the following identifies a cell in Excel.
Address
Name
Formula
Label
Correct Answer
Wrong Answer
11. ------ of the following Excel charts represents only one value for each variable.
Line
Bar
Function
Pie
Correct Answer
Wrong Answer
12. ------ term is used to join the selected cells in to one cell.
Merge
Pivot
Filter
Wrap
Correct Answer
Wrong Answer
13. ----- is the extension of saved file in MS Excel.
.xls
.xks
.xbs
.xos
Correct Answer
Wrong Answer
14. ----- command is used to close the window of Excel.
Ctrl + W
Ctrl + C
Ctrl + R
Alt + F4
Correct Answer
Wrong Answer
15. ------ is the total region surrounding the chart.
Plot area
Chart area
Legend
Clipart area
Correct Answer
Wrong Answer
What's Your Reaction?
