MS Excel MCQ Question with Answer
Here you will find a list of common important questions on microsoft excel in MCQ quiz style with answer for competitive exams and interviews. These frequently asked sample questions on MS Excel are given with correct choice of answer that you can check instantly. Presently we have added total 5 sets of questions on microsoft excel for you to practice. We will keep adding more questions and provide this question bank in PDF format, so that you can download them instantly in E-book style.
Following section consists of some important multiple choice questions (mcq) on microsoft excel with answers.
TEST INSTRUCTION: CLICK OPTION (A, B, C, D) TO SEE ANSWER.
|
| Q. | In Excel, Rows are labelled as ______
A.
A, B, C, etc
B.
1,2,3 etc
C.
A1, A2, etc.
D.
$A$1, $A$2, etc.
Answer : Option B
Show Answer |
| Q. | What do you use to create a chart?
A.
Pie Wizard
B.
Excel Wizard
C.
Data Wizard
D.
Chart Wizard
Answer : Option D
Show Answer |
| Q. | How will you graphically represent expenditure in different departments ?
A.
Column Chart
B.
Line Chart
C.
Pie Chart
D.
Dot Chart
Answer : Option C
Show Answer |
| Q. | What type of chart is good for single series of data ?
A.
Column Chart
B.
Line Chart
C.
Pie Chart
D.
Cone Chart
Answer : Option C
Show Answer |
| Q. | The basic unit of a worksheet into which you enter data in Excel is called a
A.
cell
B.
table
C.
box
D.
column
Answer : Option A
Show Answer |
| Q. | The Greater Than sign (>) is an example of _____ operator.
A.
Arithmatic
B.
Logical
C.
Conditional
D.
Greater
Answer : Option B
Show Answer |
| Q. | What type of chart is useful for showing trends or changes over time ?
A.
Pie Chart
B.
Column Chart
C.
Line Chart
D.
Dot Graph
Answer : Option C
Show Answer |
| Q. | The process of arrenging the items of a column in some sequence or order is known as :
A.
Arrengin
B.
Autofill
C.
Sorting
D.
Filtering
Answer : Option C
Show Answer |
| Q. | The ____ feature of MS Excel quickly completes a series of data
A.
Auto Complete
B.
Auto Fill
C.
Fill Handle
D.
Sorting
Answer : Option B
Show Answer |
| Q. | What type of chart is useful for comparing parts of a whole ?
A.
Pie Chart
B.
Column Chart
C.
Line Chart
D.
Dot Graph
Answer : Option A
Show Answer |
| Q. | What type of chart will you use to compare performance of two employees in the year 2016 ?
A.
Column Chart
B.
Line Chart
C.
Pie Chart
D.
Dot Chart
Answer : Option B
Show Answer |
| Q. | Which one is not a Function in MS Excel ?
A.
SUM
B.
AVG
C.
MAX
D.
MIN
Answer : Option B
Show Answer |
| Q. | Functions in MS Excel must begin with ___
A.
An () sign
B.
An Equal Sign
C.
A Plus Sign
D.
A > Sign
Answer : Option B
Show Answer |
| Q. | Which functionin Excel checks whether a condition is true or not ?
A.
SUM
B.
COUNT
C.
IF
D.
AVERAGE
Answer : Option C
Show Answer |
| Q. | In Excel, Columns are labelled as ___
A.
A, B, C, etc
B.
1,2,3 etc
C.
A1, A2, etc.
D.
$A$1, $A$2, etc.
Answer : Option A
Show Answer |
| Q. | What is the intersection of a column and a row on a worksheet called ?
A.
Column
B.
Value
C.
Address
D.
Cell
Answer : Option D
Show Answer |
| Q. | What type of chart is useful for comparing values over categories ?
A.
Pie Chart
B.
Column Chart
C.
Line Chart
D.
Dot Graph
Answer : Option B
Show Answer |
| Q. | Which functionin Excel tells how many numeric entries are there ?
A.
NUM
B.
COUNT
C.
SUM
D.
CHKNUM
Answer : Option B
Show Answer |
| Q. | A features that displays only the data in column (s) according to specified criteria
A.
Formula
B.
Sorting
C.
Filtering
D.
Pivot
Answer : Option C
Show Answer |
| Q. | Statistical calculations and preparation of tables and graphs can be done using
A.
Adobe Photoshop
B.
Excel
C.
Notepad
D.
Power Point
Answer : Option B
Show Answer |
0 Comments