Microsoft Excel MCQ Question and Answer
Microsoft Excel MCQ Question and Answer
71. In Excel it is acceptable of let long text flow into adjacent cells on a worksheet when
- Data will be entered in the adjacent cells
- No data will be entered in the adjacent cells
- There is not suitable abbreviation of the text
- There is not time to format the next
72. In Excel how can you delete a record ?
- Delete the column from the worksheet
- Select Data > Form from the menu to open the Data form dialog box, fnd the record and click the Delete button
- Select Data > Delete Record from the menu
- Click the Delete button on the Standard toolbar
73. Right clicking something in Excel
- Deletes the object
- Nothing the right mouse button is there ffor left handed people
- Opens a shortcut menu listing everything you can do to the object
- Selects the object
74. In Excel documentation should include
- Destination and users of the output data
- Source of input data
- Information on the purpose of the workbook
- All of the above
76. In Excel to delete an embeded objects, first
- Double click the object
- Select the object by clicking it
- Press the Shift + Delete keys
- Select it and then press the delete key
77. In Excel comments can be added to cells using
- Edit > Comments
- Insert > Comments
- File > Comments
- View > Comments
78. In Excel which of the following is not a worksheet design criterion ?
- Efficiency
- Aditibility
- Description
- Clarity
79. 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 ?
- Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles.
- Click page setup on the file menu, click the page tab, click the options button, then enter your choices.
- Click page setup on the file menu, click the sheet tab, and make a selection under the print heading.
- All of above
80. In Excel a fast way to add up this column of number is to click in the cell below the numbers and then
- Click subtotals on the data menu
- View the sum in the formula bar
- Click the autosum button on the standard toolbar, then press enter
- All of above