Thursday, 12 January 2017

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

By Dr. IM  |  08:20

MS Excel MCQ and Objectives Part 4  | 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.

76. To copy cell contents using drag and drop press the
A End key
B Shift key
C Ctrl key
D Esc key
ANS
77. Which of the following is the latest version of Excel
A Excel 2000
B Excel 2002
C Excel ME
D Excel XP
ANS


78. 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
ANS

Download MS Excel Objective Question and Answer  MS Excel MCQ

79. The autofill feature
A extends a sequential series of data
B automatically adds range of cell values
C applies a boarder around the selected cells
D none of the above
ANS
80. Which menu option can be sued to split windows into two
A Format > window
B View > window > split
C Window > split
D View > split
ANS
81. Which of the following is an absolute cell reference?
A !A!1
B $A$1
C #a#1
D A1
ANS


82. What symbol is used before a number to make it a label?
A ” (quote)
B = (equal)
C _ (underscore)
D ‘ (apostrophe)
ANS
83. Which symbol must all formula begin with?
A =
B +
C (
D @
ANS
84. Which of the following formulas is not entered correctly?
A =10+50
B =B7*B1
C =B7+14
D 10+50
ANS
85. Which of the following formulas will Excel Not be able to calculate?
A =SUM(Sales)-A3
B =SUM(A1:A5)*.5
C =SUM(A1:A5)/(10-10)
D =SUM(A1:A5)-10
ANS
86. A typical worksheet has …. Number of columns
A 128
B 256
C 512
D 1024
ANS
87. How many characters can be typed in a single cell in Excel?
A 256
B 1024
C 32000
D 65535
ANS


88. A worksheet can have a maximum of …. Number of rows
A 256
B 1024
C 32000
D 65535
ANS
89. Which of the following is not an example of a value?
A 350
B May 10, 2001
C 0.57
D Serial Number 50771
ANS

Download MS Excel Objective Question and Answer  MS Excel MCQ

90. The chart wizard term data series refers to
A A chart legend
B A collection of chart data markers
C A set of values you plot in a chart
D A data label
ANS
91. The Chart wizard term data categories refers to;
A A chart plot area
B A horizontal axis
C The organization of individual values with a chart’s data series
D The data range that supply chart data
ANS
92. A worksheet range is a
A A command used for data modeling
B A range of values such as from 23 to 234
C A group of cells
D A group of worksheets
ANS


93. Getting data from a cell located in a different sheet is called …
A Accessing
B Referencing
C Updating
D Functioning
ANS
94. Tab scrolling button
A Allow you to view a different worksheet
B Allow you to view additional worksheet rows down
C Allow you to view additional worksheet columns to the right
D Allow you to view additional sheets tabs
ANS
95. A numeric value can be treated as a label value if it precedes with
A Apostrophe (&lsquo
B Exclamation (!)
C Hash (#)
D Ampersand (&
ANS

Download MS Excel Objective Question and Answer  MS Excel MCQ

96. Concatenation of text can be done using
A Apostrophe (&lsquo
B Exclamation (!)
C Hash (#)
D Ampersand (&
ANS
97. Data can be arranged in a worksheet in a easy to understand manner using
A auto formatting
B applying styles
C changing fonts
D all of above
ANS
98. You can use drag-and-drop to embed excel worksheet data in a word document
A By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
B By dragging a range of excel data to the word button on the taskbar while pressing Shift key
C By dragging a range of excel data to the word button on the taskbar while pressing Alt key
D None of above
ANS
99. The auto calculate feature
A Can only add values in a range of cells
B Provides a quick way to view the result of an arithmetic operation on a range of cells
C Automatically creates formulas and adds them to a worksheet
D A and c
ANS
100. Excel uniquely identifies cells within a worksheet with a cell name
A Cell names
B Column numbers and row letters
C Column letters and row numbers
D Cell locator coordinates
ANS


you are @ Part 4 go to previous 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