4. Which of the following is / are the additional features of Ms Word 2007?
Correct : D. all the above
5. In Microsoft Word shortcut key CTRL+W is used for
Correct : C. close the current window
6. Which shortcut key is used to spell check in MS-Word?
Correct : C. f7
7. Why headers and footers used in MS -Word
Correct : D. to allow page headers and footers to appear on document when it is printed
8. The minimum number of rows and columns a word table can have is
Correct : D. 1 row and 1 column
9. In MS-Word shortcut SHIFT+DELETE is used to
Correct : A. delete the selected item permanently without placing the item in the recycle bin
10. In MS Word to move the insertion point to the beginning of the next word command
used is
Correct : A. ctrl+rightarrow
11. Which of the following line spacing is invalid?
Correct : C. triple
12. How can you apply exactly the same formatting you did to another text?
Correct : B. select the text then click on format painter and select the new text
13. What should you do if you require pasting the same format in many places?
Correct : A. double click the format painter then go on pasting in many places
14. On which toolbar can you find Format Painter tool?
Correct : D. standard toolbar
15. Which indent marker controls all the lines except first line?
Correct : A. left indent marker
16. Which operation you will perform if you need to move a block of text?
Correct : C. cut and paste
17. What is the extension of Word files?
Correct : D. doc
18. Which of the following option is not available in Insert >> Picture?
Correct : B. graph
19. To insert a drop cap in one of the paragraph you should access
Correct : A. format
20. How many different positions can you set for drop cap?
Correct : B. 2
21. Which of the following can NOT be used to create parallel style column?
Correct : D. format columns
22. Which of the following is used to create newspaper style columns?
Correct : A. format columns
23. Columns dialog box can be opened from...
Correct : D. all of above
24. You can jump to the next column by
Correct : C. both of above
25. To open Columns dialog box quickly..
Correct : A. double click the space between area on ruler
26. Which of the following command is not available in Tools menu?
Correct : D. auto text
27. Text boundary can be displayed or hidden from
Correct : C. options from tools menu
28. Which of the following is / are word processing software?
Correct : D. all of above
29. MS Office provides help in many ways, which of these is one of them?
Correct : D. all of the above
30. What is the maximum scale percentage available in Scale drop down box?
Correct : B. 200
31. Bold, Italic, Regular are known as
Correct : C. font styles
32. Changing the appearance of a document is called
Correct : C. formatting
33. In a document what is the maximum number of columns that can be inserted in MS
Word Table?
Correct : C. 63
34. A screen element of MS Word that is usually located below the title bar that provides
categorized options is...
Correct : B. menu bar
35. A ____________ is a small program that helps to automate a frequently used series of
commands in most productivity software tools.
Correct : A. macro
36. Which of the following is the second step in creating a macro?
Correct : C. assign a keyboard shortcut to the macro
37. If you will be displaying or printing your document on another computer, you’ll want
to make sure and select the _____________ option under the ‘Save’ tab.
Correct : A. embed true type fonts
38. In Word, the mailing list is known as the ____________.
Correct : A. data source
39. Which of the following button will allow you to add, delete, or change records in your
Data Source?
Correct : D. ‘edit data source’ button
40. It is possible to _______ a data source before performing a merge.
Correct : D. all of the above
41. What is the default font size of a new Word document based on Normal template?
Correct : B. 12 pt
42. What is the default font used in MS Word document?
Correct : A. times new roman
43. Which tab in Font dialog box contains options to apply font effects?
Correct : C. font tab
44. Drop Cap means
Correct : D. none of above
45. Which function of Ms Word enables you to create multiple mails at a time?
Correct : B. mail merge
46. Which of the following is not valid version of MS Office?
Correct : D. none of above
47. You cannot close MS Word application by
Correct : D. from file menu choose close submenu
48. The key F12 opens a
Correct : A. save as dialog box
49. What is the short cut key to open the Open dialog box?
Correct : D. ctrl + f12
50. A feature of MS Word that saves the document automatically after certain interval is
available on
Correct : A. save tab on options dialog box
51. Where can you find the horizontal split bar on MS Word screen?
Correct : C. on the top of vertical scroll bar
52. Which of the following is not available on the Ruler of MS Word screen?
Correct : D. center indent
53. What is place to the left of horizontal scroll bar?
Correct : B. view buttons
54. Which file starts MS Word?
Correct : A. winword.exe
55. How many ways you can save a document?
Correct : A. 3
56. If you want to keep track of different editions of a document which features will you
use?
Correct : B. versions
57. Background colour or effects applied on a document is not visible in
Correct : D. print preview
58. What is a portion of a document in which you set certain page formatting options?
Correct : C. section
59. Borders can be applied to
Correct : D. all of above
60. Which of the following is not a type of page margin?
Correct : C. centre
61. What is the default left margin in Word 2007document?
Correct : B. 1.25"
62. What is gutter margin?
Correct : C. margin that is added to the binding side of page when printing
63. Portrait and Landscape are
Correct : A. page orientation
64. If you need to change the typeface of a document, which menu will you choose?
Correct : C. format
65. Which of the following is not a font style?
Correct : D. superscript
66. ------------- is a spread sheet application
Correct : C. ms excel
67. Who is considered as father of electronic spread sheet?
Correct : A. dan bricklin
68. Which of the following is / are the additional features of Ms Excel 2007?
Correct : D. all the above
69. A file in Ms Excel is Called----------
Correct : B. work book
70. A work book is a collection of ----------- used in a single file
Correct : A. work sheet
71. A function inside another function is called _______
Correct : A. nested function
72. Which of the following is not an underline option in the format cells dialog box?
Correct : D. single engineering
73. Formulas in Excel start with
Correct : B. =
74. The default header for a worksheet is
Correct : C. sheet tab name
75. Which of the following is not an option of the spelling dialog box?
Correct : C. edit
76. Which of the following methods will not enter data in a cell?
Correct : A. pressing the esc key
77. The cell reference for cell range of F2 to P12 is _______
Correct : C. f2:p12
78. What is the keyboard shortcut for creating a chart from the selected cell range?
Correct : D. f11
79. The Software which contains rows and columns is called ______
Correct : C. spreadsheet
80. You can group non-contiguous worksheets with
Correct : B. the ctrl key and mouse
81. Which of the following is not a valid Zoom percentage in Excel?
Correct : D. 500
82. The spelling tool is placed on ______ toolbar
Correct : A. standard
83. If you need a text to show vertically in a cell. How will you achieve this?
Correct : B. choose 90 degrees in orientation of format cells dialog box
84. Can you set 0.5 inch left indentation for a cell in Excel?
Correct : C. indentation can be set from format cells dialog box
85. You can automatically adjust the size of text in a cell if they do not fit in width by
Correct : C. from format cells dialog box mark shrink to fit check box
86. Formatting a cell in Currency, you can specify
Correct : C. both of above
87. Formatting a cell in Number format you can’t set
Correct : D. currency symbol
88. What is entered by the function =today()
Correct : B. the time value according to system clock
89. Which function will you use to enter current time in a worksheet cell?
Correct : C. =time()
90. Special category of Number tab in Format Cells dialog box can be used to apply
formats like
Correct : C. both of above
91. Merge cells option can be applied from
Correct : C. both of above
92. Pre-made sheet formats like Simple, Classic, Accounting, Colourful etc. can be applied
from
Correct : B. from format >> auto format
93. Which of the following format you can decide to apply or not in AutoFormat dialog
box?
Correct : D. all of above
94. How can you remove borders applied in cells?
Correct : C. both of above
95. Where can you set the shedding colour for a range of cells in Excel?
Correct : D. all of above
96. You can set Page Border in Excel from
Correct : D. you cannot set page border in excel
97. When all the numbers between 0 and 100 in a range should be displayed in Red
Colour, apply
Correct : B. apply conditional formatting command on format menu
98. You can check the conditions against __________ when applying conditional
formatting
Correct : C. both of above
99. Which of the following is not true regarding Conditional Formatting?
Correct : C. you can apply font, border and pattern formats that meets the specified conditions
100. In Microsoft Excel 2007, the ----------- is used to issue commands