1. From which menu you can insert Header and Footer?
Correct : A. Insert Menu
2. To get to the ‘Symbol’ dialog box, click on the ______ menu and choose ‘Symbol’.
Correct : A. Insert
3. _______ option from clipboard is used to move data from one place to another in a
document.
Correct : B. Cut & Paste
4. ______ is an option in Font Group.
Correct : A. Strikethrough
5. Name the button in the picture?
Correct : D. Highlighter tool
6. Shortcut for document views toolbar is situated in ______ bar.
Correct : B. Status bar
7. Bullets and Numbering is in _____ tab.
Correct : A. Home tab
8. To open a existing document, click on the ________ and then select Open.
Correct : A. MS Office button
9. Cut, Copy and Paste is in ________ Group in the Home tab.
Correct : C. Clipboard
10. _______ is used to covert from upper case to lower case and vice versa.
Correct : A. Toggle case
11. Pressing F8 key for three times selects
Correct : B. A sentence
12. What is the shortcut key you can press to create a copyright symbol?
Correct : A. Alt+Ctrl+C
13. What is the smallest and largest font size available in Font Size tool on formatting
toolbar?
Correct : A. 8 and 72
14. Which of the following is graphics solution for Word Processors?
Correct : A. Clipart
15. The keystrokes Ctrl + I is used to
Correct : D. Applies italic format to selected text
16. A character that is raised and smaller above the baseline is known as
Correct : C. Superscript
17. Thesaurus tool in MS Word is used for
Correct : C. Synonyms and Antonyms words
18. Why Drop Caps are used in document?
Correct : C. To begin a paragraph with a large dropped initial capital letter
19. A bookmark is an item or location in document that you identify as a name for future
reference. Which of the following task is accomplished by using bookmarks?
Correct : C. To quickly jump to specific location in document
20. Which of the following is not valid version of MS Office?
Correct : B. Office Vista
21. You cannot close MS Word application by
Correct : D. From File menu choose Close submenu
22. The key F12 opens a
Correct : A. Save As dialog box
23. What is the short cut key to open the Open dialog box?
Correct : D. Ctrl + F12
24. . A feature of MS Word that saves the document automatically after certain interval is
available on
Correct : A. Save tab on Options dialog box
25. Which of the following is not available on the Ruler of MS Word screen?
Correct : D. Center Indent
26. Which file starts MS Word?
Correct : A. Winword.exe
27. If you want to keep track of different editions of a document which features will you
use?
Correct : B. Versions
28. Background color or effects applied on a document is not visible in
Correct : D. Print Preview
29. What is a portion of a document in which you set certain page formatting options?
Correct : C. Section
30. Borders can be applied to
Correct : D. All of above
31. Which of the following is not a type of page margin?
Correct : C. Center
32. What is the default left margin in Word 2003 document?
Correct : B. 1.25"
33. Portrait and Landscape are
Correct : A. Page Orientation
34. If you need to change the typeface of a document, which menu will you choose?
Correct : C. Format
35. What happens when you click on Insert >> Picture >> Clip Art
Correct : C. It opens Clip Art taskbar
36. Which option is not available in Insert Table Autofit behavior?
Correct : D. Autofit to Column
37. To autofit the width of column
Correct : A. Double click the right border of column
38. Which of the following statement is false?
Correct : D. You can set different header and footer for last page of a section
39. Where can you change the vertical alignment?
Correct : C. Page Setup dialog box
40. AutoCorrect was originally designed to replace _________ words as you type.
Correct : C. Misspelled
41. Which of the following is the second step in creating a macro?
Correct : C. Assign a keyboard shortcut to the macro
42. In Word, the mailing list is known as the ____________.
Correct : C. Data source
43. Which of the following is not one of the three ‘Mail Merge Helper’ steps?
Correct : C. Set the mailing list parameters
44. Which of the following button will allow you to add, delete, or change records in your
Data Source?
Correct : C. ‘Edit Data Source’ button
45. It is possible to _______ a data source before performing a merge.
Correct : D. all of the above
46. Comments can be added to cells using …..
Correct : B. Insert -> Comment
47. Which of the following is not a valid Zoom percentage in Excel?
Correct : D. 500
48. The spelling tool is placed on ______ toolbar
Correct : A. Standard
49. Which of the following is not a valid data type in Excel?
Correct : B. Character
50. Comments put in cells are called …..
Correct : B. Cell Tip
51. Which menu option can be used to split windows into two?
Correct : C. Window -> Split
52. You can activate a cell by
Correct : D. All of above
53. When you use the fill effects in the format data series dialog box, you can not
Correct : A. rotate text on the chart
54. To insert three columns between columns D and E you would
Correct : B. Select column E
55. Hyperlinks cannot be
Correct : D. All can be hyperlinks
56. You can add an image to a template by clicking the Insert Picture From File button on
the …. Toolbar.
Correct : D. Picture
57. To drag a selected range of data to another worksheet in the same workbook, use the
Correct : D. Ctrl key
58. When you print preview a worksheet
Correct : D. a, b and c
59. You can open the Sort dialog box by choosing Sort from the ….. menu
Correct : D. Data
60. When working in the page break preview, you can
Correct : D. all of above
61. Formatting a cell in Number format you can’t set
Correct : D. Currency Symbol
62. What is entered by the function =today()
Correct : A. The date value for the day according to system clock
63. Which function will you use to enter current time in a woksheet cell?
Correct : B. =now()
64. Merge cells option can be applied from
Correct : A. Format Cells dialog box Alignment Tab
65. Which of the following format you can decide to apply or not in AutoFormat dialog
box?
Correct : D. All of above
66. How can you remove borders applied in cells?
Correct : C. Both of above
67. You can set Page Border in Excel from
Correct : D. You can not set page border in Excel
68. You can check the conditions against __________ when applying conditional
formatting
Correct : C. Both of above
69. When a range is selected, how can you activate the previous cell?
Correct : D. None of above
70. Each excel file is a workbook that contains different sheets. Which of the following
can not be a sheet in workbook?
Correct : D. data sheet
71. Which of the following Excel screen components can NOT be turned on or off?
Correct : D. None of above
72. Which of the following option is not available in Paste Special dialog box?
Correct : D. SQRT
73. Which of the cell pointer indicates that you can fill series?
Correct : C. Mouse Pointer with anchor at the tip
74. Which of the following is an absolute cell reference?
Correct : B. $A$1
75. Which symbol must all formula begin with?
Correct : A. =
76. Which of the following formulas is not entered correctly?
Correct : D. 10+50
77. Which of the following formulas will Excel Not be able to calculate?
Correct : A. =SUM(Sales)-A3
78. A worksheet range is a
Correct : C. A group of cells
79. The auto calculate feature
Correct : B. Provides a quick way to view the result of an arithmetic operation on a range of cells
80. Excel uniquely identifies cells within a worksheet with a cell name
Correct : C. Column letters and row numbers
81. Hyperlinks can be
Correct : D. All of above
82. To activate the previous cell in a pre-selected range, press
Correct : D. None of the above
83. Which button do yu click to add up a series of numbers?
Correct : A. The autosum button
84. When the formula bar is active, you can see
Correct : D. All of the above
85. In a worksheet you can select
Correct : B. Rows
86. Which area in an excel window allows entering values and formulas
Correct : C. Formula bar
87. To edit in an embedded excel worksheet object in a word document
Correct : A. Use the excel menu bar and toolbars inside the word application
88. To create a formula, you can use:
Correct : D. Value and cell references
89. Status indicators are located on the
Correct : C. Formula bar
90. An excel workbook is a collection of
Correct : D. Worksheets and charts
91. Excel files have a default extension of
Correct : A. Xls
92. Except for the …… function, a formula with a logical function shows the word
“TRUE” or “FALSE” as a result
Correct : A. IF
93. Macros are “run” or executed from the ….. menu.
Correct : C. Tools
94. You can open the consolidate dialog box byt choosing Consolidate from the …..
menu.
Correct : D. Data
95. How are data organized in a spreadsheet?
Correct : C. Rows and columns
96. Gridlines
Correct : D. a, b and c
97. A function inside another function is called a ….. function.
Correct : A. Nested
98. Which function calculates your monthly mortage payment?
Correct : A. PMT (payments)
99. When the formula bar is activated, you can see
Correct : D. All of above
100. Which file format can be added to a PowerPoint show?