MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 136 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Fundamentals knowledge and support exam preparation. Choose a topic below to get started.
| 101. |
In computer In MS-Excel you can quickly change the appearance of your work by choosing Auto Format from the .......... Menu |
| A. | Edit |
| B. | View |
| C. | Format |
| D. | All of these |
| Answer» D. All of these | |
| 102. |
In computer In which MS-Excel to copy cell contents using drag and drop, press the |
| A. | End key |
| B. | Shift+End key |
| C. | Esc key |
| D. | None of above |
| Answer» E. | |
| 103. |
MS-Excel is similar to which of the following accounting worksheets |
| A. | Word processing |
| B. | Database |
| C. | Spreadsheets |
| D. | Both (2) & (3) |
| Answer» D. Both (2) & (3) | |
| 104. |
In computer in which MS-Excel the drag and drop method of copying or moving |
| A. | Can be used between a worksheet but not workbooks |
| B. | Can be used between both workbooks an worksheets |
| C. | Can be used between workbooks but not worksheets |
| D. | None of these |
| Answer» E. | |
| 105. |
In MS-Excel the chart wizard |
| A. | Can place a chart on a new chart sheet or on any sheet in the workbook |
| B. | Can only place a chart on new chart sheet |
| C. | Can only place a chart on a new blank worksheet |
| D. | None of these |
| Answer» B. Can only place a chart on new chart sheet | |
| 106. |
In MS-Excel the auto calculate feature |
| A. | Can add values in a range of cells |
| B. | Provides a quick way to view the results of an arithmetic operation on a range of cells |
| C. | Automatically creates formula and adds them to a worksheet |
| D. | All of these |
| Answer» E. | |
| 107. |
In MS-Excel one want to track the progress of the stock market on a daily basis. Which type of chart should one use? |
| A. | Pie chart |
| B. | Row chart |
| C. | Line chart |
| D. | Both (2) & (3) |
| Answer» D. Both (2) & (3) | |
| 108. |
In MS-Excel default style for new data keyed in a new workbook is |
| A. | Comma |
| B. | Currency |
| C. | General |
| D. | None of these |
| Answer» D. None of these | |
| 109. |
In MS-Excel to copy cell contents using drag and drop press the |
| A. | End key |
| B. | Shift key |
| C. | Ctrl key |
| D. | Esc key |
| Answer» D. Esc key | |
| 110. |
In MS-Excel which of the following options is not located in the Page Setup dialog box? |
| A. | Page Break Preview |
| B. | Page Orientation |
| C. | Margins |
| D. | Both (1) and (3) |
| Answer» B. Page Orientation | |
| 111. |
In MS-Excel when you work with large worksheets, you may need to. |
| A. | Size the worksheet to fit on the specific number of pages |
| B. | Add and remove page breaks |
| C. | Specify only certain print areas |
| D. | All of the Above |
| Answer» E. | |
| 112. |
In MS-Excel to select a column the easiest method is to |
| A. | Double click any cell in the column |
| B. | Drag from the top cell in the column to the last cell in the column |
| C. | Click the column heading |
| D. | None of these |
| Answer» D. None of these | |
| 113. |
In MS-Excel if you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you |
| A. | Press the Erase key |
| B. | Press Esc |
| C. | Press the Enter button |
| D. | None of these |
| Answer» C. Press the Enter button | |
| 114. |
In MS-Excel the following is not an underline option in the format cells dialog box |
| A. | Double |
| B. | Single Engineering |
| C. | Single Accounting |
| D. | Both (2) & (3) |
| Answer» C. Single Accounting | |
| 115. |
In MS-Excel which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell |
| A. | Count |
| B. | Average |
| C. | Sum |
| D. | None of above |
| Answer» D. None of above | |
| 116. |
In MS-Excel how do you change column width to fit the contents? |
| A. | Single-click the boundary to the left to the column heading |
| B. | Double click the boundary to the right of the column heading |
| C. | Press Alt and single click anywhere in the column |
| D. | All of the Above |
| Answer» C. Press Alt and single click anywhere in the column | |
| 117. |
In MS-Excel the Paste Special command lets you copy and paste |
| A. | Cell formulas |
| B. | Multiply the selection by a copied value |
| C. | Formatting options |
| D. | The resulting values of a formula instead of the actual formula |
| Answer» E. | |
| 118. |
MS-Excel & paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following? |
| A. | Rows and columns |
| B. | Headings |
| C. | Speed |
| D. | Both (1) & (2) |
| Answer» D. Both (1) & (2) | |
| 119. |
In MS-Excel the following setup options cannot be set in the page setup dialog box? |
| A. | Printer selection |
| B. | Vertical or horizontal placement |
| C. | Orientation |
| D. | Both (1) and (3) |
| Answer» B. Vertical or horizontal placement | |
| 120. |
In MS-Excel the following describes how to select all the cells in a single column? |
| A. | Right click on column and select Pick from list |
| B. | Use data - text to columns menu item |
| C. | Left click on the gray column title button |
| D. | Both (1) and (3) |
| Answer» D. Both (1) and (3) | |
| 121. |
In MS-Excel which of the following is not a valid data type. |
| A. | Number |
| B. | Character |
| C. | Label |
| D. | All of these |
| Answer» C. Label | |
| 122. |
In MS-Excel the following displays the contents of the active cell |
| A. | Active cell |
| B. | Formula bar |
| C. | Menu bar |
| D. | None of these |
| Answer» C. Menu bar | |
| 123. |
In MS-Excel to open an existing workbook, you can click the Open button on the ...... toolbar. |
| A. | Drawing |
| B. | Formatting |
| C. | Data |
| D. | Standard |
| Answer» E. | |
| 124. |
In MS-Excel all worksheet formula |
| A. | Manipulate values |
| B. | Manipulate labels |
| C. | Return a formula result |
| D. | Both (1) & (2) |
| Answer» D. Both (1) & (2) | |
| 125. |
In MS-Excel which of these will not select all the cells in a document? |
| A. | Clicking three times with the right mouse button in the spreadsheet |
| B. | Using the Edit - Select All menu |
| C. | Pressing Ctrl + A on the keyboard |
| D. | All of these |
| Answer» B. Using the Edit - Select All menu | |
| 126. |
In MS-Excel you can convert existing worksheet data an charts to an HTML document by using |
| A. | FTP wizard |
| B. | Internet assistant wizard |
| C. | lntranet wizard |
| D. | None of these |
| Answer» C. lntranet wizard | |
| 127. |
In MS-Excel To select several cells or ranges that are not touching each other, you would . . . while selecting |
| A. | hold down the Ctrl key |
| B. | hold down the Shift key |
| C. | hold down the Alt key |
| D. | None of these |
| Answer» B. hold down the Shift key | |
| 128. |
In MS-Excel Multiple calculations can be made in a single formula using |
| A. | standard formulas |
| B. | array formula |
| C. | complex formulas |
| D. | None of these |
| Answer» C. complex formulas | |
| 129. |
In MS-Excel 2003 files have a default extension of |
| A. | xls |
| B. | xlw |
| C. | Wk1 |
| D. | None of these |
| Answer» B. xlw | |
| 130. |
In MS-Excel you can group non contiguous worksheets with |
| A. | The group button on the standard toolbar |
| B. | The shift key and the mouse |
| C. | The ctrl key and mouse |
| D. | None of these |
| Answer» D. None of these | |
| 131. |
In MS-Excel when you see a cell with a red triangle in the top right corner, what does this signify? |
| A. | There is an error in the cell |
| B. | There is a comment associated with the cell |
| C. | The font color for text in the cell is red |
| D. | None of these |
| Answer» C. The font color for text in the cell is red | |
| 132. |
In MS-Excel you can add an image to a template by clicking the Insert Picture From File button on the . . . . Toolbar |
| A. | Standard |
| B. | Formatting |
| C. | Drawing |
| D. | Picture |
| Answer» E. | |
| 133. |
In MS-Excel when creating a vertical page break |
| A. | The active cell must be A1 |
| B. | The active cell can be anywhere in the worksheet |
| C. | The active cell must be in row 1 |
| D. | None of these |
| Answer» C. The active cell must be in row 1 | |
| 134. |
Which area in an MS-Excel window allows entering values and formulas ? |
| A. | Title bar |
| B. | Menu bar |
| C. | Formula bar |
| D. | Both (2) & (3) |
| Answer» D. Both (2) & (3) | |
| 135. |
In MS-Excel when working in the page break preview, you can |
| A. | View exactly where each page break occurs |
| B. | Add or remove page breaks |
| C. | Change the print area |
| D. | All of above |
| Answer» E. | |
| 136. |
An MS-Excel workbook is a collection of |
| A. | Workbooks |
| B. | Worksheets |
| C. | Charts |
| D. | Worksheets and charts |
| Answer» E. | |