Ms Excel MCQ

MS EXCEL MCQ - BY Manoj Gurukul Academy

MS Excel MCQ

  

Choose correct of one and press next button and also so your correct marks for each question submition.

 

1. What is the intersection of a column and a row on a worksheet called ?
   1.   Column
   2.   Value
   3.   Address
   4.   Cell
2. 
   What type of chart is useful for comparing values over categories ?
   1.   Pie Chart
   2.   Column Chart
   3.   Line Chart
   4.   Dot Graph
3. 
   Which functionin Excel tells how many numeric entries are there ?
   1.   NUM
   2.   COUNT
   3.   SUM
   4.   CHKNUM
4. A features that displays only the data in column (s) according to specified criteria
   1.   Formula
   2.   Sorting
   3.   Filtering
   4.   Pivot
5. Statistical calculations and preparation of tables and graphs can be done using
   1.   Adobe Photoshop
   2.   Excel
   3.   Notepad
   4.   Power Point
6. Which one is not a Function in MS Excel ?
   1.   SUM
   2.   AVG
   3.   MAX
   4.   MIN
7. Functions in MS Excel must begin with ___
   1.   An () sign
   2.   An Equal Sign
   3.   A Plus Sign
   4.   A > Sign
8. In Excel, Columns are labelled as ___
   1.   A, B, C, etc
   2.   1,2,3 etc
   3.   A1, A2, etc.
   4.   $A$1, $A$2, etc.
9. What type of chart is useful for comparing parts of a whole ?
   1.   Pie Chart
   2.   Column Chart
   3.   Line Chart
   4.   Dot Graph
10. 
    In Excel, Rows are labelled as ______
    1.   A, B, C, etc
    2.   1,2,3 etc
    3.   A1, A2, etc.
    4.   $A$1, $A$2, etc.
11. What do you use to create a chart?
    1.   Pie Wizard
    2.   Excel Wizard
    3.   Data Wizard
    4.   Chart Wizard
12. The basic unit of a worksheet into which you enter data in Excel is called a
    1.   cell
    2.   table
    3.   box
    4.   column
13. How many sheets are there, by default, when we create a new Excel file ?
    1.   1
    2.   3
    3.   5
    4.   10
14. In Excel, which one denoted a range from B1 through E5
    1.   B1 - E5
    2.   B1:E5
    3.   B1 to E5
    4.   B1$E5
15. An Excel file is generally called a / an :
    1.   E-Spreadsheet
    2.   Worksheet
    3.   Workbook
    4.   Sheet
16. It is a collection of data that is stored electronically as a series of records in a table.
    1.   spreadsheet
    2.   presentation
    3.   database
    4.   MS Word
17. What type of chart will you use to compare performance of sales of two products ?
    1.   Column Chart
    2.   Line Chart
    3.   Pie Chart
    4.   Both A and B
18. On an excel sheet the active cell in indicated by ?
    1.   A dotted border
    2.   A dark wide border
    3.   A blinking border
    4.   By italic text
19. The default style for new data keyed in a new workbook is ?
    1.   Comma
    2.   Normal
    3.   Currency
    4.   Percent
20. If you press ___, the cell accepts your typing as its contents ?
    1.   Tab
    2.   Ctrl+Enter
    3.   Enter
    4.   Alt+Enter
21. Formula palette is used to ?
    1.   format cells containing numbers
    2.   create and edit formulas containing functions
    3.   entered assumptions data
    4.   copy all cells
22. A value used in a formula that does not change is called a ?
    1.   Constant
    2.   Cell address
    3.   Varaible
    4.   Static
23. A Spreadsheet contains ?
    1.   columns
    2.   rows
    3.   rows and columns
    4.   None of above
24. To open an existing workbook, click the Open button on the ___ toolbar ?
    1.   Form
    2.   Standard
    3.   Drawing
    4.   Formatting
25. Which among following is not associated with spelling dialogue box ?
    1.   Edit
    2.   Ignore
    3.   Ignore All
    4.   Change
26. what term describes a background that appears as a grainy, non smooth surface ?
    1.   Pattern
    2.   Gradient
    3.   Texture
    4.   Velvet
27. Which among following is associated with excel ?
    1.   Graphic program
    2.   Word Processor
    3.   Presentation
    4.   Spreadsheet
28. What function displays row data in a column or column data in a row ?
    1.   Transpose
    2.   Index
    3.   Rows
    4.   Hyperlinks
29. Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result ?
    1.   NOT
    2.   OR
    3.   IF
    4.   AND
30. Macros can be executed from the which of the following menu ?
    1.   Format
    2.   Home
    3.   Insert
    4.   Tools
31. Protection and the Protect Sheet options can be selected from ?
    1.   Data
    2.   Tools
    3.   Edit
    4.   Format
32. Which of the following is not a valid Zoom percentage in Excel ?
    1.   10
    2.   100
    3.   300
    4.   500
33. You can check the conditions against ____ when applying conditional formatting ?
    1.   Cell Value
    2.   Formula
    3.   Both of above
    4.   None of above
34. How can we set Page Border in Excel ?
    1.   From Edit menu
    2.   From Home
    3.   You can not set page border in Excel
    4.   From Tools menu
