Office Automation Tools Multiple Choice Questions for Exam Point of View(Part 2)

 Office Automation Tools Multiple Choice Questions

Office Automation Tools

51. Where can you find the horizontal split bar on MS Word screen?

1. On the left of the horizontal scroll bar.
2. On the right of the horizontal scroll bar.
3. On the top of the vertical scroll bar.
4. On the bottom of the vertical scroll bar

52. Which of the following is not available on the Ruler of MS Word screen?

1. Tab stop box.
2. Left indent.
3. Right indent.
4. Centre indent.

53. What is the place to the left of the horizontal scroll bar?

1. Tab stop buttons
2. View buttons
3. Split buttons
4. Indicators

54. Which file starts MS Word?

1. Winword.exe.
2. Word.exe.
3. Mswo.
4. exe.

55. How many ways you can save a document?

1. 3
2. 4
3. 5
4. 6

56. If you want to keep track of different editions of a document which features will you use?

1. Editions.
2. Versions.
3. Track change.
4. All of the above.

57. Background colour or effects applied on a document is not visible in

1. Web layout view.
2. Print layout view.
3. Reading view.
4. Print preview.

58. What is a portion of a document in which you set certain page formatting options?

1. Page.
2. Document.
3. Section.
4. Page setup.

59. Borders can be applied to

1. Cells.
2. Paragraph.
3. Text.
4. All of the above.

60. Which of the following is not a type of page margin?

1. Left.
2. Right.
3. Centre.
4. Top.

61. What is the default left margin in Word 2007 document?

1. 1″
2. 1.25″
3. 1.5″
4. 2″

62. What is gutter margin?

1. Margin that is added to the left margin when printing.
2. Margin that is added to right margin when printing.
3. Margin that is added to the binding side of the page when printing.
4. Margin that is added to the outside of the page when printing.

63. Portrait and Landscape are

1. Page orientation
2. Paper size
3. Page layout
4. All of above

64. If you need to change the typeface of a document, which menu will you choose?

1. Edit.
2. View.
3. Format.
4. Tools.

65. Which of the following is not a font style?

1. Bold.
2. Italics.
3. Regular.
4. Superscript.

66. ————- is a spreadsheet application.

1. MS word
2. MS access
3. MS excel
4. All of these

67. Who is considered as the father of electronic spreadsheet?

1. Dan Bricklin.
2. Allen Turing.
3. Winton serf.
4. Charles Babbage.

68. Which of the following is/are the additional features of Ms Excel 2007?

1. Quick access toolbar.
2. MS button.
3. Ribbon.
4. All the above.

69. A file in Ms Excel is Called———-

1. Worksheet.
2. Workbook.
3. Work field.
4. Work file

70. A workbook is a collection of ———– used in a single file.

1. Worksheet.
2. Work record.
3. Work field.
4. Work file.

71. A function inside another function is called _______.

1. Nested function.
2. Round function.
3. Sum function.
4. Text function.

72. Which of the following is not an underline option in the format cells dialogue box?

1. Double.
2. Single accounting.
3. Double accounting.
4. Single engineering.

73. Formulas in Excel start with

1. %
2. =
3. +
4. –

74. The default header for a worksheet is

1. Username.
2. Date and time.
3. Sheet tab name.
4. None.

75. Which of the following is not an option of the spelling dialogue box?

1. Ignore.
2. Ignore all.
3. Edit.
4. Change.

Answer:

C.edit

76. Which of the following methods will not enter data in a cell?

1. Pressing the Esc key.
2. Pressing an arrow key.
3. Pressing the tab key.
4. Clicking the enter button to the formula bar.

77. The cell reference for a cell range of F2 to P12 is _______

1. f2.p12
2. f;p12
3. f2:p12
4. D. f2-p12

78. What is the keyboard shortcut for creating a chart from the selected cell range?

1. f2
2. f4
3. f8
4. f11

79. The Software which contains rows and columns is called ______

1. Database.
2. Drawing.
3. Spreadsheet.
4. Word processing.

