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.
| 1. |
In MS-Excel value used in a formula that does not change is called a |
| A. | Cell address |
| B. | Constant |
| C. | Function |
| D. | None of these |
| Answer» C. Function | |
| 2. |
In computer in which MS-Excel which elements of worksheet can be protected from accidental modification? |
| A. | Contents |
| B. | Objects |
| C. | Scenarios |
| D. | All |
| Answer» E. | |
| 3. |
What MS-Excel feature can you use if you want to work with one record at a time? |
| A. | Auto Complete |
| B. | Auto Filter |
| C. | Data Form |
| D. | All of the Above |
| Answer» D. All of the Above | |
| 4. |
In MS-Excel Chart wizard term data categories refers to |
| A. | A chart plot area |
| B. | A horizontal axis |
| C. | The organization of individual values with a chart's data series |
| D. | All of these |
| Answer» C. The organization of individual values with a chart's data series | |
| 5. |
In MS-Excel what chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values? |
| A. | Category axis |
| B. | Data marker |
| C. | Gridline |
| D. | Both (1) & (2) |
| Answer» E. | |
| 6. |
In MS-Excel Documentation should include |
| A. | Destination and users of the output data |
| B. | Source of input data |
| C. | Information on the purpose of the workbook |
| D. | All of the Above |
| Answer» E. | |
| 7. |
In MS-Excel which of the following is an absolute cell reference? |
| A. | !A!1 |
| B. | $A$1 |
| C. | #a#1 |
| D. | None of these |
| Answer» C. #a#1 | |
| 8. |
In MS-Excel 3-D reference in a formula |
| A. | Cannot be modified |
| B. | Only appears on summary worksheets |
| C. | Both (1) & (2) |
| D. | Spans worksheets |
| Answer» E. | |
| 9. |
In MS-Excel comments can be added to cells using |
| A. | Edit > Comments |
| B. | Insert > Comments |
| C. | File > Comments |
| D. | None of these |
| Answer» C. File > Comments | |
| 10. |
In MS-Excel chart wizard term data series refers to |
| A. | A chart legend |
| B. | A collection of chart data markers |
| C. | A set of values you plot in a chart |
| D. | None of these |
| Answer» C. A set of values you plot in a chart | |
| 11. |
In MS-Excel you can open the Sort dialog box by choosing Sort from the . . . . . menu. |
| A. | View |
| B. | Format |
| C. | Tools |
| D. | Data |
| Answer» E. | |
| 12. |
In MS-Excel you can open the scenario Manager dialog box by choosing scenarios from the ..... menu. |
| A. | View |
| B. | Insert |
| C. | Format |
| D. | Tools |
| Answer» E. | |
| 13. |
In MS-Excel to edit in an embedded worksheet object in a word document |
| A. | Use the MS-Excel menu bar and toolbars inside the word application |
| B. | Edit the hyperlink |
| C. | Edit the data in a MS-Excel source application |
| D. | Use the word menu bar and toolbars |
| Answer» B. Edit the hyperlink | |
| 14. |
In MS-Excel circular reference is |
| A. | Geometric modeling tool |
| B. | A cell that points to a drawing object |
| C. | A formula that either directly or indirectly depends on itself |
| D. | None of these |
| Answer» D. None of these | |
| 15. |
In MS-Excel Status indicators are located on the |
| A. | Vertical scroll bar |
| B. | Horizontal scroll bar |
| C. | Formula bar |
| D. | None of these |
| Answer» D. None of these | |
| 16. |
In MS-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 the Above |
| Answer» C. Deletes extra space in text | |
| 17. |
In MS-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 the Above |
| Answer» C. DDB (double-declining) | |
| 18. |
In MS-Excel A data map is helpful |
| A. | When you have too much data to chart |
| B. | To show a geographic distribution of data |
| C. | To compare data points |
| D. | Both (1) & (2) |
| Answer» C. To compare data points | |
| 19. |
In MS-Excel to activate the previous cell in a preselected range, press |
| A. | Alt key |
| B. | Tab key |
| C. | Enter key |
| D. | None of these |
| Answer» E. | |
| 20. |
In MS-Excel to create a formula, you can use |
| A. | Values but not cell references |
| B. | Cell references but not values |
| C. | Values or cell references although not both at the same time |
| D. | Value and cell references |
| Answer» E. | |
| 21. |
In MS-Excel you can open the Highlight Changes dialog box by choosing Track Changes from the .... Menu. |
| A. | Edit |
| B. | Insert |
| C. | Tools |
| D. | None |
| Answer» D. None | |
| 22. |
In computer in which MS-Excel you can copy cell formats from one cell to another by using the |
| A. | Bsckspace key |
| B. | Default font |
| C. | Format painter |
| D. | None of these |
| Answer» D. None of these | |
| 23. |
When you link data maintained in MS-Excel workbook to a Word document |
| A. | The Word document cannot be edited |
| B. | The Word document contains a reference to the original source application |
| C. | The word document must contain a hyperlink |
| D. | Both (2) & (3) |
| Answer» C. The word document must contain a hyperlink | |
| 24. |
In MS-Excel Weight refers to |
| A. | The print density of characters |
| B. | The height of the printed character |
| C. | Upright or slanted shape |
| D. | None of these |
| Answer» B. The height of the printed character | |
| 25. |
In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ........... menu |
| A. | Edit |
| B. | Format |
| C. | Tools |
| D. | All the above |
| Answer» D. All the above | |
| 26. |
In MS-Excel 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 that automatically changes the data point value in the worksheet |
| C. | You can change a data point value and automatically that is drawn in the chart |
| D. | Both (2) & (3) |
| Answer» E. | |
| 27. |
In MS-Excel default header for a worksheet is |
| A. | Your name |
| B. | The date and time |
| C. | date |
| D. | None of these |
| Answer» E. | |
| 28. |
In MS-Excel which of the following is not an option in the spelling dialog box |
| A. | Edit |
| B. | Ignore |
| C. | Ignore all |
| D. | None of these |
| Answer» B. Ignore | |
| 29. |
MS-Excel uses the . . . . Function when creating a data table |
| A. | Average |
| B. | Count |
| C. | Both (1) & (2) |
| D. | Table |
| Answer» E. | |
| 30. |
In MS-Excel which functions will calculate the number of workdays between 6 9 2013 and 8 12 2013 |
| A. | Workday |
| B. | Date |
| C. | Networkday |
| D. | Weekday |
| Answer» E. | |
| 31. |
In MS-Excel how can you print three copies of a workbook? |
| A. | Select File>Properties from the menu and type 3 in the Copies to print text box. |
| B. | Select File >Print from the menu and type 3 in the Number of copies text box |
| C. | Click the Print button on the standard toolbar to print the document then take it to Kinko's and have 2 more copies made |
| D. | None of these |
| Answer» C. Click the Print button on the standard toolbar to print the document then take it to Kinko's and have 2 more copies made | |
| 32. |
In MS-Excel how do you delete a column ? |
| A. | Select the column heading you want to delete and select the Delete Row button on the standard toolbar |
| B. | Select the column heading you want to delete and select Insert Delete from the menu |
| C. | Select the row heading you want to delete and select Edit>Delete from the menu |
| D. | Right click the column heading you want to delete and select delete from the shortcut menu |
| Answer» E. | |
| 33. |
In MS-Excel Text formulas |
| A. | Replace cell references |
| B. | Return ASCII values of characters |
| C. | Concatenate and manipulate text |
| D. | None of these |
| Answer» D. None of these | |
| 34. |
In MS-Excel the cell labeled F5 refers to |
| A. | row F column 5 |
| B. | column F row 5 |
| C. | function available in cells |
| D. | None of these |
| Answer» C. function available in cells | |
| 35. |
In MS-Excel how do you insert a row? |
| A. | Right-click the row heading where you want to insert the new row and select insert from the shortcut menu |
| B. | Select the row heading where you want to insert the new row and select Edit >Row from the menu |
| C. | Select the row heading where you want to insert the new row and click the insert Row button on the standard toolbar |
| D. | All of the above |
| Answer» B. Select the row heading where you want to insert the new row and select Edit >Row from the menu | |
| 36. |
In MS-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. | None of these |
| Answer» C. Decrease the column width | |
| 37. |
In MS-Excel to center worksheet titles across a range of cells, you must |
| A. | Select the cells containing the title text plus the range over which the title text is to be centered and click on ' merge and center ' option from formatting bar |
| B. | Widen the columns |
| C. | Both (1) & (2) |
| D. | Format the cells with the comma style |
| Answer» B. Widen the columns | |
| 38. |
In MS-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 MS-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 MS-Excel that you're about to enter a formula | |
| 39. |
In MS-Excel the following is not a basic step in creating a worksheet |
| A. | Save workbook |
| B. | Modifiy the worksheet |
| C. | Copy the worksheet |
| D. | Both (2) & (3) |
| Answer» E. | |
| 40. |
In MS-Excel when you are typing an equation into a cell the first thing that must be entered is |
| A. | the first cell referenced |
| B. | parenthesis |
| C. | quotation marks |
| D. | an equal sign |
| Answer» E. | |
| 41. |
The basic unit of a worksheet into which you enter data in Excel is called a |
| A. | tab |
| B. | box |
| C. | cell |
| D. | range |
| Answer» D. range | |
| 42. |
In MS-Excel when integrating MS-Word and MS-Excel, MS-Word is usually the |
| A. | Server |
| B. | Destination |
| C. | Client |
| D. | Both (1) and (3) |
| Answer» E. | |
| 43. |
What displays the contents of the active cell in Excel |
| A. | Formula bar |
| B. | Name box |
| C. | Task pane |
| D. | Row Headings |
| Answer» B. Name box | |
| 44. |
In MS-Excel Comments put in cells are called |
| A. | Smart tip |
| B. | Cell tip |
| C. | Web tip |
| D. | None of these |
| Answer» C. Web tip | |
| 45. |
In MS-Excel how can you find specific information in a list? |
| A. | Select Tools > Finder from the menu |
| B. | Click the Find button on the standard toolbar |
| C. | Select lnsert > Find from the menu |
| D. | Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button |
| Answer» E. | |
| 46. |
In MS-Excel two common wildcard characters that MS-Excel recognizes are |
| A. | * and ? |
| B. | < and > |
| C. | ^ and |
| D. | None of these |
| Answer» B. < and > | |
| 47. |
In computer science in which MS-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 toolbar |
| D. | Pressing Ctrl+X |
| Answer» B. Selecting Edit>Cut from the menu | |
| 48. |
In MS-Excel when you copy a formula |
| A. | MS-Excel erases the original copy of the formula |
| B. | MS-Excel edits cell references in the newly copied formula |
| C. | MS-Excel adjusts absolute cell references |
| D. | All of these |
| Answer» C. MS-Excel adjusts absolute cell references | |
| 49. |
In MS-Excel which menu option can be sued to split windows into two |
| A. | Format > window |
| B. | View > window > split |
| C. | Window > split |
| D. | None of these |
| Answer» D. None of these | |
| 50. |
In MS-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. | |