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

MS Excel (Microsoft Office Excel)

MS Excel under Microsoft Office Questions Answers (MCQ -Multiple Choice, Objective Type) Online test : Microsoft Excel, part of Microsoft Office bundle, is a spreadsheet software and is part of the widely used MS Office Package. Here you will find a great collection of Multiple Choice 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 (Microsoft Office Excel) Multiple Choice (MCQ) objective question with answer keys

Here you will find a list of common important questions on ms excel (microsoft office excel) in multiple choice question (MCQ) style with answer. These frequently asked sample questions are given with correct choice of answer that you can check instantly. Presently we have added total 5 sets of questions on ms excel (microsoft office 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.

The following section consists of objective multiple choice questions (mcq) on ms excel (microsoft office excel) with answers.


INSTRUCTION: CLICK ON THE OPTION (A, B, C, D) TO SELECT IT AS 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 vaues 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