MS Excel MCQ Set-1,2 & 3 | MS Excel MCQ Question and Answers

Posted on

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?

  1. Column
  2. Value
  3. Address
  4. Cell

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

  1. Pie chart
  2. Column chart
  3. Line chart
  4. Dot chart

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

  1. NUM
  2. COUNT
  3. SUM
  4. CHKNUM

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

  1. Formula
  2. Sorting
  3. Filtering
  4. Pivot

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

  1. Adobe photo shop
  2. Excel
  3. Notepad
  4. Power Point

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

  1. Column
  2. Line chart
  3. Pie chart
  4. Dot chart

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

  1. SUM
  2. AVG
  3. MAX
  4. MIN

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

  1. An () sign
  2. An equal sign
  3. A plus sign
  4. A > sign

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

  1. SUM
  2. COUNT
  3. IF
  4. AVERAGE

Q. NO 10 In Excel, columns are labelled as_

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

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

  1. Arithmetic
  2. Logical operator
  3. Conditional
  4. Greater

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

  1. Pie chart
  2. Column chart
  3. Line chart
  4. Dot Graph

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

  1. Arranging
  2. Autofill
  3. Sorting
  4. Filtering

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

  1. Auto complete
  2. Auto fill
  3. Fill Handle
  4. Sorting

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

  1. Pie chart
  2. Column chart
  3. Line chart
  4. Dot chat
  1. D
  2. B
  3. B
  4. C
  5. B
  6. C
  7. B
  8. B
  9. C
  10. C
  11. B
  12. C
  13. C
  14. B
  15. C

SET-2

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

  1. Title bar
  2. Formula bar
  3. Work sheet table
  4. Name box

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

  1. Cells
  2. Zoom slider
  3. Help button
  4. All of these

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

  1. Cells
  2. Character
  3. Browser
  4. Formula

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

  1. Cell
  2. Graph
  3. Function
  4. Range

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

  1. Slide presentation
  2. Spreadsheet
  3. Text document
  4. Data base

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

  1. Formula
  2. View
  3. Insert
  4. Home tab

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

  1. Address
  2. Formula
  3. Name
  4. Label

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

  1. Filter
  2. Wrap
  3. Pivot
  4. Marge

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

  1. Bar
  2. Pai
  3. Line
  4. Functions

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

  1. Equal sign
  2. Colon
  3. Comma
  4. Space

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

  1. Previous state
  2. Next state
  3. Current state
  4. 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.

  1. List
  2. Section
  3. Range
  4. Area

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

  1. .xls
  2. .xks
  3. .xos
  4. .xds

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

  1. Alt + f4
  2. Ctrl + W
  3. Ctrl + R
  4. Ctrl + C

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

  1. Chart area
  2. Legend
  3. Clipart area
  4. Pivot area
  1. C
  2. A
  3. C
  4. C
  5. B
  6. D
  7. A
  8. D
  9. B
  10. A
  11. C
  12. C
  13. A
  14. A
  15. 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

https://youtu.be/mE4BThGkQxg

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

  1. B
  2. B
  3. A
  4. A
  5. C
  6. A
  7. C
  8. D
  9. A
  10. A
  11. D
  12. A
  13. B
  14. C
  15. A
  16. D
  17. B
  18. A
  19. D
  20. B

Leave a Reply

Your email address will not be published. Required fields are marked *