Microsoft Excel Solved MCQs | SET-121

Microsoft Excel MCQs - Questions and Answers | SET-121

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


Question : 1201

What is the AutoComplete feature of Excel?

[A].   It automatically completes abbreviated words
[B].   It completes text entries that match an existing entry in the same column
[C].   It completes text and numeric entries that match an existing entry in the same column
[D].   It completes text entries that match an existing entry in the same worksheet


Question : 1202

In help menu of Excel, which of the following tabs are found?

[A].   Contents tab
[B].   Answer Wizard tab
[C].   Index tab
[D].   all of the above.


Question : 1203

You can group noncontiguous worksheets with

[A].   The alt+enter key
[B].   The ctrl key and mouse
[C].   The shift key and the mouse
[D].   The group button on the standard toolbar


Question : 1204

In Excel, the Fill Color button on the Formatting toolbar is used for what?

[A].   To insert a background.
[B].   To add borders.
[C].   To select a distribution of figures.
[D].   To add shading or color to a cell range.


Question : 1205

The Software which contains rows and columns is called ______

[A].   Database
[B].   Drawing
[C].   Spreadsheet
[D].   Word processing


Question : 1206

In Excel, a Data Series is defined as what?

[A].   A type of chart.
[B].   A cell reference.
[C].   A collection of related data
[D].   A division of results


Question : 1207

What is the keyboard shortcut for creating a chart from the selected cell range?

[A].   F2
[B].   F4
[C].   F8
[D].   F11


Question : 1208

What is represented by the small, black square in the lower-right corner of an active cell or range?

[A].   Copy handle
[B].   Fill handle
[C].   Insert handle
[D].   Border


Question : 1209

The cell reference for cell range of G2 to M12 is _______

[A].   G2.M12
[B].   G2;M12
[C].   G2:M12
[D].   G2-M12


Question : 1210

What are the tabs that appear at the bottom of each workbook called?

[A].   Reference tabs
[B].   Position tabs
[C].   Location tabs
[D].   Sheet tabs





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