Thursday, 12 January 2017

MS Excel MCQ Objectives Part 2 | MS Excel Objective Type Questions

By Dr. IM  |  08:18

MS Excel MCQ and Objectives Part 2  | MS Excel Objective Type Questions

About MS Excel : As we know that the microsoft developed Excel which is a spreadsheet for window, macos, android and ios user. The MS excel first introduced on 1985 and now microsoft launches new version of MS excel i.e. MS Excel 2016 version. MS excel has following version: Excel 2.0 (1987), Excel 3.0 (1990), Excel 4.0 (1992), , Excel 5.0 (1993), Excel 95 (v7.0), Excel 97 (v8.0), Excel 2000 (v9.0), Excel 2002 (v10.0), Excel 2003 (v11.0), Excel 2007 (v12.0), Excel 2010 (v14.0), Excel 2013 (v15.0), and Excel 2016 (v16.0).Actually MS Excel is a spredsheet and having row and column structure. It has many features which helps to make Chart, formula, etc in very short time. It has also password protected features like:Password to open a document, protect workbook and Password to protect the sharing workbook.
                 In the recent Microsoft launcehs MS Excel 2016 V16.0 version which includes many tools like : Quick data linking in Visio, Power Query integration, Keyboard access for Pivot Tables and Slicers in Excel, Read-only mode for Excel, Support for multi-selection of Slicer items using touch, New Chart Types, Excel forecasting functions, Time grouping and Pivot Chart Drill Down, Excel data cards.
26. In a worksheet you can select
A The entire worksheet
B Rows
C Columns
D All of the above
ANS
27. When you link data maintained in an excel workbook to a word document
A The word document cannot be edit
B The word document contains a reference to the original source application
C The word document must contain a hyperlink
D The word document contains a copy of the actual data
ANS
28. Which area in an excel window allows entering values and formulas
A Title bar
B Menu bar
C Formula bar
D Standard toolbar
ANS


29. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
A Unfreeze panes command on the window menu
B Freeze panes command on the window menu
C Hold titles command on the edit menu
D Split command on the window menu
ANS
30. To edit in an embedded excel worksheet object in a word document
A Use the excel menu bar and toolbars inside the word application
B Edit the hyperlink
C Edit the data in a excel source application
D Use the word menu bar and toolbars
ANS
31. To create a formula, you can use:
A Values but not cell references
B Cell references but not values
C Values or cell references although not both at the same time
D Value and cell references
ANS

Download MS Excel Objective Question and Answer  MS Excel MCQ

32. Status indicators are located on the
A Vertical scroll bar
B Horizontal scroll bar
C Formula bar
D Standard toolbar
ANS


33. Which of the following is the oldest spreadsheet package?
A VisiCalc
B Lotus 1-2-3
C Excel
D StarCalc
ANS
34. Rounding errors can occur
A When you use multiplication, division, or exponentiation in a formula
B When you use addition and subtraction in a formula
C Because excel uses hidden decimal places in computation
D When you show the results of formulas with different decimal places that the calculated results
ANS
35. You can copy data or formulas
A With the copy, paste and cut commands on the edit menu
B With commands on the shortcut menu
C With buttons on the standard toolbars
D All of the above
ANS
36. You cannot link excel worksheet data to a word document
A With the right drag method
B With a hyperlink
C With the copy and paste special commands
D With the copy and paste buttons on the standard toolbar.
ANS
37. Which of the following is a popular DOS based spreadsheet package?
A Word
B Smart cell
C Excel
D Lotus 1-2-3
ANS
38. An excel workbook is a collection of
A Workbooks
B Worksheets
C Charts
D Worksheets and charts
ANS


39. Excel files have a default extension of
A Xls
B Xlw
C Wk1
D 123
ANS
40. You can use the format painter multiple times before you turn it off by
A You can use the format painter button on ly one time when you click it
B Double clicking the format painter button
C Pressing the Ctrl key and clicking the format painter button
D Pressing the Alt key and clicking the format painter button
ANS

Download MS Excel Objective Question and Answer  MS Excel MCQ

41. You can use the formula palette to
A Format cells containing numbers
B Create and edit formulas containing functions
C Enter assumptions data
D Copy a range of cells
ANS
42. You can convert existing excel worksheet data an charts to an HTML document by using
A FTP wizard
B Internet assistant wizard
C Intranet wizard
D Import wizard
ANS
43. A circular reference is
A Geometric modeling tool
B A cell that points to a drawing object
C A formula that either directly or indirectly depends on itself
D Always erroneous
ANS
44. Which of following is Not one of Excel’s what-if function?
A Goal seek
B Solver
C Scenario manager
D Auto Outline
ANS


45. When you insert an excel file into a word document. The data are
A Hyperlinked placed in a word table
B Linked
C Embedded
D Use the word menu bar and toolbars
ANS
46. Which of the following is not information you can specify using the solver?
A Input cells
B Constraints
C Target cell
D Changing cells
ANS

Download MS Excel Objective Question and Answer  MS Excel MCQ

47. Each excel file is called a workbook because
A It can contain text and data
B It can be modified
C It can contain many sheets including worksheets and chart sheets
D You have to work hard to create it
ANS
48. Excel probably considers the cell entry January 1, 2000 to be a
A Label
B Value
C Formula
D Text string
ANS
49. You can enter which types of data into worksheet cells?
A Labels, values, and formulas
B Labe3ls and values but not formulas
C Values and formulas but not labels
D Formulas only
ANS
50. All worksheet formula
A Manipulate values
B Manipulate labels
C Return a formula result
D Use the addition operator
ANS


you are @ Part 2 go to Next Part
Click to Go


Related Links: Computer MCQ   s Study Materials; Educational Articles  objective questions MCQ questions ,


People also search ms excell in terms of : People also search: ssc general awareness  and answers,   for ssc exam,   and answers for competitive exams , general awareness , ,   and answers , , general awareness , ssc exam 10+2 level ,   online test,   , download, , mp police ,  book,  download,  trick ,  for upsc prelims, upsc  mock test, ias  online, multiple choice  on indian history with answers , ias exam  and answers , ias   and answers , ias prelims  with answers, ias model with answer, Searches related to  ,   in english, question paper download, ,  objective  ,  download,  book,  trick ,   in ,  , mp  , mp  syllabus , mp  exam , patwari  exam  merit list,  mp police , mp police paper  download,, mp police  question , mp police constable model paper , mp si  ,    free download, mp police , mp police constable paper , mp police constable ,   objective,  important  ,  solved paper  download,   notes  ,  current affairs ,   online test,   book,  ,  ,  previous year papers civil engineering,  question paper,  ,  mains previous year , question papers ,  mains paper pattern,  exam solved paper,  model paper , mp police constable model paper  ,  old paper , mp si previous year paper , mp si previous year paper  , mp si paper download   ,    download,    ,  download,  objective  ,  trick ,  book,   at a glance ,   ,   in english,    download,   at a glance ,  download,    ,  book,  objective  ,  trick , in , MPPSC, Questions, Answers, PDF, GK, Basic Computer, Vyapam, mcq, Hindi,   e, MS Excell, Microsoft Excel

Author: Dr. IM

Hello, I am blogger and serving most important questions. We put all questions and answer very carefully; If any discripancy we are not responsible.

Subscribe for Email Alert

Sign up for Latest MCQ.

Recent Articles

TOP