Hello everyone my name is Rahul Singh or aaj aap इस Blog में आप सीखेंगे Top Ms Excel MCQ जो Exams में 100% Aaney ki possibility h.

**SET-1**

**Q. NO.1 What is the intersection of a column and a row on a worksheet called?**

**Column****Value****Address****Cell**

**Q. NO.2 What type of chart is useful for comparing values over categories?**

**Pie chart****Column chart****Line chart****Dot chart**

**Q. NO.3 Which functioning Excel tells how many numeric entries are there?**

**NUM****COUNT****SUM****CHKNUM**

**Q. NO.4 A features that displays only the data in column (s) according to specified criteria?**

**Formula****Sorting****Filtering****Pivot**

**Q. NO. 5 Statistical calculations and preparation of tables and graphs can be done using?**

**Adobe photo shop****Excel****Notepad****Power Point**

**Q. NO 6 What type of chart will you use to compare performance of two employees in the year 2021?**

**Column****Line chart****Pie chart****Dot chart**

**Q. NO 7 Which one is not a Function in MS Excel?**

**SUM****AVG****MAX****MIN**

**Q. NO 8 Functions in MS Excel must begin with—-**

**An () sign****An equal sign****A plus sign****A > sign**

**Q.NO 9 Which function checks whether a condition is true or not?**

**SUM****COUNT****IF****AVERAGE**

**Q. NO 10 In Excel, columns are labelled as_**

**A BC etc.****1,2,3 etc.****A1 , A2 etc.****$A$1 , $A$2 etc.**

**Q. NO 11 The Greater Than sing (>) is an example of__ operator.**

**Arithmetic****Logical operator****Conditional****Greater**

**Q. NO 12 What type of chart is useful for showing or changes over time?**

**Pie chart****Column chart****Line chart****Dot Graph**

**Q. NO 13 The process of arranging the items of a column in some sequence or order is known as:**

**Arranging****Autofill****Sorting****Filtering**

**Q. NO 14 The__ feature of MS Excel quickly completes a series of data**

**Auto complete****Auto fill****Fill Handle****Sorting**

**Q.NO 15 What type of chart is useful for comparing parts of a whole?**

**Pie chart****Column chart****Line chart****Dot chat**

**D****B****B****C****B****C****B****B****C****C****B****C****C****B****C**

** SET-2**

**Q.1 ______ appear at the bottom of the excel window.**

**Title bar****Formula bar****Work sheet table****Name box**

**Q.2 what are the basic rectangular building blocks of a spreadsheet?**

**Cells****Zoom slider****Help button****All of these**

**Q.3 which of the following is not a term pertaining to spreadsheet?**

**Cells****Character****Browser****Formula**

**Q.4 Another name for a pro-programmed in excel is?**

**Cell****Graph****Function****Range**

**Q.5 Excel is program that is used to prepare a?**

**Slide presentation****Spreadsheet****Text document****Data base**

**Q.6 In which tab wrap text feature is present in MS-Excel 2016?**

**Formula****View****Insert****Home tab**

**Q.7 which of the following identifies a cell in Excel?**

**Address****Formula****Name****Label**

**Q.8 which term is used to join the selected cells into one cell?**

**Filter****Wrap****Pivot****Marge**

**Q.9 Which of the following Excel chart represents only one value for each variable?**

**Bar****Pai****Line****Functions**

**Q.10 A formula in Excel always beings with an ______**

**Equal sign****Colon****Comma****Space**

**Q.11 when the CPU detects an interrupt, then it saves its**

**Previous state****Next state****Current state****All of these**

**Q.12 A (n) ____ is the series of two or more adjacent cells in a column or row rectangular group of cell.**

**List****Section****Range****Area**

**Q.13 What is the extension of saved file in MS-Excel?**

**.xls****.xks****.xos****.xds**

**Q.14 Which command is used to close the window of excel?**

