Microsoft Excel Solved MCQs | SET-21

Microsoft Excel MCQs - Questions and Answers | SET-21

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-21


Question 201-210

Question : 201

You can not link excel worksheet data to a word document.

[A].   With the right drag method
[B].   With a hyperlink
[C].   With the copy and paste special commands
[D].   With the copy and paste button on the standard toolbar


Question : 202

When a label is too long to fit withing a worksheet cell, you typically must

[A].   Shorten the label
[B].   Increase the column width
[C].   Decrease the column width
[D].   Adjust the row height


Question : 203

A box that identifies the patterns or colors assigned to the data series ..

[A].   Data Label
[B].   Data Marker
[C].   Data Series
[D].   Legend


Question : 204

Which area in an Excel windows allows entering values and formulas

[A].   Title bar
[B].   Menu bar
[C].   Formula bar
[D].   Standard toolbar


Question : 205

The ChartWizard term data categories refers to

[A].   A chart plot area
[B].   A horizontal axis
[C].   The organization of individual values with a chart’s data series
[D].   The data range that supplies chart data


Question : 206

Which of the following is used to copy the contents and formats of the bottom cell or cells of a selected range into the cells to the right.

[A].   Fill Left
[B].   Fill Up
[C].   Fill Right
[D].   Fill Down


Question : 207

Name box locate on ..

[A].   Left size of formula bar
[B].   Right side of formula bar
[C].   Center of formula bar
[D].   None of the above


Question : 208

A circular reference is

[A].   Geometric modeling tool
[B].   A cell that points to a drawing object
[C].   A formula that either directly or indirectly depends on itself
[D].   Always erroneous


Question : 209

A group of related data points plotted in a chart that originates from rows or columns on a single worksheet.

[A].   Data Label
[B].   Data Marker
[C].   Data Series
[D].   Legend


Question : 210

Data can be arranged in a worksheet in an easy to understand manner using ..

[A].   Auto Formatting
[B].   Applying styles
[C].   Changing fonts
[D].   All of the above





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.

No comments:

Post a Comment