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.
| 51. |
In MS-Excel you can edit a cell by |
| A. | Clicking the formula button |
| B. | Double clicking the cell to edit it in-place |
| C. | Selecting Edit>Edit Cell from the menu |
| D. | Both (2) & (3) |
| Answer» C. Selecting Edit>Edit Cell from the menu | |
| 52. |
In MS-Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the. |
| A. | Unfreeze panes command on the window menu |
| B. | Freeze panes command on the window menu |
| C. | Hold titles command on the edit menu |
| D. | None of these |
| Answer» C. Hold titles command on the edit menu | |
| 53. |
In MS-Excel when you want to insert a blank embedded excel worksheet in a word document you can |
| A. | Click the object command on the insert menu |
| B. | Click the office links button on the standard toolbar |
| C. | Click the create worksheet button on the formatting toolbar |
| D. | Click the import excel command on the file menu |
| Answer» B. Click the office links button on the standard toolbar | |
| 54. |
In MS-Excel you can activate a cell by |
| A. | Pressing the Tab key |
| B. | Clicking the cell |
| C. | Pressing an arrow key |
| D. | All of the above |
| Answer» E. | |
| 55. |
In MS-Excel to save a workbook, you |
| A. | Click the save button on the standard toolbar from the menu |
| B. | Press Ctrl+F5 |
| C. | Click Save on the Windows Start button |
| D. | Select Edit>Save |
| Answer» B. Press Ctrl+F5 | |
| 56. |
In MS-Excel which is not an advantage of using computerized spreadsheets? |
| A. | Flexibility of moving entries |
| B. | Speed of calculation |
| C. | Ability of generate tables |
| D. | Cost of initial setup |
| Answer» E. | |
| 57. |
All formula in MS-Excel start with |
| A. | &percent; |
| B. | + |
| C. | = |
| Answer» D. | |
| 58. |
In MS-Excel intersection of a row and column is called |
| A. | Cata |
| B. | A field |
| C. | A cell |
| D. | None of these |
| Answer» D. None of these | |
| 59. |
In MS-Excel advantage of using a spreadsheet is |
| A. | Calculations can be done automatically. |
| B. | Changing data automatically updates calculations |
| C. | More flexibility |
| D. | All of the above |
| Answer» E. | |
| 60. |
In MS-Excel you can select a single range of cells by |
| A. | Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells |
| B. | Pressing the Ctrl key while dragging over the desired cells |
| C. | Pressing the Alt key and an arrow key |
| D. | Dragging over the desired cells |
| Answer» E. | |
| 61. |
In MS-Excel you can create only a horizontal page break by first selecting |
| A. | A row below the row where you want the page break to occur and then clicking on insert--->page break |
| B. | A cell in row 1 |
| C. | A cell in column A |
| D. | Both (1) and (3) |
| Answer» B. A cell in row 1 | |
| 62. |
In MS-Excel you can create hyperlinks from the Excel workbook to |
| A. | A webpage on company internet |
| B. | A web page on the internet |
| C. | Other Office application documents |
| D. | All of the above |
| Answer» E. | |
| 63. |
In MS-Excel you can zoom a worksheet |
| A. | With the mouse pointer in Print Preview |
| B. | With the zoom button on the Print Preview toolbar |
| C. | With the Zoom command on the view menu |
| D. | All of the Above |
| Answer» E. | |
| 64. |
In MS-Excel accounting style shows negative numbers in |
| A. | Bold |
| B. | Brackets |
| C. | Parentheses |
| D. | None of these |
| Answer» D. None of these | |
| 65. |
In MS-Excel cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is |
| A. | B1-G10 |
| B. | B1.G10 |
| C. | B1~G10 |
| D. | B1:G10 |
| Answer» E. | |
| 66. |
In MS-Excel you can print |
| A. | A range of cells by range name |
| B. | An entire worksheet |
| C. | A single worksheet |
| D. | All of the above |
| Answer» E. | |
| 67. |
In MS-Excel numeric value can be treated as a label value if it precedes with |
| A. | Apostrophe (') |
| B. | Exclamation (!) |
| C. | Hash (#) |
| D. | None of these |
| Answer» B. Exclamation (!) | |
| 68. |
In MS-Excel on a sheet the active cell is indicated by |
| A. | A dark wide border |
| B. | A dotted border |
| C. | A blinking border |
| D. | None of above |
| Answer» B. A dotted border | |
| 69. |
In MS-Excel data can be arranged in a worksheet in a easy to understand manner using |
| A. | Auto formatting |
| B. | Applying styles |
| C. | Changing fonts |
| D. | All of the Above |
| Answer» E. | |
| 70. |
In MS-Excel scrolling button at the bottom of screen |
| A. | Allow you to view a different worksheet |
| B. | Allow you to view additional worksheet rows down |
| C. | Allow you to view additional worksheet columns to the right |
| D. | Allow you to view additional sheets tabs |
| Answer» E. | |
| 71. |
in computer In which MS-Excel to view a cell comment |
| A. | Click the edit comment commands on the Insert menu |
| B. | Click the Display comment command on the window menu |
| C. | Position the mouse pointer over the cell |
| D. | None of these |
| Answer» D. None of these | |
| 72. |
In MS-Excel you can use the horizontal and vertical scroll bars to |
| A. | Split a worksheet into two panes |
| B. | View different rows and columns edit the contents of a cell |
| C. | Edit the contents of a cell |
| D. | Both (2) & (3) |
| Answer» C. Edit the contents of a cell | |
| 73. |
In MS-Excel you can use drag-and-drop to embed excel worksheet data in a word document |
| A. | By dragging a range of MS-Excel data to the word button on the taskbar while pressing the Ctrl key |
| B. | By dragging a range of MS-Excel data to the word button on the taskbar while pressing Shift key |
| C. | By dragging a range of MS-Excel data to the word button on the taskbar while pressing Alt key |
| D. | None of above |
| Answer» E. | |
| 74. |
In MS-Excel typical worksheet has .... Number of columns |
| A. | 128 |
| B. | 256 |
| C. | 512 |
| D. | None of these |
| Answer» C. 512 | |
| 75. |
In MS-Excel concatenation of text can be done using |
| A. | Apostrophe (') |
| B. | Exclamation (!) |
| C. | Both (1) & (2) |
| D. | Ampersand (&) |
| Answer» E. | |
| 76. |
In MS-Excel worksheet range is a |
| A. | A command used for data modeling |
| B. | A range of values such as from 23 to 234 |
| C. | A group of cells |
| D. | None of these |
| Answer» D. None of these | |
| 77. |
In MS-Excel getting data from a cell located in a different sheet is called |
| A. | Accessing |
| B. | Referencing |
| C. | Updating |
| D. | Editing |
| Answer» C. Updating | |
| 78. |
In MS-Excel you can use the formula palette to |
| A. | Format cells containing numbers |
| B. | Create and edit formulas containing functions |
| C. | Entered assumptions data |
| D. | None of these |
| Answer» C. Entered assumptions data | |
| 79. |
In MS-Excel which of the following is not a worksheet design criterion? |
| A. | Efficiency |
| B. | Aditibility |
| C. | Description |
| D. | All of these |
| Answer» D. All of these | |
| 80. |
In MS-Excel you can use the drag and drop method to |
| A. | Copy cell contents |
| B. | Move cell contents |
| C. | Add cell contents |
| D. | Both (1) & (2) |
| Answer» E. | |
| 81. |
In MS-Excel it is acceptable to let long text flow into adjacent cells on a worksheet when |
| A. | Data will be entered in the adjacent cells |
| B. | No data will be entered in the adjacent cells |
| C. | Both (1) & (2) |
| D. | None of these |
| Answer» C. Both (1) & (2) | |
| 82. |
Right clicking something in MS-Excel |
| A. | Deletes the object |
| B. | Nothing the right mouse button is there for left handed people |
| C. | Opens a shortcut menu listing everything you can do to the object |
| D. | None of these |
| Answer» D. None of these | |
| 83. |
In MS-Excel which symbol must all formula begin with? |
| A. | = |
| B. | + |
| C. | ( |
| D. | ) |
| Answer» B. + | |
| 84. |
In MS-Excel which of the following formulas is not entered correctly? |
| A. | 85 |
| B. | |
| C. | |
| D. | 17+59 |
| Answer» E. | |
| 85. |
In MS-Excel to delete an embedded object |
| A. | Double click the object |
| B. | Select the object by clicking it |
| C. | Press the Alt + Delete keys |
| D. | Select it and then press the delete key |
| Answer» E. | |
| 86. |
In MS-Excel what symbol is used before a number to make it a label? |
| A. | " (quote) |
| B. | |
| C. | _ (underscore) |
| D. | None of these |
| Answer» B. | |
| 87. |
In MS-Excel Book1 is an example of how . . . are numbered and named during each work session |
| A. | Active cell |
| B. | Formula bar |
| C. | Menu bar |
| D. | Name box |
| Answer» E. | |
| 88. |
In MS-Excel constant is another name for this type of data |
| A. | number |
| B. | equation |
| C. | formula |
| D. | None of these |
| Answer» B. equation | |
| 89. |
In MS-Excel the view that puts a blue line around each page that would be printed is the |
| A. | Print Preview |
| B. | Normal View |
| C. | Page Break Preview |
| D. | None of these |
| Answer» D. None of these | |
| 90. |
In MS-Excel which is used to perform what if analysis? |
| A. | Solver |
| B. | Goal seek |
| C. | Scenario Manager |
| D. | All of the Above |
| Answer» D. All of the Above | |
| 91. |
In MS-Excel to insert function with syntax is |
| A. | Right click a cell and then click insert |
| B. | Click the insert menu and then click function |
| C. | Type = in a cell |
| D. | None of these |
| Answer» C. Type = in a cell | |
| 92. |
In MS-Excel Graphics objects on a chart are used to |
| A. | Add emphasis to chart data |
| B. | Add interest to a chart |
| C. | Help explain the chart data |
| D. | All of the Above |
| Answer» E. | |
| 93. |
In MS-Excel you can insert labels for |
| A. | All the data markers on a chart |
| B. | A data series |
| C. | A selected data marker |
| D. | All of the Above |
| Answer» E. | |
| 94. |
In MS-Excel to select an individual data marker or data label, you must |
| A. | Double click the data series |
| B. | Right click selected marker |
| C. | Both (1) & (2) |
| D. | Double click the marker or label |
| Answer» E. | |
| 95. |
In MS-Excel what does SUMIF function do? |
| A. | Adds up cell values based on a condition |
| B. | Adds all the numbers in a range of cells |
| C. | Returns a subtotal in a list or database |
| D. | Both (1) & (2) |
| Answer» B. Adds all the numbers in a range of cells | |
| 96. |
In MS-Excel when you use the fill effects in the format data series dialog box, you cannot |
| A. | Rotate text on the chart |
| B. | Select a fore ground color |
| C. | Select a pattern |
| D. | All of these |
| Answer» B. Select a fore ground color | |
| 97. |
You can link MS-Excel worksheet data to a Word document |
| A. | With the right drag method |
| B. | With a hyperlink |
| C. | With the copy and paste buttons on the standard toolbar |
| D. | None of these |
| Answer» C. With the copy and paste buttons on the standard toolbar | |
| 98. |
In MS-Excel you can use the format painter multiple times before you turn it off by |
| A. | You can use the format painter button only one time when you click it |
| B. | Double clicking the format painter button |
| C. | Pressing the Ctrl key and clicking the format painter button |
| D. | None of these |
| Answer» C. Pressing the Ctrl key and clicking the format painter button | |
| 99. |
In computer In which MS-Excel which of the following is not a worksheet design criterion |
| A. | Efficiency |
| B. | Auditability |
| C. | Description |
| D. | Both (2) & (3) |
| Answer» D. Both (2) & (3) | |
| 100. |
In computer In which MS-Excel following term describes explanatory text attached to a cell |
| A. | Callout |
| B. | Comment |
| C. | Dialog |
| D. | All of these |
| Answer» C. Dialog | |