Microsoft Excel Linear MCQ Set-2

Microsoft Excel|MS Excel

MS Excel MCQ Questions and Answers based on the computer basics. MS Excel are important for the banking examinations. For Vyapam, SSC, IBPS PO, IBPS Clerk, Railways, Bank and any other compititives Exam.

Microsoft Excel Linear mcq Question with Answer for student who preperation for compititive exams. It will help you for crack the upcoming exam. Candidate must be revice regular of this question. I will give you update regularlly.

स. क्र	प्रश्‍न	उत्‍तर
1	Which of the following methods cannot be used to enter data in a cell	Pressing the Esc key
2	Which of the following will cut information?	b) Selecting Edit>Cut from the menu c) Clicking the Cut button on the standard d) Pressing Ctrl+X
3	Which of the following is a way to complete a cell entry?	a) Pressing enter b) Pressing any arrow key on the keyboard c) Clicking the Enter button on the Formula bar
4	You can activate a cell by	a) Pressing the Tab key b) Clicking the cell c) Pressing an arrow key
5	Text formulas ?	Concatenate and manipulate text
6	How do you insert a row?	Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
7	Which of the following is not a basic step in creating a worksheet?	Copy the worksheet
8	How do you select an entire column?	Click the column heading letter
9	How can you print three copies of a workbook?	Select File >Print from the menu and type 3 in the Number of copies text box.
10	To create a formula, you first  ?	Select the cell you want to place the formula into
11	To center worksheet titles across a range of cells, you must	Select the cells containing the title text plus the range over which the title text is to be centered
12	How do you delete a column?	Right click the column heading you want to delete and select delete from the shortcut menu
13	How can you find specific information in a list?	Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
14	When integrating word and excel, word is usually the	Destination c. Client
15	When a label is too long to fit within a worksheet cell, you typically must	Increase the column width
16	The name box	Appears to the left of the formula bar
17	Comments put in cells are called	Cell tip
18	Which is used to perform what if analysis?	a) Solver b) Goal seek c) Scenario Manager
19	You can use the horizontal and vertical scroll bars to	View different rows and columns edit the contents of a cell
20	Multiple calculations can be made in a single formula using	array formula
21	Hyperlinks can be	a) Text b) Drawing objects c) Pictures
22	To activate the previous cell in a pre-selected range, press	Ctrl + Shift + Enter
23	Which button do you click to add up a series of numbers?	The autosum button
24	When the formula bar is active, you can see	a) The edit formula button b) The cancel button c) The enter button
25	To copy formatting from one area in a worksheet and apply it to another area you would use ?	The Format Painter button on the standard toolbar
26	In a worksheet you can select	a) The entire worksheet b) Rows c) Columns
27	When you link data maintained in an excel workbook to a word document	The word document contains a reference to the original source application
28	Which area in an excel window allows entering values and formulas	Formula bar
29	To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the	Freeze panes command on the window menu
30	To edit in an embedded excel worksheet object in a word document	Use the excel menu bar and toolbars inside the word application
31	To create a formula, you can use  ?	Value and cell references
32	Status indicators are located on the	Formula bar
33	Which of the following is the oldest spreadsheet package?	VisiCalc
34	Rounding errors can occur	When you use multiplication, division, or exponentiation in a formula
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
36	You cannot link excel worksheet data to a word document	With the copy and paste buttons on the standard toolbar.
37	Which of the following is a popular DOS based spreadsheet package?	Lotus 1-2-3
38	An excel workbook is a collection of	Worksheets and charts
39	Excel files have a default extension of	Xls
40	You can use the format painter multiple times before you turn it off by	Double clicking the format painter button
41	You can use the formula palette to	Create and edit formulas containing functions
42	You can convert existing excel worksheet data an charts to an HTML document by using	Internet assistant wizard
43	A circular reference is	A formula that either directly or indirectly depends on itself
44	Which of following is Excel’s what-if function?	a) Goal seek b) Solver c) Scenario manager
45	When you insert an excel file into a word document. The data are	Linked
46	Which of the following is information you can specify using the solver?	a) Constraints b) Target cell c) Changing cells
47	Each excel file is called a workbook because	It can contain many sheets including worksheets and chart sheets
48	Excel probably considers the cell entry January 1, 2000 to be a	Value
49	You can enter which types of data into worksheet cells?	Labels, values, and formulas
50	All worksheet formula	Return a formula result
51	Which of the following is a correct order of precedence in formula calculation?	Exponentiation, Multiplication and division,  positive and negative values
52	The Paste Special command lets you copy and paste ?	The resulting values of a formula instead of the actual formula
53	The numbers in our worksheet look like this You want them to look like this : $1,000.How can you accomplish this?	Click the Currency Style button on the formatting toolbar
54	Which of the following is  a valid data type in excel	a) Number b) Label c) Date/time
55	Excel worksheet cells work very similarly to what common element of the windows graphical user interface	Text boxes
56	Which of the following options is located in the Page Setup dialog box?	a) Page Orientation b) Margins c) Headers and Footers
57	You want to track the progress of the stock market on a daily basis. Which type of chart should you use?	Line chart
58	Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?	Press Ctrl +Home
59	Which of the following methods can not be used to edit the contents of a cell?	Press the Alt key
60	If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you?	Press Esc
61	to view a cell comment	position the mouse pointer over the cell
62	When you want to insert a blank imbedded excel object in a word document you can	Click the object command on the insert menu
63	To save a workbook, you ?	Click the save button on the standard toolbar from the menu
64	You can edit a cell by	Double clicking the cell to edit it in-place
65	You can select a single range of cells by	Dragging over the desired cells
66	Which elements of worksheet can be protected from accidental modification	a) Contents b) Objects c) Scenarios
67	You can use the drag and drop method to	a) Copy cell contents b) Move cell contents
68	It is acceptable to let long text flow into adjacent cells on a worksheet when	No data will be entered in the adjacent cells
69	How can you delete a record?	Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
70	Right clicking something in Excel?	Opens a shortcut menu listing everything you can do to the object
71	Documentation should include	a) Destination and users of the output data b) Source of input data c) Information on the purpose of the workbook
72	Files created with Lotus 1-2-3 have an extension	.123
73	To delete an embedded objects, first	Select it and then press the delete key
74	Comments can be added to cells using	Insert > Comments
75	Which of the following is not a worksheet design criterion?	Description
76	To copy cell contents using drag and drop press the	End key
77	Which of the following is the latest version of Excel	Excel XP
78	When you copy a formula	Excel edits cell references in the newly copied formula
79	The Autosum feature	automatically adds range of cell values
80	Which menu option can be sued to split windows into two	Window > split
81	Which of the following is an absolute cell reference?	$A$1
82	What symbol is used before a number to make it a label?	‘ (apostrophe)
83	Which symbol must all formula begin with?	=
84	Which of the following formulas is not entered correctly?	10+50
85	Which of the following formulas will Excel be able to calculate?	a) =SUM(A1:A5)*.5 b) =SUM(A1:A5)/(10-10) c) =SUM(A1:A5)-10
86	A typical worksheet has …. Number of columns	256
87	How many characters can be typed in a single cell in Excel?	65535
88	A worksheet can have a maximum of …. Number of rows	65535
89	Which of the following is an example of a value?	a) 350 b) May 10, 2001 c) 0.57
90	The chart wizard term data series refers to	A collection of chart data markers
91	The Chart wizard term data categories refers to;	A horizontal axis
92	A worksheet range is a	A group of cells
93	Getting data from a cell located in a different sheet is called …	Referencing
94	Tab scrolling button	Allow you to view additional sheets tabs
95	A numeric value can be treated as a label value if it precedes with	An apostrophe (')
96	Concatenation of text can be done using	Ampersand (&
97	Data can be arranged in a worksheet in a easy to understand manner using	a) auto formatting b) applying styles c) changing fonts
98	You can use drag-and-drop to embed excel worksheet data in a word document	By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
99	The auto calculate feature	Provides a quick way to view the result of an arithmetic operation on a range of cells
100	Excel uniquely identifies cells within a worksheet with a cell name	Column letters and row numbers