Microsoft Excel Linear MCQ Set-4

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 format you can decide to apply or not in AutoFormat dialog box?	a) Number format b) Border format c) Font format
2	How can you remove borders applied in cells?	a) Choose None on Border tab of Format cells b) Open the list on Border tool in Formatting toolbar then choose first tool (no border)
3	Where can you set the shedding color for a range of cells in Excel?	a) Choose required color form Patterns tab of Format Cells dialog box b) Choose required color on Fill Color tool in Formatting toolbar c) Choose required color on Fill Color tool in Drawing toolbar
4	You can set Page Border in Excel from	You can not set page border in Excel
5	When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply	Apply Conditional Formatting command on Format menu
6	You can check the conditions against __________ when applying conditional formatting	a) Cell value b) Formula
7	Which of the following is not true regarding Conditional Formatting?	You can set condition to look for Bold and apply Italics on them.
8	Which of the following is invalid statement?	The width of a row and be specified manually or fit automatically
9	You can use the formula pallette to	create and edit formula containing functions
10	When a range is selected, how can you activate the previous cell?	Ctrl + G
11	Which tool you will use to join some cells and place the content at the middle of joined cell?	Click on Merge and Center tool on formatting toolbar
12	Tab scroll buttons are place on Excel screen	towards the bottom left corner
13	The Name box on to the left of formula bar	shows the name of cell or range currently working on
14	Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?	data sheet
15	Which of the following is the correct method of editing the cell content?	a)  Press the F2 key b)  Click the formula bar c)  Double click the cell
16	You can merge the main document with data source in Excel. In mail merge operation, Word is usually	client
17	How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?	F9
18	You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?	Custom List
19	Where can you change automatic or manual calculation mode in Excel?	Go to Tools >> Options >> Calculation and mark the corresponding radio button
20	How can you show or hide the gridlines in Excel Worksheet?	a)  Go to Tools >> Options >> View tab and mark or remove the check box named Gridline b)  Click Gridline tool on Forms toolbar
21	Which of the following Excel screen components can be turned on or off?	a)  Formula Bar b)  Status Bar c)  Tool Bar
22	What happens when you press Ctrl + X after selecting some cells in Excel?	The cells selected are marked for cutting
23	Which of the following option is available in Paste Special dialog box?	a)  Add b)  Subtract c)  Divide
24	Which command will you choose to convert a column of data into row?	Edit >> Paste Special >> Transpose
25	It is acceptable to let long text flow into adjacent cells on a worksheet when	no data will be entered in the adjacent cells
26	Which of the cell pointer indicates you that you can make selection?	Doctor’s symbol (Big Plus)
27	Which of the cell pointer indicates that you can fill series?	small thin plus icon
28	Which of the cell pointer indicate that you can move the content to other cell?	Mouse Pointer with anchor at the tip
29	You can auto fit the width of column by	Double clicking on column right border on column header
30	Long text can be broken down into many lines within a cell. You can do this through	Wrap Text in Format >> Cells
31	MS Excel provides the default value for step in Fill Series dialog box	1
32	When a row of data is to be converted into columns	Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.
33	Ctrl + D shortcut key in Excel will	Fill down in the selection
34	The short cut key Ctrl + R is used in Excel to	Fill the selection with active cells to the right
35	The command Edit >> Fill Across Worksheet is active only when	When many sheets are selected
36	Which of the following series type is not valid for Fill Series dialog box?	a)  Linear b)  Growth c)  Autofill
37	Which of the following you can paste selectively using Paste Special command?	a)  Validation b)  Formats  c)  Formulas
38	Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?	Divide
39	Edit >> Delete command	Deletes selected cells
40	To remove the content of selected cells you must issue ______ command	Edit >> Clear >> Contents
41	The Delete key of keyboard is assigned to which command in Excel?	Edit >> Clear >> Contents
42	If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must	From Edit menu choose Clear and then Formats
43	By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?	Right click on Sheet Tab of third sheet and choose Delete from the context menu
44	Which of the following action removes a sheet from workbook?	Select the sheet, then choose Edit >> Delete Sheet
45	While Finding and Replacing some data in Excel, which of the following statement is valid?	You can Find and Replace within the sheet or workbook
46	Which of the following is  true about Find and Replace in Excel	a)  You can search for bold and replace with italics b)  You can decide whether to look for the whole word or not c)  You can search in formula too
47	You can move a sheet from one workbook into new book by	From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
48	What is the short cut key to replace a data with another in sheet?	Ctrl + H
49	Comments put in cells are called …..	Cell Tip
50	Comments can be added to cells using …..	Insert -> Comment
51	Which menu option can be used to split windows into two?	Window -> Split
52	Getting data from a cell located in a different sheet is called….	Referencing
53	Which of the following is a valid data type in Excel?	a) Number b) Label c) Date/Time
54	Which elements of a worksheet can be protected from accidental modification?	a) Contents b) Objects c) Scenarios
55	A numeric value can be treated as label value if …… precedes it.	Apostrophe (‘)
56	Concatenation of text can be done using	Ampersand (&)
57	Which area in an Excel window allows entering values and formulas?	Formula Bar
58	Multiple calculations can be made in a single formula using…..	Array Formula
59	An Excel Workbook is a collection of …….	Worksheets and Charts
60	What do you mean by a Workspace?	Group of Workbooks
61	MS-EXCEL is based on ……….?	WINDOWS
62	In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?	Auto sum
63	To select an entire column in MS-EXCEL, press?	Select the letter at the top to select the entire column.
64	To return the remainder after a number is divided by a divisor in EXCEL we use the function?	MOD ( )
65	Which function is  available in the Consolidate dialog box?	a) Average b) Max c) Sum
66	Which is the function of “Edit, Clear” command?	a) Delete contents b) Delete notes c) Delete formats
67	Microsoft Excel is a powerful………..	Spreadsheet package
68	How do you rearrange the data in ascending or descending order?	Data, Sort
69	Which Chart can be created in Excel?	a) Area b) Line c) Pie
70	What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′?	5436.8
71	How do you display current date and time in MS Excel?	now ()
72	How do you display current date only in MS Excel?	Today ()
73	How do you wrap the text in a cell?	Format, cells, alignment
74	What does COUNTA () function do?	counts non-empty cells
75	What is the short cut key to highlight the entire column?	Ctrl+Space Bar
76	In the formula, which symbol specifies the fixed columns or rows?	$
77	Excel displays the current cell address in the ……….	Name Box
78	What is the correct way to refer the cell A10 on sheet3 from sheet1?	sheet3!A10
79	Which language is used to create macros in Excel?	Visual Basic
80	Which of the following is not a term of MS-Excel?	Columns
81	How many worksheets can a workbook have?	255 sheet
82	Which would you choose to create a bar diagram?	Insert, Chart
83	Which setting you must modify to print a worksheet using letterhead?	Margin
84	What do you call the chart that shows the proportions of how one or more data elements relate to another data element?	Pie Chart
85	The spelling dialog box can be involved by choosing spelling from ________ menu.	tools
86	Which key do you press to check spelling?	F7
87	To record a sequence of keystrokes and mouse actions to play back later we use	Macro Recorder
88	We can save and protect the workbook by	a) Write Reservation Password b) Protection Password c) Read-only Recommended
89	The first cell in EXCEL worksheet is labeled as	A1
90	What happens when dollar signs ($) are entered in a cell address? (e$B$2: $B$10)	An absolute cell address is created.
91	What are the tabs that appear at the bottom of each workbook called?	Sheet tabs
92	What is represented by the small, black square in the lower-right corner of an active cell or range?	Fill handle
93	In Excel, a Data Series is defined as what?	A collection of related data
94	In Excel, the Fill Color button on the Formatting toolbar is used for what?	To add shading or color to a cell range.
95	In help menu of Excel, which of the following tabs are found?	a) Contents tab b) Answer Wizard tab c) Index tab
96	A __________ is a grid with labeled columns and rows.	Worksheet
97	The active cell	a) is defined by a bold border around the cell. b) Receives the data the user enters.
98	Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?	Financial
99	B7: B9 indicates	Cells B7 through B9.
100	The Cancel and Enter buttons appear in the	Formula bar