35. Which function calculates your monthly mortage payment ?
    1.   PV
    2.   NPER
    3.   PMT
    4.   All of above
36. VLOOKUP function used to ?
    1.   Finds related records
    2.   Looks up text that contain "v"
    3.   Check if two cells are identical
    4.   None of above
37. Gridlines may be turned off for display but turned on for printing.
    1.   True
    2.   False
38. How do you change column width to fit the contents ?
    1.   Single-click the boundary to the left to the column heading
    2.   Double click the boundary to the right of the column heading
    3.   Press Alt and single click anywhere in the column
    4.   All of above
39. To insert three columns between columns A and B you would
    1.   Select column A
    2.   Select A and B
    3.   Select B
    4.   All of above
40. To drag a selected range of data to another worksheet in the same workbook, use the ?
    1.   Ctrl key
    2.   Shift key
    3.   Alt key
    4.   Tab key
41. You can activate a cell by ?
    1.   Pressing the Tab key
    2.   Clicking the cell
    3.   Pressing an arrow key
    4.   All of above
42. Which function is used for creating a data table ?
    1.   Sum
    2.   Table
    3.   Add
    4.   Count
43. The accounting style shows negative numbers in ?
    1.   Bold
    2.   Italics
    3.   Parentheses
    4.   Quotes
44. 3-D reference in a formula ?
    1.   Spans worksheets
    2.   Can not be modified
    3.   Only appears on summary worksheets
    4.   Limits the formatting options
45. Auto calculate feature provides a quick way to view the results of an arithmetic operation on a range of cells.
    1.   True
    2.   False
46. Which among following is divide symbol in excel ?
    
    1.   /
    2.   D
    3.   Div
    4.   \
47. Which function in excel counts the numbers of characters in a cell ?
    1.   LENGHT
    2.   LGT
    3.   LT
    4.   LEN
48. Which function converts miles to kilometers ?
    1.   Change
    2.   Convert
    3.   Shift
    4.   Conv
49. What is shortcut to enter current date in cell in excel ?
    1.   Ctrl + ;
    2.   Alt + ;
    3.   Shift + &
    4.   Ctrl + $
50. Shortcut to edit the selected cell ?
    1.   F3
    2.   F8
    3.   F4
    4.   F2
51. Each excel can contain many sheets including worksheets and chart sheets.
    1.   True
    2.   False
52. Which shortcut can be used to Switch between open workbooks ?
    1.   Ctrl + F2
    2.   Ctrl + F6
    3.   Ctrl + F8
    4.   Ctrl + F10
53. Shortcut to delete the selected column ?
    1.   Ctrl + -
    2.   Alt + -
    3.   Shift + -
    4.   Insert + -
54. Shortcut to enter current date ?
    1.   Home + ;
    2.   Shift + ;
    3.   Alt + ;
    4.   Ctrl + ;
55. When the formula bar is activated, you can see
    
    1.   The Edit Formula button
    2.   The Cancel button
    3.   The Enter button
    4.   All of above
56. Style sheet formats can be applied from ?
    1.   Table >> Autoformat
    2.   Format >> Autoformat
    3.   Table >> Cells
    4.   Fromat >> Cells
57. Which function will you use to enter current time in a woksheet cell ?
    1.   =time()
    2.   =nowtime()
    3.   =now()
    4.   =currentTime()
58. Merge cells option can be applied from ?
    
    1.   Formatting toolbar
    2.   Format Cells dialog box Alignment Tab
    3.   Both of above
    4.   None of above
59. How many recent files you can display on File menu at maximum ?
    1.   3
    2.   7
    3.   9
    4.   15
60. The name box appears at the ?
    1.   left of the formula bar
    2.   right of the formula bar
    3.   below the status bar
    4.   below the menu bar
61. Entire worksheet can not be selected in one time.
    1.   True
    2.   False
62. Where are the status indicators located ?
    1.   Horizontal Scroll
    2.   Vertical Scroll
    3.   Formula bar
    4.   Address bar
63. Insert picture option is in which of the following toolbars ?
    1.   Standard
    2.   Formatting
    3.   Drawing
    4.   Picture
64. What term refers to a specific set of values saved with the workbook ?
    1.   Range
    2.   File set
    3.   Data set
    4.   Scenario
65. We can cancel marquee by pressing ?
    1.   Ctrl + Esc
    2.   Alt + Esc
    3.   Shift + Esc
    4.   Esc
66. Which of the following methods cannot be used to edit the content of cell ?
    1.   Pressing F2
    2.   Clicking the formula bar
    3.   Pressing the Alt key
    4.   Double clicking the cell
67. Which among following can't be considered as worksheet criterion ?
    1.   Efficiency
    2.   Auditability
    3.   Clarity
    4.   Description
68. The intersection of row and column is called a ?
    1.   dataset
    2.   cell
    3.   data
    4.   set
69. You will use which feature in excel, if you want to work with one record at a time ?
    1.   Auto Complete
    2.   Auto Filter
    3.   Sub Totals
    4.   Data Form
