32. To save an existing document with a different file name, click
(1) save button on the standard toolbar
(2) save on the file menu
(3) save as button on the standard toolbar
(4) save as on the file menu
(5) None of the above
33. Insert date, format page number and insert auto text are buttons on the ……….. toolbar.
(1) formatting
(2) header and footer
(3) standard
(4) edit
(5) None of these
34. To increase the line spacing, use the…… shortcut keys.
(1) Ctrl + L
(2) Ctrl + E
(3) Ctrl + 1
(4) Ctrl + M
(5) None of these
35. Word has a list of predefined typing, spelling, capitalisation and grammar errors that ……….. can defect and correct.
(1) auto entry
(2) auto correct
(3) auto add
(4) auto spell
(5) auto word
36. Borders can be applied to
(1) cells
(2) paragraph
(3) text
(4) All of these
(5) None of these
37. Which of the following characteristics is used to compute dynamically the results from Excel data? [IBPS Clerk 2012]
(1) Goto
(2) Table
(3) Chart
(4) Diagram
(5) Formula and function
38. What is the default left margin in word document?
(1) 1.0
(2) 1.15
(3) 1.5
(4) 2.0
(5) 2.5
39. In this chart, only one data series can be plotted
(1) pie
(2) line
(3) bar
(4) column
(5) None of these
40. This chart shows the relationship of parts to a whole
(1) pie
(2) line
(3) stacked bar
(4) embedded
(5) None of these
41. Which of the following is not a font style
(1) Bold
(2) Italics
(3) Regular
(4) Super script
(5) Bold Italics
42. It is a software tool that lets one enter calculate, manipulate set of numbers
(1) speedsheet
(2) spre heet
(3) slide sheet
(4) All of these
(5) None of these
43. It is a grid of cells made up of horizontal and vertical columns
(1) worksheet
(2) sheet
(3) excel sheet
(4) page
(5) work book
44. Group of worksheets is known by
(1) folder
(2) document
(3) workbook
(4) books
(5) files
45. Which one is the example of spre hes package? [IBPS Clerk 2011 (1) Visicale
(2) Unity
(3) Ada
(4) Snowball
(5) None of these
46. Portrait and landscape are
(1) page orientation
(2) paper size
(3) page layout
(4) page margin
(5) page gap
47. Three types of data can be entered in a worksheet, number/characters text and
(1) formulas
(2) functions
(3) logic
(4) All of these
(5) None of these
48. To select the current column press
(1) Ctrl + Spacebar
(2) Ctrl + B
(3) Shift + Enter
(4) Ctrl + Enter
(5) Ctrl + Shift
49. Scatter chart is also known as
(1) XX chart
(2) YX chart
(9) XY chart
(4) YY chart
(5) XZ chart
50. The extension of saved file in MS-Excel is
(1) .XIS
(2) .XAS
(3) .XLSX
(4) .XLL
(5) .LXS
51. A cell entry can be edited in the cell or in the
(1) menu bar
(2) edit menu
(3) function bar
(4) formula bar
(5) None of these
52. In Microsoft PowerPoint two kinds of sound effect files can be added to the presentation are
(1) .wav files and mid files
(2) .wav files and .gif files
(3) .wav files and jpg files
(4).jpg files and .gif files
(5) None of the above
53. A chart placed in a worksheet is called
(1) formatting chart
(2) embedded chart
(3) aligning chart
(4) hanging chart
(5) None of the above
54. Which file format can be added to a PowerPoint show?
(1) .Jpg
(2) .giv
(9) .wav
(4) All of these
(5) None of these
55. The advantage of using a spre heet is
(1) calculations can be done automatically
(2) changing data automatically updates calculations
(3) more flexibility
(4) All of the above
(5) None of the above
56. Which of the following should you use if you want all the slides in the presentation to have the same ‘look’?
(1) The slide layout option
(2) Add a slide option
(3) Outline view
(4) A presentation design template
(5) None of the above
57. The cell having bold boundary is called
(1) relative
(2) active
(3) absolute
(4) mixed
(5) passive
58. Cell address A4 in a formula means it is an
(1) mixed cell reference
(2) absolute cell reference
(3) relative cell reference
(4) All of the above
(5) None of the above
59. Which of the following is an active cell in Excel? [IBPS Clerk 2011]
(1) Current cell
(2) Formula
(3) Range
(4) Cell address
(5) None of these
60 . In Excel, an active can be represented by
(1) 4A
(2) A4
(9) A$4
(4) $A$4
(5) $A4
61. Which option will we use to give heading in the form?
(1) Label
(2) Text box
(3) Option group
(4) Insert
(5) None of these
62. The maximum zoom percentage in MS Power Point is [IBPS Clerk 2009]
(1) 100%
(2) 200%
(3) 400%
(4) 500%
(5) None of these
63. In the context of animations, what is a trigger?
(1) An action button that allvances to the next slide
(2) An item on the slide that performs an action when clicked
(3) The name of a motion path
(4) All of the above
(5) None of the above
64. How are the data organised in a spre heet? [SBI Clerk 2008]
(1) Lines and spaces
(2) Layers and planes
(3) Height and width
(4) Rows and columns
(5) None of these
65. Which of the following views is the best view to use when setting transition effects for all slides in presentation?
(1) Slide sorter view
(2) Notes pages view
(3) Slide view
(4) Outline view
(5) None of the above
66. Which command brings you to the first slide in your presentation?
(1) Next slide button
(2) Pageup
(3) Ctrl + Home
(4) Ctrl + End
(5) None of these
67. In order to include picture data type must be
(1) OLE
(2) hyperlink
(3) Yes/No
(4) picture
(5) None of these
[RBI PO 2009)
68. In Excel, charts are created using which option? [SBI Clerk 2009]
(1) Chart wizard
(2) Pivot table
(3) Pie chart
(4) Bar chart
(5) None of these
69. Which of the following allow you to select more than one slide in a presentation?
(1) Alt + click each slide
(2) Shift + drag each slide
(3) Shift + click each slide
(4) Ctrl + click each slide
(5) None of the above
70. The basic unit of a worksheet into which you enter data in excel is called a [1BPS Clerk 2008]
(1) tab
(2) cell
(3) box
(4) range
(5) None of these
71. You can create hyperlinks from the excel work book to
(1) a web page on company internet
(2) a web page on the internet
(3) other office 97 application documents
(4) All of the above
(5) None of the above
72. In Excel, this is a prerecorded formula that provides a shortcut for complex calculations.
(1) value
(2) data series
(3) function
(4) field
(5) None of these
73. Which of the following should be used to move a paragraph from one place to another in a word document?
(1) Copy and paste
(2) Cut and paste
(3) Delete and retype
(4) Find and replace
(5) None of these
74. In PowerPoint, the Header and Footer button can be found on the insert tab in what group? [IBPS PO, Clerk 2012]
(1) Illustrations group
(2) Object group
(3) Insert group
(4) Tables group
(5) None of these
75. A……….. is an additional set of commands that the computer displays after you make a selection from the main menu. [SBI Clerk 2009)
(1) dialog box
(2) sub menu
(3) menu selection
(4) All of these
(5) None of these
76. In Excel, ……….. allows users to bring together copies of workbooks that other users gave worked on independently. [IBPS PO 2011]
(1) copying
(2) merging
(3) pasting
(4) compling
(5) None of these
77. Pressing Ctrl + F9 in Excel
(1) prints 9 worksheets
(2) prints a sheet
(3) prints 9 followed by spaces
(4) insert 9 cells at the current location
(5) None of the above
78. Cell address $A4 in a formula means it is a
(1) mixed cell reference
(2) absolute cell reference
(3) relative cell reference
(4) All of the above
(5) None of the above
79. Pie charts are typically created by using which of the following?
(1) Browser software
(2) Database software
(3) Desktop publishing software
(4) Word processing software
(5) Spre heet software
80. Which of the following justification align the text on both the sides left and right of margin? [IBPS Clerk 2012
(1) Right
(2) Justify
(3) Both sides
(4) Balanced
(5) None of these
81. What is the default size of the data type in MS Access? [SBI Clerk 2016
(1) 50
(2) 60
(3) 70
(4) 80
(5) None of these
82. To move the text from its original position to another position without deleting it is called
(1) scrolling
(2) searching
(3) moving
(4) copying
(5) halting
83. Attributes can be defined for [SBI Clerk 2009]
(1) entity
(2) switch board
(3) macro
(4) pages
(5) None of these
84. MS Excel is used for [SBI Clerk 20121
(1) letter writing
(2) spre heet calculation
(9) presentation
(4) painting
(5) None of the above
85.=sum(61 : 610) is an example of a
(1) function
(2) formula
(3) cell address
(4) value
(5) None of these
86. …………… shows how the contents on printed page will appear with margin, header and footer.
(1) Draft
(2) Full screen reading
(3) Outline
(4) Page layout
(5) None of these
87. How many types of relationships are there in MS Access?
(1) 3
(2) 4
(3) 5
(4) 6
(5) None of these
88. A word processor would be used best to
(1) paint a picture
(2) draw a diagram
(3) type a story
(4) work out income and expenses
(5) None of the above
89. In order to choose the font for a sentence in a word document [IBPS clerk 2012]
(1) select font in the format menu
(2) select font in the edit menu
(3) select font in the tools menu
(4) select font in the view menu
(5) None of the above
90. The shortcut key to print documents is [IBPS PO 2012]
(1) Ctrl + D
(2) Ctrl + A
(3) Ctrl + B
(4) Ctrl + c
(5) Ctrl + P
91. What is the extension of PowerPoint in Microsoft Office 2007?
(1).ppt
(2) .pptx
(3) .ppx
(4) .ptx
(5) .pt
92. All of the following terms are related to spre heet software except [SBI Clerk 2011)
(1) worksheet
(2) cell
(3) formula
(4) virus detection
(5) None of these
93. There are a total of ………. actions button in PowerPoint. [SBI Clerk 2012)
(1) 12
(2) 15
(3) 16
(4) 18
(5) None of these
94. Which of the following is a DBMS software?
(1) Access
(2) Excel
(3) Word
(4) Powerpoint
(5) None of these
95. Which of the following displays the buttons for changing text style, alignment and size?
(1) Standard toolbar
(2) Status bar
(3) Drawing toolbar
(4) Formatting toolbar
(5) None of the above
96. Which of the following is not a term pertaining to word? [IBPS Clerk 2011]
(1) Delete
(2) Edit
(3) Copy
(4) Slide show
(5) None of these
97. Which key on the keyboard can be used to view slide show?
(1) F1
(2) F2
(3) F5
(4) F10
(5) None of these
98. PowerPoint provides ……… number of layouts for use with blank presentation.
(1) 20
(2) 22
(3) 24
(4) 26
(5) None of these
99. What is the shortcut key for centering the text selected by the user in word? [IBPS Clerk 2011]
(1) Ctrl + A
(2) Ctrl + B
(3) Ctrl + C
(4) Ctrl + D
(5) Ctrl + E
100. What does an electronic spre heet consist [IBPS Clerk 2011]
(1) Rows
(2) Columns
(3) Cells
(4) All of these
(5) None of these