McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Bachelor of Commerce (B Com) .
| 51. |
Where can you find the horizontal split bar on MS Word screen? |
| A. | on the left of horizontal scroll bar |
| B. | on the right of horizontal scroll bar |
| C. | on the top of vertical scroll bar |
| D. | on the bottom of vertical scroll bar |
| Answer» C. on the top of vertical scroll bar | |
| 52. |
Which of the following is not available on the Ruler of MS Word screen? |
| A. | tab stop box |
| B. | left indent |
| C. | right indent |
| D. | center indent |
| Answer» D. center indent | |
| 53. |
What is place to the left of horizontal scroll bar? |
| A. | tab stop buttons |
| B. | view buttons |
| C. | split buttons |
| D. | indicators |
| Answer» B. view buttons | |
| 54. |
Which file starts MS Word? |
| A. | winword.exe |
| B. | word.exe |
| C. | mswo |
| D. | exe |
| Answer» A. winword.exe | |
| 55. |
How many ways you can save a document? |
| A. | 3 |
| B. | 4 |
| C. | 5 |
| D. | 6 |
| Answer» A. 3 | |
| 56. |
If you want to keep track of different editions of a document which features will you use? |
| A. | editions |
| B. | versions |
| C. | track change |
| D. | all of above |
| Answer» B. versions | |
| 57. |
Background colour or effects applied on a document is not visible in |
| A. | web layout view |
| B. | print layout view |
| C. | reading view |
| D. | print preview |
| Answer» D. print preview | |
| 58. |
What is a portion of a document in which you set certain page formatting options? |
| A. | page |
| B. | document |
| C. | section |
| D. | page setup |
| Answer» C. section | |
| 59. |
Borders can be applied to |
| A. | cells |
| B. | paragraph |
| C. | text |
| D. | all of above |
| Answer» D. all of above | |
| 60. |
Which of the following is not a type of page margin? |
| A. | left |
| B. | right |
| C. | centre |
| D. | top |
| Answer» C. centre | |
| 61. |
What is the default left margin in Word 2007document? |
| A. | 1" |
| B. | 1.25" |
| C. | 1.5" |
| D. | 2" |
| Answer» B. 1.25" | |
| 62. |
What is gutter margin? |
| A. | margin that is added to the left margin when printing |
| B. | margin that is added to right margin when printing |
| C. | margin that is added to the binding side of page when printing |
| D. | margin that is added to the outside of the page when printing |
| Answer» C. margin that is added to the binding side of page when printing | |
| 63. |
Portrait and Landscape are |
| A. | page orientation |
| B. | paper size |
| C. | page layout |
| D. | all of above |
| Answer» A. page orientation | |
| 64. |
If you need to change the typeface of a document, which menu will you choose? |
| A. | edit |
| B. | view |
| C. | format |
| D. | tools |
| Answer» C. format | |
| 65. |
Which of the following is not a font style? |
| A. | bold |
| B. | italics |
| C. | regular |
| D. | superscript |
| Answer» D. superscript | |
| 66. |
------------- is a spread sheet application |
| A. | ms word |
| B. | ms access |
| C. | ms excel |
| D. | all of these |
| Answer» C. ms excel | |
| 67. |
Who is considered as father of electronic spread sheet? |
| A. | dan bricklin |
| B. | allen turing |
| C. | winton serf |
| D. | charles babbage |
| Answer» A. dan bricklin | |
| 68. |
Which of the following is / are the additional features of Ms Excel 2007? |
| A. | quick access toolbar |
| B. | ms button |
| C. | ribbon |
| D. | all the above |
| Answer» D. all the above | |
| 69. |
A file in Ms Excel is Called---------- |
| A. | work sheet |
| B. | work book |
| C. | work field |
| D. | work file |
| Answer» B. work book | |
| 70. |
A work book is a collection of ----------- used in a single file |
| A. | work sheet |
| B. | work record |
| C. | work field |
| D. | work file |
| Answer» A. work sheet | |
| 71. |
A function inside another function is called _______ |
| A. | nested function |
| B. | round function |
| C. | sum function |
| D. | text function |
| Answer» A. nested function | |
| 72. |
Which of the following is not an underline option in the format cells dialog box? |
| A. | double |
| B. | single accounting |
| C. | double accounting |
| D. | single engineering |
| Answer» D. single engineering | |
| 73. |
Formulas in Excel start with |
| A. | % |
| B. | = |
| C. | + |
| D. | – |
| Answer» B. = | |
| 74. |
The default header for a worksheet is |
| A. | username |
| B. | date and time |
| C. | sheet tab name |
| D. | none |
| Answer» C. sheet tab name | |
| 75. |
Which of the following is not an option of the spelling dialog box? |
| A. | ignore |
| B. | ignore all |
| C. | edit |
| D. | change |
| Answer» C. edit | |
| 76. |
Which of the following methods will not enter data in a cell? |
| A. | pressing the esc key |
| B. | pressing an arrow key |
| C. | pressing the tab key |
| D. | clicking the enter button to the formula bar |
| Answer» A. pressing the esc key | |
| 77. |
The cell reference for cell range of F2 to P12 is _______ |
| A. | f2.p12 |
| B. | f;p12 |
| C. | f2:p12 |
| D. | f2-p12 |
| Answer» C. f2:p12 | |
| 78. |
What is the keyboard shortcut for creating a chart from the selected cell range? |
| A. | f2 |
| B. | f4 |
| C. | f8 |
| D. | f11 |
| Answer» D. f11 | |
| 79. |
The Software which contains rows and columns is called ______ |
| A. | database |
| B. | drawing |
| C. | spreadsheet |
| D. | word processing |
| Answer» C. spreadsheet | |
| 80. |
You can group non-contiguous worksheets with |
| A. | the alt+enter key |
| B. | the ctrl key and mouse |
| C. | the shift key and the mouse |
| D. | the group button on the standard toolbar |
| Answer» B. the ctrl key and mouse | |
| 81. |
Which of the following is not a valid Zoom percentage in Excel? |
| A. | 75 |
| B. | 100 |
| C. | 200 |
| D. | 500 |
| Answer» D. 500 | |
| 82. |
The spelling tool is placed on ______ toolbar |
| A. | standard |
| B. | formatting |
| C. | drawing |
| D. | reviewing |
| Answer» A. standard | |
| 83. |
If you need a text to show vertically in a cell. How will you achieve this? |
| A. | choose vertical on text alignment in format cells dialog box |
| B. | choose 90 degrees in orientation of format cells dialog box |
| C. | choose distributed from the vertical drop down list of format cells dialog box |
| D. | choose centre across selection from horizontal combo box in format cells dialog box |
| Answer» 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? |
| A. | excel does not have indentation feature |
| B. | you can specify indentation only if you turn the rulers on |
| C. | indentation can be set from format cells dialog box |
| D. | the indentation can be specified only when printing |
| Answer» 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 |
| A. | double clicking on the right border of column header |
| B. | from format choose columns and then auto fit selection |
| C. | from format cells dialog box mark shrink to fit check box |
| D. | all of above |
| Answer» C. from format cells dialog box mark shrink to fit check box | |
| 86. |
Formatting a cell in Currency, you can specify |
| A. | decimal places |
| B. | currency symbol |
| C. | both of above |
| D. | none of above |
| Answer» C. both of above | |
| 87. |
Formatting a cell in Number format you can’t set |
| A. | decimal places |
| B. | use 1000 separator |
| C. | negative numbers |
| D. | currency symbol |
| Answer» D. currency symbol | |
| 88. |
What is entered by the function =today() |
| A. | the date value for the day according to system clock |
| B. | the time value according to system clock |
| C. | today’s date as text format |
| D. | all of above |
| Answer» B. the time value according to system clock | |
| 89. |
Which function will you use to enter current time in a worksheet cell? |
| A. | today() |
| B. | =now() |
| C. | =time() |
| D. | =current time() |
| Answer» C. =time() | |
| 90. |
Special category of Number tab in Format Cells dialog box can be used to apply formats like |
| A. | zip code |
| B. | phone number |
| C. | both of above |
| D. | none of above |
| Answer» C. both of above | |
| 91. |
Merge cells option can be applied from |
| A. | format cells dialog box alignment tab |
| B. | formatting toolbar |
| C. | both of above |
| D. | none of above |
| Answer» C. both of above | |
| 92. |
Pre-made sheet formats like Simple, Classic, Accounting, Colourful etc. can be applied from |
| A. | from format >> cells |
| B. | from format >> auto format |
| C. | from table >> auto format |
| D. | all of above |
| Answer» B. from format >> auto format | |
| 93. |
Which of the following format you can decide to apply or not in AutoFormat dialog box? |
| A. | number format |
| B. | border format |
| C. | font format |
| D. | all of above |
| Answer» D. all of above | |
| 94. |
How can you remove borders applied in cells? |
| A. | choose none on border tab of format cells |
| B. | open the list on border tool in formatting toolbar then choose first tool (no border) |
| C. | both of above |
| D. | none of above |
| Answer» C. both of above | |
| 95. |
Where can you set the shedding colour for a range of cells in Excel? |
| A. | choose required colour form patterns tab of format cells dialog box |
| B. | choose required colour on fill colour tool in formatting toolbar |
| C. | choose required colour on fill colour tool in drawing toolbar |
| D. | all of above |
| Answer» D. all of above | |
| 96. |
You can set Page Border in Excel from |
| A. | from border tab in format cells dialog box |
| B. | from border tool in formatting toolbar |
| C. | from line style tool in drawing toolbar |
| D. | you cannot set page border in excel |
| Answer» 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 |
| A. | use =if() function to format the required numbers red |
| B. | apply conditional formatting command on format menu |
| C. | select the cells that contain number between 0 and 100 then click red colour on text colour tool |
| D. | all of above |
| Answer» B. apply conditional formatting command on format menu | |
| 98. |
You can check the conditions against __________ when applying conditional formatting |
| A. | cell value |
| B. | formula |
| C. | both of above |
| D. | none of above |
| Answer» C. both of above | |
| 99. |
Which of the following is not true regarding Conditional Formatting? |
| A. | you can add more than one condition to check |
| B. | you can set condition to look for bold and apply italics on them. |
| C. | you can apply font, border and pattern formats that meets the specified conditions |
| D. | you can delete any condition from conditional formatting dialog box if it is not required |
| Answer» 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 |
| A. | quick access tool bar |
| B. | formula bar |
| C. | ribbon |
| D. | ms button |
| Answer» C. ribbon | |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.