microsoft-excel-mcqs-set-3

Microsoft Excel MCQs - Questions and Answers | SET-3
Microsoft Excel Solved Multiple Choice Questions

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


Question 21-30

Question : 21

How many characters can be typed in a single cell in Excel?

[A].   256
[B].   1024
[C].   32000
[D].   65535


Question : 22

Which button do you click to add up a series of numbers?

[A].   The autosum button
[B].   The Formula button
[C].   The quicktotal button
[D].   The total button


Question : 23

Getting data from a cell located in a different sheet is called …

[A].   Accessing
[B].   Referencing
[C].   Updating
[D].   Functioning


Question : 24

When a label is too long to fit within a worksheet cell, you typically must

[A].   Shorten the label
[B].   Increase the column width
[C].   Decrease the column width
[D].   Adjust the row height


Question : 25

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

[A].   Press Ctrl +Home
[B].   Press Home
[C].   Press Shift + Home
[D].   Press Alt + Home


Question : 26

When you copy a formula

[A].   Excel erases the original copy of the formula
[B].   Excel edits cell references in the newly copied formula
[C].   Excel adjusts absolute cell references
[D].   Excel doesn’t adjust relative cell references


Question : 27

Which area in an excel window allows entering values and formulas

[A].   Title bar
[B].   Menu bar
[C].   Formula bar
[D].   Standard toolbar


Question : 28

How can you print three copies of a workbook?

[A].   Select File>Properties form the menu and type 3 in the Copies to print text box.
[B].   Select File >Print from the menu and type 3 in the Number of copies text box.
[C].   Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made
[D].   Press Ctrl+P+3


Question : 29

Excel probably considers the cell entry January 1, 2000 to be a

[A].   Label
[B].   Value
[C].   Formula
[D].   Text string


Question : 30

An excel workbook is a collection of

[A].   Workbooks
[B].   Worksheets
[C].   Charts
[D].   Worksheets and charts





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

Subscribe to: Post Comments (Atom)