microsoft-excel-mcqs-set-2

Microsoft Excel MCQs - Questions and Answers | SET-2

Important Microsoft Excel Solved Multiple Choice Question with Answers

Welcome to our exclusive collections of Microsoft Excel MCQ Questions and with answers. All questions are of multiple choice type. In these MCQs sets we are going to share most important questions related to Microsoft Excel. These questions are very helpful for those candidates ans aspirants who are preparing for the various government and non government exam as well as in interview.These Mcqs are helpful in preparing exam like TET, CTET, Bank Clerical, BANK PO, AIPMT, PMT, Police exams ,army exams , CLAT, CMAT, CSIR, CTET, GATE, GMAT, General GRE, IAS, ICSE CDSE , SBI Clerk , SBIPO, PO, RRB , IELTS, IES, IEcoS, IFS, IGS, ISS, JEE, JEE Advanced, KVPY, LSAT, NDA, NEET, NEET PG, NEST, NSTSE, NTSE, Olympaid, PLAB, SAT, SSC CGL, GRE, TOEFL, UCO, UGC, USMLE, XAT, IBPS PO , PSc, State PSC, Patwari, Samvida, Teacher recruitment test, UPSC, SSC, CGL, SI, CTET, TET, CDS, MAT , SSC 10+2 , CLAT , NIFT , SBI , IBPS Clerk, Vyapam etc

Microsoft Excel MCQs - Questions and Answers | SET-2


Question 11-20

Question : 11

When the formula bar is active, you can see

[A].   The edit formula button
[B].   The cancel button
[C].   The enter button
[D].   All of the above


Question : 12

Each excel file is called a workbook because

[A].   It can contain text and data
[B].   It can be modified
[C].   It can contain many sheets including worksheets and chart sheets
[D].   You have to work hard to create it


Question : 13

You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

[A].   Pie chart
[B].   Row chart
[C].   Line chart
[D].   Column chart


Question : 14

You can use the drag and drop method to

[A].   Copy cell contents
[B].   Move cell contents
[C].   Add cell contents
[D].   [A] and [B]


Question : 15

When integrating word and excel, word is usually the

[A].   Server
[B].   Destination
[C].   Client
[D].   Both B and C


Question : 16

Which of the following is the latest version of Excel

[A].   Excel 2000
[B].   Excel 2002
[C].   Excel ME
[D].   Excel XP


Question : 17

A typical worksheet has …. Number of columns

[A].   128
[B].   256
[C].   512
[D].   1024


Question : 18

To create a formula, you first:

[A].   Select the cell you want to place the formula into
[B].   Type the equals sign (=) to tell Excel that you’re about to enter a formula
[C].   Enter the formula using any input values and the appropriate mathematical operators that make up your formula
[D].   Choose the new command from the file menu


Question : 19

When you link data maintained in an excel workbook to a word document

[A].   The word document cannot be edit
[B].   The word document contains a reference to the original source application
[C].   The word document must contain a hyperlink
[D].   The word document contains a copy of the actual data


Question : 20

Which of the following is a popular DOS based spreadsheet package?

[A].   Word
[B].   Smart cell
[C].   Excel
[D].   Lotus 1-2-3





To Read Next Set
Click on below links



Please Read These Useful Post Also
कृपया इन्हें भी पढ़ें


MCQs Practice Sets for Sure Success in all competitive exams



If you are planning to qualify teacher eligibility test, TET, CTET, all India state TET, JEE Main, NEET UG, AIPMT, AIIMS, AFMC, DPMT, BHU, IP MBBS, JIPMER, State PMT, MHT , you can practice these question papers online. We have taken all the necessary care to provide you with genuine question papers and the answers from reliable sources. Hope our labors server student’s community in better way.

Visit  http://examsuccessmaster.blogspot.com/  for a complete list of exam quizzes e.g. Child development, Psychlogy, Inclusive Education, Social Studies, physics || general science MCQ, Himachal pradesh Gk, chemistry, physics, Mathematics, math, General science, computer basics, old question papers, environmental studies,Geography, Polity Social Issue, Social Science complete study material,aptitude tests, Practice sets,HPTET,Engineering Interview, Civil Engineering, Mechanical Engineering, Electrical Engineering, most frequently asked,tests,HPTET Questions and Answers, Engineering Multiple choice, MCQ Questions on various subjects and topics and much more.

1 comment:

  1. Enjoyed reading the article above, really explains everything in detail, the article is very interesting and effective.

    Best Institute for Advanced Excel Training Institute in Delhi, India

    ReplyDelete