Microsoft Excel Solved MCQs | SET-20

Microsoft Excel MCQs - Questions and Answers | SET-20

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


Question 191-200

Question : 191

Which of the following is NOT in sheet

[A].   Tab Color
[B].   Rename
[C].   Hide
[D].   All


Question : 192

You can enter which types of data into worksheet cells?

[A].   Labels, values and formulas
[B].   Labels and values but not formulas
[C].   Values and formulas but not labels
[D].   Formulas only


Question : 193

Concatenation of text can be done using ..

[A].   Apostrophe(‘)
[B].   Exclamation(!)
[C].   Hash(#)
[D].   Ampersand(&)


Question : 194

To drag a selected range of data to another worksheet in the same workbook, use the ?

[A].   Ctrl key
[B].   Shift key
[C].   Alt key
[D].   Tab key


Question : 195

Which of the following is available in Formula Auditing?

[A].   Trace Precedents
[B].   Trace Dependents
[C].   Trace Error
[D].   All


Question : 196

How is data organized in a spreadsheet?

[A].   Rows and columns
[B].   Layers and planes
[C].   Lines and spaces
[D].   Height and width


Question : 197

All worksheet formula

[A].   Manipulate values
[B].   Manipulate labels
[C].   Return a formula result
[D].   Use the addition operator


Question : 198

Which types of charts can excel produce?

[A].   Line graphs and pie charts only
[B].   Bar charts, line graphs and pie charts
[C].   Bar charts and line graphs only
[D].   Only line graphs


Question : 199

When you insert an excel file into a word document. The data are

[A].   Hyper-linked place in a word table
[B].   Linked
[C].   Embedded
[D].   Use the word menu bar and toolbars


Question : 200

How can we set Page Border in Excel?

[A].   From Edit menu
[B].   From Home
[C].   You cannot set page border in Excel
[D].   From Tools menu





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