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

2. Which chart is useful for comparing values over categories?

Line Chart
Column Chart
Dot Graph
Pie Chart

3. ----- function in Excel tells the number of numeric entries .

NUM
SUM
COUNT
CHKNUM

4. According to specified criteria , which feature displays only the data in column (s)?

Filtering
Formula
Sorting
Pivot

5. Which can be used in statistical calculations and preparation of tables and graph?

Notepad
Adobe Photoshop
Excel
Power Point

6. Which is appear in the bottom of the Excel window?

Name box
Title bar
Worksheet tabs
Formula bar

7. ------ of the following is not a term pertaining to spreadsheets.

Character
Cell
Browser
Formula

8. What are the basic rectangular building blocks of a spreadsheet?

Help button
Cells
Zoom slider
All of these

9. A pre programmed formula in Excel is also known as ----

Graph
Range
Cell
Function

10. -------- of the following identifies a cell in Excel.

Address
Name
Formula
Label

11. ------ of the following Excel charts represents only one value for each variable.

Line
Bar
Function
Pie

12. ------ term is used to join the selected cells in to one cell.

Merge
Pivot
Filter
Wrap

13. ----- is the extension of saved file in MS Excel.

.xls
.xks
.xbs
.xos

14. ----- command is used to close the window of Excel.

Ctrl + W
Ctrl + C
Ctrl + R
Alt + F4

15. ------ is the total region surrounding the chart.

Plot area
Chart area
Legend
Clipart area