80. You can group non-contiguous worksheets with

1. The alt+enter key.
2. The ctrl key and mouse.
3. The shift key and the mouse.
4. The group button on the standard toolbar.

81. Which of the following is not a valid Zoom percentage in Excel?

1. 75
2. 100
3. 200
4. 500

82. The spelling tool is placed on ______ toolbar

1. Standard.
2. Formatting.
3. Drawing.
4. Reviewing.

83. If you need a text to show vertically in a cell. How will you achieve this?

Choose vertical on text alignment in format cells dialogue box.

Choose 90 degrees in the orientation of format cells dialogue box.

Choose distributed from the vertical drop down list of format cells dialogue box.

Choose centre across selection from horizontal combo box in format cells dialog box.

84. Can you set 0.5 inch left indentation for a cell in Excel?

1. Excel does not have an indentation feature.
2. You can specify indentation only if you turn the rulers on.
3. Indentation can be set from the format cells dialogue box.
4. The indentation can be specified only when printing.

85. You can automatically adjust the size of the text in a cell if they do not fit in width by

1. Double-clicking on the right border of the column header.
2. From format choose columns and then autofit selection.
3. From format cells dialogue box mark shrink to fit check box.
4. All of the above.

86. Formatting a cell in Currency, you can specify

1. Decimal places.
2. Currency symbol.
3. Both of the above.
4. None of the above.

87. Formatting a cell in Number format you can’t set

1. Decimal places.
2. Use 1000 separators.
3. Negative numbers.
4. Currency symbol.

88. What is entered by the function =today()

1. The date value for the day is according to the system clock.
2. The time value is according to system clock.
3. Today’s date as text format.
4. All of the above.

89. Which function will you use to enter current time in a worksheet cell?

1. today()
2. =now()
3. =time()
4. =current time()

90. Special category of Number tab in Format Cells dialogue box can be used to apply formats like

1. Zipcode.
2. Phone number.
3. Both of the above.
4. None of the above.

91. Merge cells option can be applied from

1. Format cells dialogue box alignment tab.
2. Formatting toolbar.
3. Both of the above.
4. None of the above.

92. Pre-made sheet formats like Simple, Classic, Accounting, Colourful etc. can be applied from

1. From format >> cells.
2. From format >> auto format.
3. From table >> auto format.
4. All of the above.

93. Which of the following format you can decide to apply or not in AutoFormat dialog box?

1. Number format.
2. Border format.
3. Font format.
4. All of the above.

94. How can you remove borders applied in cells?

1. Choose none on the border tab of format cells.
2. Open the list on the Border tool in the Formatting toolbar then choose the first tool (no border).
3. Both of the above.
4. None of the above.

95. Where can you set the shedding colour for a range of cells in Excel?

1. Choose required colour form Patterns tab of Format cells dialogue box
2. Choose required colour on the fill colour tool in the formatting toolbar
3. Choose required colour on fill colour tool in drawing toolbar
4. All of above

96. You can set Page Border in Excel from

1. From border tab in format cells dialog box.
2. From border tool in formatting toolbar.
3. From line style tool in drawing toolbar.
4. You cannot set page border in excel.

97. When all the numbers between 0 and 100 in a range should be displayed in RedColour, apply

1. Use =if() function to format the required numbers red.
2. Apply conditional formatting command on format menu.
3. Select the cells that contain number between 0 and 100 then click red colour on the text colour tool.
4. All of the above.

98. You can check the conditions against __________ when applying conditionalformatting

1. Cell value.
2. Formula.
3. Both of the above.
4. None of the above.

99. Which of the following is not true regarding Conditional Formatting?

1. You can add more than one condition to check.
2. You can set conditions to look for bold and apply italics on them.
3. You can apply font, border and pattern formats that meets the specified conditions.
4. You can delete any condition from the conditional formatting dialogue box if it is not required.

100. In Microsoft Excel 2007, the ———– is used to issue commands

1. Quick access toolbar.
2. Formula bar.
3. Ribbon.
4. MS button.