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