9.MCQ Microsoft Office

 

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