MS Office Excel mcq question for IBPS RRB Clerk PO and other examinations

MS EXCEL  30-Thirty  Question And Answers
1	Formulas in Excel start with
Answer:	Equal to "="
2	What is the keyboard shortcut for creating a chart from the
Answer:	F11
3	You can group noncontiguous worksheets with
Answer:	The ctrl key and mouse
4	Which of the following is not valid version of MS Office?
Answer:	Office Vista
5	Multiple calculations can be made in a single formula using
Answer:	Array Formula
6	Concatenation of text can be done using
Answer:	Ampersand (&)
7	Getting data from a cell located in a different sheet is cal
Answer:	Referencing
8	Comments put in cells are called
Answer:	Cell Tip
9	Which of the following format you can decide to apply or not
Answer:	Number,Border,Font format
10	You can use the formula pallette to
Answer:	create and edit formula containing functions
11	Which tool you will use to join some cells and place the con
Answer:	Click on Merge and Center tool on formatting toolbar
12	Which menu option can be used to split windows into two?
Answer:	Click Split under Window menu
13	You can merge the main document with data source in Excel. I
Answer:	Client
14	The box on the chart that contains the name of each individual
Answer:	The legend
15	Where a row and a column meet, what do you call that?
Answer:	A Cell
16	What happens when you press Ctrl + X after selecting some ce
Answer:	The cells selected are marked for cutting
17	Which command will you choose to convert a column of data in
Answer:	Edit then Paste Special then Transpose
18	In EXCEL, you can sum a large range of data by simply select
Answer:	Auto sum
19	Which function is not available in the Consolidate dialog bo
Answer:	PMT
20	Microsoft Excel is a powerful
Answer:	Spreadsheet package
21	You can auto fit the width of column by
Answer:	Double clicking on column right border on column header
22	Long text can be broken down into many lines within a cell.
Answer:	Wrap Text in Format then Cells
23	How do you rearrange the data in ascending or descending order
Answer:	Data, Sort
24	Ctrl + D shortcut key in Excel will
Answer:	Fill down in the selection
25	B6:B10 indicates:
Answer:	Cells B6 through B10
26	The short cut key Ctrl + R is used in Excel to
Answer:	Fill the selection with active cells to the right
27	The Cancel and Enter buttons appear in the
Answer:	Formula bar
28	Which of the following series type is not valid for Fill Series
Answer:	Time
29	MS-EXCEL can be used to automate
Answer:	Accounts receivable, accounts payable
30	You can move a sheet from one workbook into new book by
Answer:	From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
Tag: excel question answers, microsoft excel mcq question, microsoft office excel mcq, ms excel, MS Excel question answer for bank clerk po rrb examiantion IBPS Bank PO Clerk RRB Banking Awareness Question and answers: 1. Banking Awareness 20-Twenty MCQ 2. MS WORD MCQ 40-Forty Question and Answers