70. Which dialogue box we can use to name a constant ?
    1.   Create Name
    2.   Define Name
    3.   Get Name
    4.   Create Constant
71. One cell format can be copied to another cell by using ?
    
    1.   Format Painter
    2.   Format Setting
    3.   Format Showing
    4.   Format Checking
72. To join some cells and place the content at the middle of joined cell, which tool you will use?
    1.   From Format Cells dialog box choose Merge and Center check box
    2.   Click on Merge and Center tool on formatting toolbar
    3.   From Format Cells dialog box select the Centered alignment
    4.   From Format Cells dialog box click on Merge Cells check box
73. On Excel screen, Tab scroll buttons are
    1.   towards the top left corner
    2.   towards the top right corner
    3.   towards the bottom right corner
    4.   towards the bottom left corner
74. Choose from the following, which is not the correct method of editing the cell content ?
    1.   Press the Alt key
    2.   Press the F2 key
    3.   Double click the cell
    4.   Click the formula bar
75. On Excel screen, Tab scroll buttons are
    1.   towards the top left corner
    2.   towards the top right corner
    3.   towards the bottom right corner
    4.   towards the bottom left corner
76. In Paste Special dialog box, which of the following option is not available ?
    1.   Divide
    2.   Add
    3.   Subtract
    4.   Square root
77. Which key is used for help in Ms Excel?
    1.   F1
    2.   F2
    3.   F3
    4.   None of these
78. Which key is used to Repeat last action in Ms Excel?
    1.   F9
    2.   F7
    3.   F5
    4.   (d) F4
79. Which key is used to “Goto” tab in Ms Excel?
    1.   F9
    2.   F7
    3.   F6
    4.   F5
80. Which keys are used to Open tab in Ms Excel?
    1.   Ctrl+u
    2.   Ctrl+p
    3.   Ctrl+O
    4.   Ctrl+g
81. Which of these keys are used in Ms Excel for redo?
    1.   Ctrl+n
    2.   Ctrl+v
    3.   Ctrl+z
    4.   Ctrl+Y
82. Which of these keys are used in Ms Excel to Insert current time in workbook?
    1.   Ctrl+ ”
    2.   Ctrl+Shift+ ;
    3.   Ctrl+ :
    4.   Ctrl+T
83. Which of these keys are used in Ms Excel to copy value from above cell?
    1.   Ctrl+ ”
    2.   Ctrl+ ;
    3.   Ctrl+ :
    4.   Ctrl+ O
84. Which of these keys are used in Ms Excel for spell checking?
    1.   F8
    2.   F7
    3.   F5
    4.   F4
85. To opne new chart in Ms Excel:
    1.   F8
    2.   F9
    3.   F11
    4.   F12
86. To Select All in Ms Excel:
    1.   Ctrl+ A
    2.   Ctrl+ B
    3.   Ctrl+ C
    4.   Ctrl+ D
87. To find text in Ms Excel:
    1.   Ctrl+ J
    2.   Ctrl+ E
    3.   Ctrl+ H
    4.   Ctrl+ F
88. To replace text in Ms Excel:
    1.   Ctrl+ J
    2.   Ctrl+ E
    3.   Ctrl+ H
    4.   Ctrl+ F
89. Comments put in cells in Ms Excel are called:
    1.   Smart tip
    2.   Web tip
    3.   Cell tip
    4.   Soft Tip
90. Hyperlinks can be in:
    1.   Text
    2.   Pictures
    3.   Drawing objects
    4.   All of above
91. Move to next worksheet in Ms Excel:
    1.   Ctrl + Page Up
    2.   Page Up
    3.   Ctrl + Page Down
    4.   None of These
92. Apply outline borders in Ms Excel :
    1.   Ctrl + Shift + 7
    2.   Ctrl + Shift + 9
    3.   Ctrl + Shift + 8
    4.   None of These
93. Wrap text in same cell in Ms Excel:
    1.   Alt +Enter
    2.   Alt + Tab
    3.   Alt + shift
    4.   None of These
94. Select font in Ms Excel:
    1.   Ctrl+Shift+C
    2.   Ctrl+Shift+F
    3.   Ctrl+Shift+J
    4.   None of these
95. Insert columns/rows in Ms Excel:
    1.   Ctrl + Shift + + (plus sign)
    2.   Ctrl + alt + + (plus sign)
    3.   Shift + Ctrl + + (plus sign)
    4.   None of These
96. Delete one character to left in Ms Excel:
    1.   Delete
    2.   Backspace
    3.   End
    4.   None of these
97. How do you insert a row?
    1.   Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
    2.   Select the row heading where you want to insert the new row and select Edit >Row from the menu
    3.   Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
    4.   All of the above
98. The name box
    1.   Shows the location of the previously active cell
    2.   Appears to the left of the formula bar
    3.   Appears below the status bar
    4.   Appears below the menu bar
99. Which is used to perform what if analysis?
    1.   Solver
    2.   Goal seek
    3.   Scenario Manager
    4.   All of above
100. Status indicators are located on the
     1.   Vertical scroll bar
     2.   Horizontal scroll bar
     3.   Formula bar
     4.   Standard toolbar