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
- Microsoft Excel MCQs
for Bank, TET, MBA, CAT, MAT, GMAT, SSC | SET – 97 - Microsoft Excel MCQs
for Bank, TET, MBA, CAT, MAT, GMAT, SSC | SET – 98 - Microsoft Excel MCQs
for Bank, TET, MBA, CAT, MAT, GMAT, SSC | SET – 99 - Microsoft Excel MCQs
for Bank, TET, MBA, CAT, MAT, GMAT, SSC | SET – 100 - Microsoft Excel MCQs
for Bank, TET, MBA, CAT, MAT, GMAT, SSC | SET – 101 - Microsoft Excel MCQs
for Bank, TET, MBA, CAT, MAT, GMAT, SSC | SET – 102 - Microsoft Excel MCQs
for Bank, TET, MBA, CAT, MAT, GMAT, SSC | SET – 103 - Microsoft Excel MCQs
for Bank, TET, MBA, CAT, MAT, GMAT, SSC | SET – 104 - Microsoft Excel MCQs
for Bank, TET, MBA, CAT, MAT, GMAT, SSC | SET – 105 - Microsoft Excel MCQs
for Bank, TET, MBA, CAT, MAT, GMAT, SSC | SET – 106
Please Read These Useful Post Also
कृपया इन्हें भी पढ़ें
MCQs Practice Sets for Sure Success in all competitive exams
- IT-Abbreviations
- Computer Awareness in hindi
- Computer Awareness
- IT Computer
- C++ MCQ
- MS EXCEL
- MS Word
- C Language
- HTML
- CSS
- PPT
- Java
- PHP
- Web Design
- MS Access
- OS System
- Indian GK
- Indian History
- Geography
- Indian Politics
- Indian Economy
- Indian Constitution
- Indian Railaway
- EVS
- India Sports GK
- World GK
- CTET
- Current Affairs
- Psychology
- Biology
- Physics
- Chemistry
- Mathematics
- English Grammar
- Hindi Grammar
- Banking
- HP-All Exam
- HP-JAO
- HP-Allied Services
- HP-Naib Tehsildar
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