Microsoft Excel Solved MCQs | SET-35

Microsoft Excel MCQs - Questions and Answers | SET-35

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


Question 341-350

Question : 341

Which of the following you can paste selectively using Paste Special command?

[A].   Validation
[B].   Formats
[C].   Formulas
[D].   All of above


Question : 342

Tab scroll buttons are place on Excel screen

[A].   Towards the bottom right corner
[B].   Towards the bottom left corner
[C].   Towards the top right corner
[D].   Towards the top left corner


Question : 343

Which of the following Excel screen components can NOT be turned on or off?

[A].   Formula Bar
[B].   Status Bar
[C].   Tool Bar
[D].   None of above


Question : 344

Which tool you will use to join some cells and place the content at the middle of joined cell?

[A].   From Format Cells dialog box click on Merge Cells check box
[B].   From Format Cells dialog box select the Centered alignment
[C].   From Format Cells dialog box choose Merge and Center check box
[D].   Click on Merge and Center tool on formatting toolbar


Question : 345

Which of the following series type is not valid for Fill Series dialog box?

[A].   Linear
[B].   Growth
[C].   Autofill
[D].   Time


Question : 346

How can you show or hide the gridlines in Excel Worksheet?

[A].   Go to Tools > Options > View tab and mark or remove the check box named Gridline
[B].   Click Gridline tool on Forms toolbar
[C].   Both of above
[D].   None of above


Question : 347

You can auto fit the width of column by

[A].   Double clicking on the column name on column header
[B].   Double click on the cell pointer in worksheet
[C].   Double clicking on column right border on column header
[D].   Double clicking on the column left border of column header


Question : 348

Where can you change automatic or manual calculation mode in Excel?

[A].   Double CAL indicator on status bar
[B].   Go to File > Options > Formulas > Calculation Option – and mark the corresponding radio button
[C].   Both of above
[D].   None of above


Question : 349

Which of the cell pointer indicate that you can move the content to other cell?

[A].   Doctor’s symbol (Big Plus)
[B].   Small thin plus icon
[C].   Mouse Pointer with anchor at the tip
[D].   None of above


Question : 350

You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

[A].   Custom List
[B].   Auto Fill Options
[C].   Fill Across Worksheet
[D].   Fill Series





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