Microsoft Excel Linear MCQ Set-3

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	MS-EXCEL can be used to automate	a) Financial statements, Business forecasting b) Transaction registers, inventory control c) Accounts receivable, accounts payable
2	NOT, AND, OR and XOR are	Logical Operators
3	In a report, you need to show the monthly rainfall in Nepal The best way to do this is to insert a	chart showing rainfall amounts
4	You want to record experiment information and create a chart that shows the rate of crystal growth over a period of time The best application to use would be?	spreadsheet
5	You are editing an worksheet that you had previously save If you want to save the edited sheet without losing the original one, which command should you use?	Save As
6	If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?	Insert a row
7	In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in ……………	descending order
8	In order to perform a calculation in a spreadsheet, you need to use a?	formula
9	The box on the chart that contains the name of each individual record is called the ________.	legend
10	If you want all of the white cats grouped together in the database, you need to sort by ________.	Pet Type, then Color
11	You accidentally erased a record in the sheet What command can be used to restore it immediately?	Undo
12	Where a row and a column meet, what do you call that?	A cell
13	How do you tell one cell from another?	By its address
14	Give me an example of a cell address.	A21
15	Which is an example of a formula?	=A1+A2
16	Which is an example of a function?	=SUM(A1: A2)
17	What is the symbol for multiplying?	*
18	What is the symbol for dividing?	A ./
19	A function inside another function is called _______	Nested function
20	Which of the following is not an underline option in the format cells dialog box?	Single Engineering
21	Formulas in Excel start with	=
22	The default header for a worksheet is	the page number and the worksheet name
23	Which of the following is an option of the spelling dialog box?	a) Ignore b) Ignore all c) Change
24	Which of the following methods will not enter data in a cell?	Pressing the Esc key
25	The cell reference for cell range of G2 to M12 is _______	G2 : M12
26	What is the keyboard shortcut for creating a chart from the selected cell range?	F11
27	The Software which contains rows and columns is called ______	Spreadsheet
28	You can group noncontiguous worksheets with	The ctrl key and mouse
29	What is the AutoComplete feature of Excel?	It completes text entries that match an existing entry in the same column
30	Which of the following is correct?	a) =AVERAGE(4, 5, 6, 7)  b) =AVERAGE(A1, B1, C1) c) =AVERAGE(A1: A9, B1: B9)
31	Which of the following function will return a value of 8?	a) ROUNDDOWN(8.4999, 0) b) ROUND(8.4999, 0)
32	How to restrict to run a macro automatically when starting Microsoft Excel?	Hold down the SHIFT key during startup
33	How to remove the unwanted action from recorded macro without recording the whole macro again?	By edit the macro in the Visual Basic Editor
34	What should be add before a fraction to avoid entering it as a date?	Zero Space
35	Which of the following function will use to find the highest number in a series of number?	MAX(B1: B3)
36	What does the NOW() function return?	the serial number of the current date and time
37	What value will display if the formula = “$55.00″+5 is entered into a cell?	60
38	What is the shortcut key to insert current date in a cell?	CTRL + ;
39	Which of the following syntax is correct regarding to SUM function in Excel?	a) =SUM (A1, B1) b) =SUM (A1: B9) c) =SUM (A1: A9, B1: B9)
40	What is the shortcut key to hide entire column?	CTRL + 0
41	How to specify cell range from A9 to A99 in Excel?	(A9 : A99)
42	Selecting the Column G & H then choose Insert->Column What will happen?	2 Columns will be inserted after Column F
43	How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.	The Settings tab under the menu Data -> Validation
44	Clear the contents by pressing “DELETE” key from a keyboard will clear	Contents Only
45	Which of the following shortcuts can be used to insert a new line in the same cell?	Alt + Enter
46	What is the quickest way to select entire worksheet?	Click on the rectangle box on the upper left corner where column headings and row headings meet
47	A smart tag will be removed from a cell when	the data in the cell is changed or deleted
48	Which of the following options is appropriate to show the numbers 9779851089510 in a cell?	Apply the Text format in the cell and type the numbers
49	Which of the following is correct syntax in Excel?	=IF(LogicalTest, TrueResult, FalseResult)
50	Which of the following is correct?	=POWER(2,3)
51	Selecting the Rows 5 & 6 then choose Insert->Row What will happen?	2 Rows will be inserted after Row 4
52	If 4/6 entered in a cell without applying any formats, Excel will treat this as	Date
53	If the values in A1 is “MCQ” and B1 is “Questions”, which function will return [email protected] in cell C1?	=A1 & [email protected] & B1
54	How to fit long texts in a single cell with multiple lines?	Use the Wrap Text option in the Format -> Alignment menu
55	If particular workbook have to open each time Excel started, where that workbook should be placed?	XLSTART Folder
56	If the cell B1 contains the formula = $A$1, which of the following statements is true	There is an absolute reference to cell A1
57	Worksheet can be renamed by	Double Click on the Worksheet tab and type new name
58	What is the shortcut key to hide entire row?	CTRL + 9
59	What is the shortcut key to insert a new comment in a cell?	Shift + F2
60	Which option allows you to Bold all the negative values within the selected cell range ?	Conditional Formatting
61	What is the shortcut key to insert new sheet in current workbook?	Shift + F11
62	Which one is the last column header in Excel 2007?	XFD
63	In maximum, how many sheets can be set as default while creating new workbook?	255
64	“New Comment” option can be found under _________ tab	Review
65	In Excel, by default Numeric Values appears in	Right aligned
66	To show/hide the grid lines in Microsoft Excel 2007	Page Layout -> Grid lines -> View
67	What will be the result if you type =A1=B1 in cell C1?	True or False
68	In Excel _______ may not contain in Formula	Circular Reference