McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Common Topics in Competitive and Entrance exams , Microsoft Office .
| 1. |
In Excel default header for a worksheet is |
| A. | Your name |
| B. | The date and time |
| C. | None |
| D. | The sheet tab name |
| Answer» C. None | |
| 2. |
In Excel which of the following is not an option in the spelling dialog box |
| A. | Edit |
| B. | Ignore |
| C. | Ignore all |
| D. | Change |
| Answer» A. Edit | |
| 3. |
Excel uses the …. Function when creating a data table |
| A. | Average |
| B. | Count |
| C. | Sum |
| D. | Table |
| Answer» D. Table | |
| 4. |
In Excel you can copy cell formats from one cell to another by using the |
| A. | Backspace key |
| B. | Default font |
| C. | Format painter |
| D. | Formatting toolbar |
| Answer» C. Format painter | |
| 5. |
In Excel accounting style shows negative numbers in |
| A. | Bold |
| B. | Brackets |
| C. | Parentheses |
| D. | Quotes |
| Answer» C. Parentheses | |
| 6. |
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» D. (A) and (C) | |
| 7. |
In 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. | Can only be used to create embedded charts |
| Answer» B. Can only place a chart on new chart sheet | |
| 8. |
In Excel which functions will calculate the number of workdays between 6/9/2004 and 8/12/2004 |
| A. | Workday |
| B. | Date |
| C. | Networkdays |
| D. | All of the above |
| Answer» D. All of the above | |
| 9. |
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» B. You can change the position of a data marker and automatically change the data point value in the worksheet | |
| 10. |
In Excel when you group worksheets |
| A. | You can enter variable data on multiple worksheets at one time |
| B. | You can print more than one worksheet at a time |
| C. | You can enter common data, formats, and formulas on multiple worksheets at one time |
| D. | (B) and (C) |
| Answer» D. (B) and (C) | |
| 11. |
In 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» D. All of the above | |
| 12. |
You cannot link Excel worksheet data to a Word document |
| A. | With the right drag method |
| B. | With a hyperlink |
| C. | With the copy and paste special commands |
| D. | With the copy and paste buttons on the standard toolbar |
| Answer» D. With the copy and paste buttons on the standard toolbar | |
| 13. |
In Excel this type of software is similar to an accountant’s worksheet |
| A. | Word processing |
| B. | Database |
| C. | Spreadsheets |
| D. | Graphics |
| Answer» C. Spreadsheets | |
| 14. |
In 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. | Pressing Alt key and clicking the format painter button |
| Answer» B. Double clicking the format painter button | |
| 15. |
In Excel you can quickly change the appearance of your work by choosing Auto Format from the ……….. Menu |
| A. | Edit |
| B. | View |
| C. | Format |
| D. | Tools |
| Answer» C. Format | |
| 16. |
In Excel….. is a group of cells that form a rectangle on the screen. |
| A. | Calculation |
| B. | Formula |
| C. | Range |
| D. | Range address |
| Answer» C. Range | |
| 17. |
In Excel following term describes explanatory text attached to a cell |
| A. | Callout |
| B. | Comment |
| C. | Dialog |
| D. | Extension |
| Answer» B. Comment | |
| 18. |
In Excel the drag and drop method of copying or moving |
| A. | Can be used between worksheets but not workbooks |
| B. | Can be used between workbooks but not worksheets |
| C. | Can be used between workbooks but not worksheets |
| D. | None |
| Answer» C. Can be used between workbooks but not worksheets | |
| 19. |
In Excel 3-D reference in a formula |
| A. | Cannot be modified |
| B. | Only appears on summary worksheets |
| C. | Limits the formatting options |
| D. | Spans worksheets |
| Answer» D. Spans worksheets | |
| 20. |
In Excel the auto calculate feature |
| A. | Can only 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 formulas and adds them to a worksheet |
| D. | None of the above |
| Answer» B. Provides a quick way to view the results of an arithmetic operation on a range of cells | |
| 21. |
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» C. Tools | |
| 22. |
In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu. |
| A. | Edit |
| B. | Insert |
| C. | Format |
| D. | Tools |
| Answer» D. Tools | |
| 23. |
In Excel which of the following is not a worksheet design criterion |
| A. | Efficiency |
| B. | Auditability |
| C. | Description |
| D. | Clarity Correct Answer: |
| Answer» C. Description | |
| 24. |
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» D. None of above | |
| 25. |
In Excel if you press …….., the cell accepts your typing as its contents. |
| A. | Enter |
| B. | Ctrl + Enter |
| C. | TAB |
| D. | Insert |
| Answer» A. Enter | |
| 26. |
In Excel the auto fill feature |
| A. | Extends a sequential series of data |
| B. | Automatically adds a range of cell values |
| C. | Applies a boarder around selected cells |
| D. | None of above |
| Answer» D. None of above | |
| 27. |
In Excel the keyboard shortcut (button or buttons to be presse(D) for creating a chart from the selected cells |
| A. | F3 |
| B. | F5 |
| C. | F7 |
| D. | F11 |
| Answer» D. F11 | |
| 28. |
In 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. | Copy a range of cells |
| Answer» B. Create and edit formulas containing functions | |
| 29. |
What 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. | Sub Totals |
| Answer» C. Data Form | |
| 30. |
In 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. | Data point |
| D. | Gridline |
| Answer» D. Gridline | |
| 31. |
In Excel value used in a formula that does not change is called a |
| A. | Cell address |
| B. | Constant |
| C. | Function |
| D. | Range |
| Answer» B. Constant | |
| 32. |
In Excel which elements of worksheet can be protected from accidental modification ? |
| A. | Contents |
| B. | Objects |
| C. | Scenarios |
| D. | All of above |
| Answer» D. All of above | |
| 33. |
In Excel you can use the drag and drop method to |
| A. | Copy cell contents |
| B. | Move cell contents |
| C. | Add cell contents |
| D. | (A) and (B) |
| Answer» D. (A) and (B) | |
| 34. |
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» B. No data will be entered in the adjacent cells | |
| 35. |
In Excel how can you delete a record? |
| A. | Delete the column from the worksheet |
| B. | Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button |
| C. | Select Data > Delete Record from the menu |
| D. | Click the Delete button on the Standard toolbar |
| Answer» B. Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button | |
| 36. |
Right clicking something in 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. | Selects the object |
| Answer» C. Opens a shortcut menu listing everything you can do to the object | |
| 37. |
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» D. All of the above | |
| 38. |
Files created with Lotus 1-2-3 have an extension |
| A. | DOC |
| B. | XLS |
| C. | 123 |
| D. | WK1 |
| Answer» C. 123 | |
| 39. |
In Excel to delete an embedded objects, 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 the delete key |
| Answer» D. Select it and then press the delete key | |
| 40. |
In Excel comments can be added to cells using |
| A. | Edit > Comments |
| B. | Insert > Comments |
| C. | File > Comments |
| D. | View > Comments |
| Answer» B. Insert > Comments | |
| 41. |
In Excel which of the following is not a worksheet design criterion? |
| A. | Efficiency |
| B. | Aditibility |
| C. | Description |
| D. | Clarity |
| Answer» C. Description | |
| 42. |
In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page? |
| A. | Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles. |
| B. | Click page setup on the file menu, click the page tab, click the options button, then enter your choices. |
| C. | Click page setup on the finle menu, click the sheet tab, and make a selection under the print heading. |
| D. | All of above |
| Answer» A. Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles. | |
| 43. |
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» C. Click the autosum button on the standard toolbar, then press enter | |
| 44. |
In Excel which of the following is an absolute cell reference? |
| A. | !A!1 |
| B. | $A$1 |
| C. | #a#1 |
| D. | A1 |
| Answer» B. $A$1 | |
| 45. |
In Excel what symbol is used before a number to make it a label? |
| A. | “ (quote) |
| B. | = (equal) |
| C. | _ (underscore) |
| D. | ‘ (apostrophe) |
| Answer» B. = (equal) | |
| 46. |
In Excel which symbol must all formula begin with? |
| A. | = |
| B. | + |
| C. | ( |
| D. | @ |
| Answer» A. = | |
| 47. |
In Excel which of the following formulas is not entered correctly? |
| A. | =10+50 |
| B. | =B7*B1 |
| C. | =B7+14 |
| D. | 10+50 |
| Answer» D. 10+50 | |
| 48. |
In Excel which of the following formulas will Excel not be able to calculate? |
| A. | =SUM(Sales)-A3 |
| B. | =SUM(A1:A5)*.5 |
| C. | =SUM(A1:A5)/(10-10) |
| D. | =SUM(A1:A5)-10 |
| Answer» A. =SUM(Sales)-A3 | |
| 49. |
In Excel typical worksheet has …. Number of columns |
| A. | 128 |
| B. | 256 |
| C. | 512 |
| D. | 1024 |
| Answer» B. 256 | |
| 50. |
In Excel how many characters can be typed in a single cell? |
| A. | 256 |
| B. | 1024 |
| C. | 32,000 |
| D. | 65,535 |
| Answer» D. 65,535 | |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.