MCQOPTIONS
Saved Bookmarks
This section includes 187 Mcqs, each offering curated multiple-choice questions to sharpen your Computer knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
Which of the following allows you to select more than one slide in a presentation ? |
| A. | Alt + click each slide |
| B. | Shift + drag each slide |
| C. | Shift + click each slide |
| D. | Ctrl + click each slide |
| E. | None of the above |
| Answer» D. Ctrl + click each slide | |
| 52. |
Which of the following is not a valid formula in Microsoft Excel ? |
| A. | = A2 + A1 |
| B. | = A2 + 1 |
| C. | = 1 + A2 |
| D. | = 1A + 2 |
| E. | = A1 + A2 |
| Answer» E. = A1 + A2 | |
| 53. |
In a worksheet in MS-Excel what is short-cut key to hide entire row ? |
| A. | Ctrl + 2 |
| B. | Ctrl + 9 |
| C. | Ctrl + N |
| D. | Ctrl + - |
| E. | Ctrl + N |
| Answer» B. Ctrl + 9 | |
| 54. |
Which of the following is not an example of a document file ? |
| A. | Spreadsheet |
| B. | Memo |
| C. | Letter |
| D. | Term Paper |
| E. | Thesis |
| Answer» B. Memo | |
| 55. |
A collection of worksheets is called |
| A. | Excel book |
| B. | Worksheets |
| C. | Excel sheets |
| D. | Workbook |
| E. | None of these |
| Answer» E. None of these | |
| 56. |
Which command is used to calculate total characters in a cell ? |
| A. | Len |
| B. | Length |
| C. | Mid |
| D. | Sid |
| E. | None of these |
| Answer» B. Length | |
| 57. |
Anything that is typed in a worksheet appears |
| A. | in the formula bar only |
| B. | in the active cell only |
| C. | in both active cell and formula bar |
| D. | All of the above |
| E. | None of the above |
| Answer» D. All of the above | |
| 58. |
On saving a worksheet, the 'Save As' dialog box |
| A. | is used to open the saved Excel files |
| B. | is used for saving the file for the first time |
| C. | is used for saving the file by some alternative name |
| D. | Both '2' and '3' |
| E. | None of the above |
| Answer» D. Both '2' and '3' | |
| 59. |
The function TODAY ( ) in Excel, enters the current |
| A. | system time in a cell |
| B. | system date and time in a cell |
| C. | system data only |
| D. | time at which the current file was opened |
| E. | None of the above |
| Answer» E. None of the above | |
| 60. |
Pie charts are typically created by using which of the following ? |
| A. | Browser software |
| B. | Database software |
| C. | Desktop publishing software |
| D. | Word processing software |
| E. | Spreadsheet software |
| Answer» F. | |
| 61. |
Ctrl, Shift and Alt are called ........ keys. |
| A. | Modifier |
| B. | Function |
| C. | Alphanumeric |
| D. | Adjustment |
| E. | None of these |
| Answer» B. Function | |
| 62. |
In Excel, the intersection of a column and a row is called |
| A. | Cell |
| B. | Grid |
| C. | Table |
| D. | Box |
| E. | None of the above |
| Answer» B. Grid | |
| 63. |
Which of the following characteristics is used to compute dynamically the results from Excel data ? |
| A. | Goto |
| B. | Table |
| C. | Chart |
| D. | Diagram |
| E. | Formula and function |
| Answer» F. | |
| 64. |
MS-Excel is used for |
| A. | letter writing |
| B. | spreadsheet calculation |
| C. | presentation |
| D. | painting |
| E. | None of the above |
| Answer» C. presentation | |
| 65. |
Which of the following software applications would be the most appropriate for performing numerical and statistical calculations ? |
| A. | Database |
| B. | Document processor |
| C. | Graphics package |
| D. | Spreadsheet |
| E. | Power Point |
| Answer» E. Power Point | |
| 66. |
The file responsible for starting MS-Excel is |
| A. | MS.Excel |
| B. | MS.exe |
| C. | Excel.exe |
| D. | Excel.com |
| E. | None of these |
| Answer» D. Excel.com | |
| 67. |
Which of the following is an active cell in Excel ? |
| A. | Current cell |
| B. | Formula |
| C. | Range |
| D. | Cell address |
| E. | None of these |
| Answer» B. Formula | |
| 68. |
A worksheet is made of columns and rows, wherein |
| A. | columns run horizontally and rows run vertically |
| B. | columns run vertically and rows run horizontally |
| C. | the run is dependent on the application being used |
| D. | Both '2' and '3' |
| E. | None of the above |
| Answer» C. the run is dependent on the application being used | |
| 69. |
In Excel, ....... allows users to bring together copies of workbooks that other users gave worked on independently. |
| A. | copying |
| B. | merging |
| C. | pasting |
| D. | compiling |
| E. | None of these |
| Answer» C. pasting | |
| 70. |
What does an electronic spreadsheet consist of ? |
| A. | Rows |
| B. | Columns |
| C. | Cells |
| D. | All of these |
| E. | None of these |
| Answer» E. None of these | |
| 71. |
Which software helps you carry out tasks, such as typing a document or creating a spreadsheet ? |
| A. | System |
| B. | Application |
| C. | Utility |
| D. | Operating |
| E. | None of these |
| Answer» C. Utility | |
| 72. |
How are the data organised in a spreadsheet ? |
| A. | Lines and spaces |
| B. | Layers and planes |
| C. | Height and width |
| D. | Rows and columns |
| E. | None of these |
| Answer» E. None of these | |
| 73. |
The default view in Excel is ............. view. |
| A. | Work |
| B. | Auto |
| C. | Normal |
| D. | Roman |
| E. | None of these |
| Answer» D. Roman | |
| 74. |
A ........ is rectangular grid of rows and columns used to enter data. |
| A. | cell |
| B. | workspace |
| C. | Worksheet |
| D. | spreadsheet |
| E. | Both '3' and '4' |
| Answer» F. | |
| 75. |
Which among the following is not such an operation which can be carried out on objects in graphic program ? |
| A. | Spell check |
| B. | Change size |
| C. | Move |
| D. | Delete |
| E. | None of these |
| Answer» F. | |
| 76. |
To find the paste special option, or use the clipboard group on the .......... tab of PowerPoint. |
| A. | Design |
| B. | Slide show |
| C. | Page layout |
| D. | Insert |
| E. | `None of these |
| Answer» F. | |
| 77. |
Word offers certain ways in which user can move around in a document |
| A. | By scrolling |
| B. | By moving to a specific page |
| C. | Directly to first and last page |
| D. | All '1' , '2' and '3' |
| E. | None of the above |
| Answer» E. None of the above | |
| 78. |
In PowerPoint, the Header and Footer button can be found on the Insert tab in which group ? |
| A. | Illustration group |
| B. | Object group |
| C. | Insert group |
| D. | Tables group |
| E. | None of the above |
| Answer» F. | |
| 79. |
Which is the short key to invoke the spell checker in MS-Access ? |
| A. | F2 |
| B. | F7 |
| C. | Alt+F7 |
| D. | F3 |
| E. | None of these |
| Answer» C. Alt+F7 | |
| 80. |
Which PowerPoint view displays each slide of the presentation as a thumbnail and is useful for rearranging slides ? |
| A. | Slider sorter |
| B. | Slide show |
| C. | Slide master |
| D. | Notes page |
| E. | Slide design |
| Answer» B. Slide show | |
| 81. |
Which of the following will you use as an option for saving a file ? |
| A. | Save button on Standard toolbar |
| B. | Save option from File menu |
| C. | Pressing Ctrl + S |
| D. | All of the above |
| E. | None of the above |
| Answer» E. None of the above | |
| 82. |
Alignment buttons are available on which toolbar ? |
| A. | Status |
| B. | Standard |
| C. | Formatting |
| D. | All of these |
| E. | None of these |
| Answer» E. None of these | |
| 83. |
Alignment buttons are available on which toolbar |
| A. | Status |
| B. | Standard |
| C. | Formatting |
| D. | All of these |
| E. | None of these |
| Answer» D. All of these | |
| 84. |
We can't make query by insert menu ? |
| A. | True |
| B. | False |
| C. | Can't say |
| D. | Sometimes |
| E. | None of the above |
| Answer» B. False | |
| 85. |
A template is a |
| A. | pattern of worksheet |
| B. | heading |
| C. | title |
| D. | theme |
| E. | None of the above |
| Answer» B. heading | |
| 86. |
Which of the following controls the format and placement of the titles and texts you on slides, as well as, background items and graphics you want to appear on every slide ? |
| A. | Slide |
| B. | Copyright |
| C. | Layout |
| D. | Design |
| E. | None of these |
| Answer» D. Design | |
| 87. |
It is a software tool that lets one enter, calculate, mainpulate set of numbers |
| A. | speedsheet |
| B. | spreadsheet |
| C. | slide sheet |
| D. | All of these |
| E. | None of these |
| Answer» C. slide sheet | |
| 88. |
Which option will we use to give heading in the form ? |
| A. | Label |
| B. | Text box |
| C. | Option group |
| D. | Insert |
| E. | None of these |
| Answer» B. Text box | |
| 89. |
Selecting Portrait changes our page from |
| A. | a wide to tall orientation |
| B. | a tall to wide orientation |
| C. | a normal font size to a condensed one |
| D. | a condensed font size to a normal one |
| E. | None of the above |
| Answer» B. a tall to wide orientation | |
| 90. |
This is to insert an object, which is not miss print to its originating document into a destination document ? |
| A. | Cell |
| B. | Embed |
| C. | Defaults |
| D. | Any of the above |
| E. | None of the above |
| Answer» C. Defaults | |
| 91. |
Which one is the example of spreadsheet package ? |
| A. | Visicalc |
| B. | Unity |
| C. | Ada |
| D. | Snowball |
| E. | None of these |
| Answer» E. None of these | |
| 92. |
Insert date, format page number and insert auto text are buttons on the ........ toolbar. |
| A. | formatting |
| B. | header and footer |
| C. | standard |
| D. | edit |
| E. | None of these |
| Answer» B. header and footer | |
| 93. |
=Sum (B1 : B10) is an example of a |
| A. | function |
| B. | formula |
| C. | cell address |
| D. | value |
| E. | None of these |
| Answer» C. cell address | |
| 94. |
All of the following terms are related to spreadsheet software except |
| A. | worksheet |
| B. | cell |
| C. | formula |
| D. | virus detection |
| E. | None of these |
| Answer» E. None of these | |
| 95. |
You can add any picture in your document from which menu ? |
| A. | File |
| B. | Edit |
| C. | Insert |
| D. | Format |
| E. | View |
| Answer» D. Format | |
| 96. |
Excel worksheet data can be shared with Word document by |
| A. | inserting an Excel file into Word |
| B. | copy and paste Excel worksheet into Word document |
| C. | link Excel data in a Word document |
| D. | All of the above |
| E. | None of the above |
| Answer» E. None of the above | |
| 97. |
Magnifier button is available on |
| A. | Print Preview Toolbar |
| B. | Standard Toolbar |
| C. | Formatting Toolbar |
| D. | Both '1' and '2' |
| E. | None of the above |
| Answer» B. Standard Toolbar | |
| 98. |
Which of the following commands in office 2007, can be used to go to the first cell in the current row ? |
| A. | Tab |
| B. | Shift + Tab |
| C. | Esc + Home |
| D. | Shift + Home |
| E. | Home |
| Answer» E. Home | |
| 99. |
=Sum(B1 :B1) is an example of a |
| A. | Function |
| B. | Cell address |
| C. | Formula |
| D. | Value |
| E. | Other than those given as options |
| Answer» D. Value | |
| 100. |
When cutting and pasting, the item cut is temporarily stored in the |
| A. | dashboard |
| B. | ROM |
| C. | Hard drive |
| D. | Diskette |
| E. | Clipboard |
| Answer» F. | |