**Alt + f4****Ctrl + W****Ctrl + R****Ctrl + C**

**Q. 15 What is the total region surrounding the chart?**

**Chart area****Legend****Clipart area****Pivot area**

**C****A****C****C****B****D****A****D****B****A****C****C****A****A****A**

** SET-3**

**Q.NO.1 To maximize the currently selected window, press**

**(A) Ctrl+ F9**

**(B) Ctrl+ F10**

**(C) Ctrl+ F11**

**(D) Ctrl+ F12**

**Q.NO.2 Which of the following is the default numbers of worksheet in MS Excel?**

**(A) 2**

**(B) 3**

**(C) 4**

**(D) 5**

**Q.NO.3 Formulas in Excel are made up of ___**

**(A) Arithmetical operators and functions**

**(B) Only arithmetic operators**

**(C) Only symbols**

**(D) Only functions**

**Q.NO.4 The result is a ___ value either TRUE or FALSE.**

**(A) Logical**

**(B) Arithmetic**

**(C) Algorithm**

**(D) Logarithm**

**Q.NO.5 Which of the following is the comparison operator?**

**(A) ***

**(B) ^**

**(C) =**

**(D) +**

**Q.NO.6 On an Excel sheet, the active cell is indicated by**

**(A) A dark wide border**

**(B) A dotted border**

**(C) A blinking border**

**(D) None of the above**

**Q.NO.7 The letter and number of the intersecting column and row is the**

**(A) Cell location**

**(B) Cell position**

**(C) Cell address**

**(D) Cell coordinates**

**Q.NO.8 The ____ helps to identify various plotted data series.**

**(A) X-axis**

**(B) Y-axis**

**(C) Gridlines**

**(D) Legend**

**Q.NO.9 Which sign indicate to multiplication?**

**(A) Asterisk**

**(B) Caret**

**(C) Percent sign**

**(D) Forward slash**

**Q.NO.10 In a spreadsheet, a ____ is a number you will use in a calculation.**

**(A) Value**

**(B) Cell**

**(C) Field**

**(D) Label**

**Q.NO.11 ____ is a powerful tool used to create and format spreadsheets.**

**(A) Adobe Photoshop CS**

**(B) Mozilla Firefox**

**(C) Microsoft Office PowerPoint**

**(D) Microsoft Office Excel**

**Q.NO.12 Workbook is a collection of**

**(A) Worksheets**

**(B) Page set-up**

**(C) Buttons**

**(D) Diagrams**

**Q.NO.13 The worksheet names appear on tabs at the ____ of the workbook window.**

**(A) Bottom right**

**(B) Bottom left**

**(C) Top left**

**(D) Top right**

**Q.NO.14 The result of a formula in a cell is the**

**(A) Displayed value**

**(B) Range**

**(C) Value**

**(D) Label**

**Q.NO.15 ____ is the intersection of a row with a column.**

**(A) Cell**

**(B) Row**

**(C) Column**

**(D) All of these**

**Q.NO.16 To display the save as dialog box, press**

**(A) F2**

**(B) F3**

**(C) F5**

**(D) F12**

**Q.NO.17 The default file extension of MS-Excel is**

**(A) .xlr**

**(B) .xls**

**(C) .exe**

**(D) .exl**

**Q.NO.18 Which command is used to close the window of Excel?**

**(A) Alt + F4**

**(B) Ctrl + W**

**(C) Ctrl + R**

**(D) Ctrl + C**

**Q.NO.19 What is the default column width of MS Excel?**

**(A) 5.5**

**(B) 2.98**

**(C) 6.49**

**(D) 8.43**

**Q.NO.20 Press ____ to make the text bold in MS Excel.**

**(A) Ctrl + A**

**(B) Ctrl + B**

**(C) Ctrl + H**

**(D) Ctrl + L**

**B****B****A****A****C****A****C****D****A****A****D****A****B****C****A****D****B****A****D****B**