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.
| 1. |
What will be the result if you type =A1=B1 in cell C1? |
| A. | Yes or No |
| B. | True or False |
| C. | Value of A1 |
| D. | Value of B1 |
| Answer» C. Value of A1 | |
| 2. |
Files created with Lotus 1-2-3 have anextension |
| A. | DOC |
| B. | XLS |
| C. | 123 |
| D. | WK1 |
| Answer» D. WK1 | |
| 3. |
Which is an example of a formula? |
| A. | 0 |
| B. | 0 |
| C. | A1+A2 |
| D. | SUM(A1:A2) |
| Answer» B. 0 | |
| 4. |
In Excel which functions will calculate thenumber of workdays between 6/9/2004 and 8/12/2004 |
| A. | Workday |
| B. | Date |
| C. | Networkdays |
| D. | All of the above |
| Answer» E. | |
| 5. |
Where a row and a column meet, what do you call that? |
| A. | A cell |
| B. | A block |
| C. | A box |
| D. | None of the above |
| Answer» B. A block | |
| 6. |
In 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. | Headers and Footers |
| Answer» B. Page Orientation | |
| 7. |
What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula? |
| A. | Goal Seek |
| B. | Scenario Summary report |
| C. | Forecasting |
| D. | Trend line |
| Answer» E. | |
| 8. |
What value will display if the formula = “$55.00″+5 is entered into a cell? |
| A. | $60 |
| B. | 60 |
| C. | “$55.00″+5 |
| D. | $60.00 |
| Answer» C. “$55.00″+5 | |
| 9. |
In Excel a fast way to add up this column of number is to click in the cell below the numbers and then |
| A. | Click subtotals on the data menu |
| B. | View the sum in the formula bar |
| C. | Click the autosum button on the standard toolbar, then press enter |
| D. | All of above |
| Answer» D. All of above | |
| 10. |
In Excel which of the following formulas is not entered correctly? |
| A. | 0 |
| B. | 0 |
| C. | 0 |
| D. | 10+50 |
| Answer» E. | |
| 11. |
If you want all of the white cats grouped together in the database, you need to sort by ________. |
| A. | Color, then Gender |
| B. | Pet Type, then Color |
| C. | Pet Type, then Gender |
| D. | Color, then Pet Name |
| Answer» C. Pet Type, then Gender | |
| 12. |
A numeric value can be treated as label value if …… precedes it. |
| A. | Apostrophe (‘) |
| B. | Exclamation (!) |
| C. | Hash (#) |
| D. | Tilde (~) |
| Answer» B. Exclamation (!) | |
| 13. |
In Excel to copy cell contents using drag and drop, press the |
| A. | End key |
| B. | Shift key |
| C. | Esc key |
| D. | None of above |
| Answer» E. | |
| 14. |
In Excel Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following? |
| A. | Rows and column |
| B. | Headings |
| C. | Speed |
| D. | None |
| Answer» D. None | |
| 15. |
In Excel to delete and embedded object, first |
| A. | Double click the object |
| B. | Select the object by clicking it |
| C. | Press the Shift + Delete keys |
| D. | Select it and then press Delete key |
| Answer» E. | |
| 16. |
Getting data from a cell located in a different sheet is called |
| A. | Accessing |
| B. | Referencing |
| C. | Updating |
| D. | Functioning |
| Answer» C. Updating | |
| 17. |
In Excel to name a constant, you use the…… dialog box |
| A. | Create name |
| B. | Define name |
| C. | Paste name |
| D. | Format cells |
| Answer» C. Paste name | |
| 18. |
In Excel to select an individual data marker or data label, you must |
| A. | Double click the data series |
| B. | Right click selected marker |
| C. | Click once to select the series markers or labels and click the desired marker or label again |
| D. | Double click the marker or label |
| Answer» E. | |
| 19. |
In a worksheet you can press Shift+Space to select entire |
| A. | Worksheet |
| B. | Row |
| C. | Column |
| D. | a, b, and c |
| Answer» E. | |
| 20. |
In 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 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 | |
| 21. |
In Excel getting data from a cell located in adifferent sheet is called |
| A. | Accessing |
| B. | Referencing |
| C. | Updating |
| D. | Functioning |
| Answer» C. Updating | |
| 22. |
How to restrict to run a macro automatically when starting Microsoft Excel? |
| A. | Hold down the SHIFT key during startup |
| B. | Hold down the CTRL key during startup |
| C. | Hold down the ESC key during startup |
| D. | Hold down the ALT key during startup |
| Answer» B. Hold down the CTRL key during startup | |
| 23. |
In Excel A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button |
| A. | nothing will print because some cells with data have been omitted |
| B. | only the cells with gray background will print |
| C. | the whole sheet will print |
| D. | only the cells with white background will print |
| Answer» E. | |
| 24. |
In Excel got functions? No? You need the insert function dialog box. How do you get it? |
| A. | Right click a cell and then click insert |
| B. | Click the insert menu and then click function |
| C. | Type = in a cell |
| D. | All of the above |
| Answer» C. Type = in a cell | |
| 25. |
In Excel, by default Numeric Values appears in |
| A. | Left aligned |
| B. | Right aligned |
| C. | Center aligned |
| D. | Justify aligned |
| Answer» C. Center aligned | |
| 26. |
In 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 | |
| 27. |
If particular workbook have to open each time Excel started, where that workbook should be placed? |
| A. | AUTOEXEC Folder |
| B. | AUTOSTART Folder |
| C. | EXCELSTART Folder |
| D. | XLSTART Folder |
| Answer» E. | |
| 28. |
In Excel divide symbol is |
| A. | / |
| B. | D |
| C. | \ |
| D. | ) |
| Answer» B. D | |
| 29. |
In Excel to copy cell contents using drag anddrop press the |
| A. | End key |
| B. | Shift key |
| C. | Ctrl key |
| D. | Esc key |
| Answer» E. | |
| 30. |
Which of the following is a correct order of precedence in a formula calculation? |
| A. | Multiplication and division, exponential positive and negative value |
| B. | Multiplication and division, positive and negative values, addition and subtraction |
| C. | Addition and subtraction, positive and negative values, exponentiation |
| D. | None of above |
| Answer» E. | |
| 31. |
In Excel when you copy a formula |
| A. | Excel erases the original copy of the formula |
| B. | Excel edits cell references in the newly copied formula |
| C. | Excel adjusts absolute cell references |
| D. | Excel doesn’t adjust relative cell references |
| Answer» C. Excel adjusts absolute cell references | |
| 32. |
In Excel when you want to insert a blank imbedded excel object 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 | |
| 33. |
In Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ….. ……menu |
| A. | Edit |
| B. | Format |
| C. | Tools |
| D. | Data |
| Answer» D. Data | |
| 34. |
In 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 |
| B. | Widen the columns |
| C. | Select the cells containing the title text plus the range over which the title text is to be enfettered |
| D. | Format the cells with the comma style |
| Answer» B. Widen the columns | |
| 35. |
Which of the following syntax is correct regarding to SUM function in Excel? |
| A. | 0 |
| B. | 0 |
| C. | 0 |
| D. | All of the above |
| Answer» E. | |
| 36. |
How to remove the unwanted action from recorded macro without recording the whole macro again? |
| A. | By using the Find and Edit Action Option |
| B. | By clicking on the Refresh button in the Macro toolbar |
| C. | By edit the macro in the Visual Basic Editor |
| D. | Macro cannot be edited. |
| Answer» D. Macro cannot be edited. | |
| 37. |
In Excel the following is not an example of a value |
| A. | 350 |
| B. | May 10, 2001 |
| C. | 57&per cent |
| D. | Serial Number 50771 |
| Answer» E. | |
| 38. |
In 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. | |
| 39. |
In Excel which do you press to enter the current date in a cell? |
| A. | Ctrl + Shift + : |
| B. | Ctrl + ; |
| C. | Ctrl + F10 |
| D. | All of above |
| Answer» C. Ctrl + F10 | |
| 40. |
Excel uses the …. Function when creating a data table |
| A. | Average |
| B. | Count |
| C. | Sum |
| D. | Table |
| Answer» E. | |
| 41. |
There are three types of data found in a spreadsheet |
| A. | data, words, numbers |
| B. | equations, data, numbers |
| C. | words, numbers, labels |
| D. | numbers formulas, labels |
| Answer» E. | |
| 42. |
In 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. | The data range that supply chart data |
| Answer» C. The organization of individual values with a chart’s data series | |
| 43. |
Which of the following methods will not enter data in a cell? |
| A. | Pressing the Esc key |
| B. | Pressing an arrow key |
| C. | Pressing the tab key |
| D. | Clicking the enter button to the formula bar |
| Answer» B. Pressing an arrow key | |
| 44. |
In Excel Status indicators are located on the |
| A. | Vertical scroll bar |
| B. | Horizontal scroll bar |
| C. | Formula bar |
| D. | Standard toolbar |
| Answer» D. Standard toolbar | |
| 45. |
In Excel the following is not information you can specify using the solver |
| A. | Input cells |
| B. | Constraints |
| C. | Target cell |
| D. | Changing cells |
| Answer» B. Constraints | |
| 46. |
In Excel two common wildcard characters that Excel recognizes are |
| A. | * and ? |
| B. | < and > |
| C. | ^ and / |
| D. | + and - |
| Answer» B. < and > | |
| 47. |
In Excel you can convert existing excel worksheet data an charts to an HTML document by using |
| A. | FTP wizard |
| B. | Internet assistant wizard |
| C. | Intranet wizard |
| D. | Import wizard |
| Answer» C. Intranet wizard | |
| 48. |
In Excel to select a column the easiestmethod 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. | Click the column label |
| Answer» D. Click the column label | |
| 49. |
In 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. | Select a background color |
| Answer» B. Select a fore ground color | |
| 50. |
In 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. | |