mcqs bucket

  • Excel Mcqs Questions | MCQs Bucket Largest Mcqs Website

    mcqsbucket

      Best guide for exams of all nature, Competitive exams and Interviews
Here is the MCQs guide for the topic of Excel. you will find various types of questions along with there answers in this
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.


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


Show Answer
Q. The process of arrenging the items of a column in some sequence or order is known as :
A.
Autofill
B.
Filtering
C.
Arrengin
D.
Sorting


Show Answer
Q. The Greater Than sign (>) is an example of _____ operator.
A.
Arithmatic
B.
Logical
C.
Greater
D.
Conditional


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.


Show Answer
Q. Which function in Excel checks whether a condition is true or not ?
A.
SUM
B.
COUNT
C.
IF
D.
AVERAGE


Show Answer
Q. Functions in MS Excel must begin with ___
A.
An () sign
B.
An Equal Sign
C.
A Plus Sign
D.
A > Sign


Show Answer
Q. Which one is not a Function in MS Excel ?
A.
SUM
B.
AVG
C.
MAX
D.
MIN


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


Show Answer
Q. Statistical calculations and preparation of tables and graphs can be done using
A.
Adobe Photoshop
B.
Excel
C.
Power Point
D.
Notepad


Show Answer