Microsoft Excel Solved MCQs | SET-103

Microsoft Excel MCQs - Questions and Answers | SET-103

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


Question : 1021-1030

Question : 1021

Which of the following methods can not be used to enter data in a cell?

[A].   Pressing an arrow key
[B].   Pressing the tab key
[C].   Pressing the Esc key
[D].   Clicking the enter button to the formula bar


Question : 1022

You can group noncontiguous worksheets with

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


Question : 1023

If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?

[A].   Point to speech on the tools menu, and then click show text to speech toolbar.
[B].   Click validation on the data menu
[C].   Point to speech on the tools menu, and then click speech recognition
[D].   All of above


Question : 1024

when you print preview a worksheet

[A].   the entire worksheet is displayed
[B].   the selected range is displayed
[C].   the active portion of the worksheet is displayed
[D].   a, b and c


Question : 1025

Which function calculates your monthly mortage payment?

[A].   PMT (payments)
[B].   NPER (number of periods)
[C].   PV (present value)
[D].   All of above


Question : 1026

In a worksheet you can select

[A].   The entire worksheet
[B].   Rows
[C].   Columns
[D].   a, b, and c


Question : 1027

Your German supplier still invoices for parts in Deutsche marks. How can you have Excel convert those sums to Euros?

[A].   On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign.
[B].   On the tools menu, click Add-Ins, and select the Euro Currency Tools check box
[C].   Apply a selected background color
[D].   All of above


Question : 1028

When the formula bar is activated, you can see

[A].   The Edit Formula button
[B].   The Cancel button
[C].   The Enter button
[D].   All of above


Question : 1029

How should you print a selected area of a worksheet, if you’ll want to print a different area next time?

[A].   On the file menu, point to print area, and then click set print area.
[B].   On the file menu, click print, and then click selection under print what
[C].   On the view menu, click custom views, then click add
[D].   All of above


Question : 1030

to activate the previous cell in a pre-selected range, press

[A].   the Alt key
[B].   the Tab key
[C].   the Enter key
[D].   none of 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