Exam Tiger
APTITUDE TESTS - MENTAL ABILITY - SOLVED OBJECTIVE MCQ SETS - QUESTION ANSWER - PDF STUDY MATERIALS - SHORTCUT TIPS

Microsoft Excel

MS Excel Questions Answers (MCQ -Multiple Choice, Objective Type) Online test : Microsoft Excel is a spreadsheet software and is part of the widely used MS Office Package. Here you will find a great collection of Multiple Choice (MCQ)Questions in the category of Microsoft Excel with answer. Most of the questions are applicable to all versions of MS Excel (including Excel 97-2003, XP, 2007, 2010, etc.). Sometimes question from this category are asked as part of the computer operation general knowledge section of basic computer awareness test.

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.


INSTRUCTION: CLICK ON THE OPTION (A, B, C, D) TO MARK YOUR ANSWER.


Q.

What is the intersection of a column and a row on a worksheet called ?

A.
Column
B.
Value

C.
Address
D.
Cell


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


Show Answer
Q.

Which functionin Excel tells how many numeric entries are there ?

A.
NUM
B.
COUNT

C.
SUM
D.
CHKNUM


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


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


Show Answer



Advertisement


eXTReMe Tracker