MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 615 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 Excel the function calculates depreciation at the same amount each year over an asset’s useful life |
| A. | DB (fixed-declining balance) |
| B. | SLN (straight line) |
| C. | DDB (double-declining) |
| D. | All of above |
| Answer» C. DDB (double-declining) | |
| 52. |
In Excel when integrating word and excel, word is usually the |
| A. | Server |
| B. | Destination |
| C. | Client |
| D. | Both (A) and (C) |
| Answer» E. | |
| 53. |
In Excel to drag a selected range of data to another worksheet in the same workbook, use the |
| A. | Tab key |
| B. | Alt key |
| C. | Shift key |
| D. | Ctrl key |
| Answer» E. | |
| 54. |
NOT, AND, OR and XOR are |
| A. | Logical Operators |
| B. | Arithmetic operators |
| C. | Relational operators |
| D. | None of the above |
| Answer» B. Arithmetic operators | |
| 55. |
When integrating Ms-Word and Excel, Word is usually the |
| A. | Server |
| B. | Source |
| C. | Client |
| D. | None |
| Answer» D. None | |
| 56. |
You want to record experiment information and create a chart that shows the rate of crystal growth over a period of timThe best application to use would be: |
| A. | word processing |
| B. | spreadsheet |
| C. | database |
| D. | graphics |
| Answer» C. database | |
| 57. |
Which of the following setup options can not be set in the page setup dialog box? |
| A. | Printer selection |
| B. | Vertical or horizontal placement |
| C. | Orientation |
| D. | Row and column titles |
| Answer» B. Vertical or horizontal placement | |
| 58. |
What is the shortcut key to hide entire column? |
| A. | CTRL + − |
| B. | CTRL + 0 |
| C. | CTRL + H |
| D. | CTRL + C |
| Answer» C. CTRL + H | |
| 59. |
“Qtr 1, Qtr 2, Qtr 3” is an example of a |
| A. | Formula |
| B. | Function |
| C. | Series |
| D. | Syntax |
| Answer» D. Syntax | |
| 60. |
In Excel to open the Format Cells dialog box, press |
| A. | Alt + 1 |
| B. | Ctrl + 1 |
| C. | Ctrl + Shift + 1 |
| D. | F1 |
| Answer» C. Ctrl + Shift + 1 | |
| 61. |
In Excel the following will not cut information |
| A. | Pressing Ctrl + C |
| B. | Selecting Edit>Cut from the menu |
| C. | Clicking the Cut button on the standard |
| D. | Pressing Ctrl+X |
| Answer» B. Selecting Edit>Cut from the menu | |
| 62. |
In Excel you can add a hyperlink to your worksheet by pressing |
| A. | Alt + K |
| B. | Ctrl + H |
| C. | Ctrl + K |
| D. | Ctrl + Shift + K |
| Answer» D. Ctrl + Shift + K | |
| 63. |
In Excel to create a formula, you first |
| A. | Select the cell you want to place the formula into |
| B. | Type the equals sign (=) to tell Excel that you’re about to enter a formula |
| C. | Enter the formula using any input values and the appropriate mathematical operators that make up your formula |
| D. | Choose the new command from the file menu |
| Answer» B. Type the equals sign (=) to tell Excel that you’re about to enter a formula | |
| 64. |
In 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. | hold down Ctrl + Shift key |
| Answer» B. hold down the Shift key | |
| 65. |
In Excel if you press …….., the cell accepts your typing as its contents. |
| A. | Enter |
| B. | Ctrl + Enter |
| C. | TAB |
| D. | Insert |
| Answer» B. Ctrl + Enter | |
| 66. |
In Excel it is acceptable ot 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. | There is nt suitable abbreviation of the text |
| D. | There is not time to format the next |
| Answer» C. There is nt suitable abbreviation of the text | |
| 67. |
Comments put in cells are called ….. |
| A. | Smart Tip |
| B. | Cell Tip |
| C. | Web Tip |
| D. | Soft Tip |
| Answer» C. Web Tip | |
| 68. |
In 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. | |
| 69. |
In Excel….. is a group of cells that form a rectangle on the screen. |
| A. | Calculation |
| B. | Formula |
| C. | Range |
| D. | Range address |
| Answer» D. Range address | |
| 70. |
In Excel LEN function does what? |
| A. | Compares the content in two cells |
| B. | Counts the numbers of characters in a cell |
| C. | Deletes extra space in text |
| D. | All of above |
| Answer» B. Counts the numbers of characters in a cell | |
| 71. |
In Excel intersection of a row and column is called : |
| A. | Cata |
| B. | A field. |
| C. | A cell |
| D. | An equation. |
| Answer» D. An equation. | |
| 72. |
what term describes a background that appears as a grainy, non smooth surface |
| A. | gradient |
| B. | pattern |
| C. | solid |
| D. | texture |
| Answer» B. pattern | |
| 73. |
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this? |
| A. | Go to File-Save As – Save As Type – Excel worksheet |
| B. | Right click on the spreadsheet tab and select DELETE |
| C. | Right click on the spreadsheet and select Insert – Entire Column |
| D. | None of above |
| Answer» C. Right click on the spreadsheet and select Insert – Entire Column | |
| 74. |
Excel is a |
| A. | Graphic program |
| B. | None of these |
| C. | Word processor |
| D. | A spreadsheet |
| Answer» E. | |
| 75. |
What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells? |
| A. | F3 |
| B. | F5 |
| C. | F7 |
| D. | F11 |
| Answer» E. | |
| 76. |
In Excel the following displays the contents of the active cell |
| A. | Active cell |
| B. | Formula bar |
| C. | Menu bar |
| D. | Name box |
| Answer» C. Menu bar | |
| 77. |
In Excel which of the following is not a worksheet design criterion? |
| A. | Efficiency |
| B. | Aditibility |
| C. | Description |
| D. | Clarity |
| Answer» D. Clarity | |
| 78. |
In Excel Hyperlinks can be |
| A. | Text |
| B. | Drawing objects |
| C. | Pictures |
| D. | All of above |
| Answer» E. | |
| 79. |
In Excel the cell labeled F5 refers to |
| A. | row F column 5 |
| B. | column F row 5 |
| C. | function available in cells |
| D. | function key F4 |
| Answer» C. function available in cells | |
| 80. |
In Excel you can open the Sort dialog box by choosing Sort from the ….. menu |
| A. | View |
| B. | Format |
| C. | Tools |
| D. | Data |
| Answer» E. | |
| 81. |
In 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. | Row and column titles |
| Answer» B. Vertical or horizontal placement | |
| 82. |
In Excel when a label is too long to fit within a worksheet cell, you typically must |
| A. | Shorten the label |
| B. | Increase the column width |
| C. | Decrease the column width |
| D. | Adjust the row height |
| Answer» C. Decrease the column width | |
| 83. |
In Excel all worksheet formula |
| A. | Manipulate values |
| B. | Manipulate labels |
| C. | Return a formula result |
| D. | Use the addition operator |
| Answer» D. Use the addition operator | |
| 84. |
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 Center Across Selection from Horizontal combo box in Format Cells dialog box |
| Answer» C. Choose Distributed from the Vertical drop down list of Format Cells dialog box | |
| 85. |
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 | |
| 86. |
In Excel one can use the format painter multiple times before one turn it off by |
| A. | You can use the format painter button on ly 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. | Pressing the Alt key and clicking the format painter button |
| Answer» C. Pressing the Ctrl key and clicking the format painter button | |
| 87. |
In Excel which of the following is not a way to complete a cell entry? |
| A. | Pressing enter |
| B. | Pressing any arrow key on the keyboard |
| C. | Clicking the Enter button on the Formula bar |
| D. | Pressing spacebar |
| Answer» E. | |
| 88. |
MS-EXCEL is based on ……….? |
| A. | WINDOWS |
| B. | DOS |
| C. | UNIX |
| D. | OS/2 |
| Answer» B. DOS | |
| 89. |
In Excel numeric value can be treated as a label value if it precedes with |
| A. | Apostrophe (‘) |
| B. | Exclamation (!) |
| C. | Hash (#) |
| D. | Ampersand (&) |
| Answer» B. Exclamation (!) | |
| 90. |
What is the keyboard shortcut for creating a chart from the selected cell range? |
| A. | F2 |
| B. | F4 |
| C. | F8 |
| D. | F11 |
| Answer» E. | |
| 91. |
What is the AutoComplete feature of Excel? |
| A. | It automatically completes abbreviated words |
| B. | It completes text entries that match an existing entry in the same column |
| C. | It completes text and numeric entries that match an existing entry in the same column |
| D. | It completes text entries that match an existing entry in the same worksheet |
| Answer» C. It completes text and numeric entries that match an existing entry in the same column | |
| 92. |
In 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. | |
| 93. |
In Excel you can use drag and drop to embed excel worksheet data in a word document |
| A. | By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key |
| B. | By dragging a range of excel data to the Word button on the taskbar while pressing Shift key |
| C. | By displaying both applications side-by- side and dragging a selected range of Excel data into the word application window while pressing the Ctrl key |
| D. | (A) and (C) |
| Answer» E. | |
| 94. |
In Excel to edit in an embedded excel worksheet object in a word document |
| A. | Use the excel menu bar and toolbars inside the word application |
| B. | Edit the hyperlink |
| C. | Edit the data in a excel source application |
| D. | Use the word menu bar and toolbars |
| Answer» B. Edit the hyperlink | |
| 95. |
Data marker on a chart are linked to data points in a worksheet, therefore, |
| A. | You can automatically apply formatting to a data series |
| B. | You can change the position of a data marker and automatically change the data point value in the worksheet |
| C. | You can change a data print value and automatically are draw the chart |
| D. | a and b |
| Answer» C. You can change a data print value and automatically are draw the chart | |
| 96. |
Formulas in Excel start with |
| A. | % |
| B. | 0 |
| C. | + |
| D. | - |
| Answer» C. + | |
| 97. |
In Excel without using the mouse or the arrowkeys, what is the fastest way of getting to cell A1 in a spreadsheet? |
| A. | Press Ctrl +Home |
| B. | Press Home |
| C. | Press Shift + Home |
| D. | Press Alt + Home |
| Answer» B. Press Home | |
| 98. |
In Excel you can use drag-and-drop to embed excel worksheet data in a word document |
| A. | By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key |
| B. | By dragging a range of excel data to the word button on the taskbar while pressing Shift key |
| C. | By dragging a range of excel data to the word button on the taskbar while pressing Alt key |
| D. | None of above |
| Answer» B. By dragging a range of excel data to the word button on the taskbar while pressing Shift key | |
| 99. |
In Excel name box |
| A. | Shows the location of the previously active cell |
| B. | Appears to the left of the formula bar |
| C. | Appears below the status bar |
| D. | Appears below the menu bar |
| Answer» C. Appears below the status bar | |
| 100. |
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. | |