Microsoft Excel MCQ Question and Answer
Microsoft Excel MCQ Question and Answer
51. In Excel which of the following is not an option in the spelling dialog box
- Edit
- Ignore
- Ignore all
- Change
52. In Excel you can quickly change the appearance of your work by choosing Auto Format from the...............menu
- Edit
- View
- Format
- Tools
53. In Excel ................is a group of cells that form a rectangle on the screen
- Calculation
- Formula
- Range
- Range address
54. In Excel following term describes explanatory text attached to a cell
- Callout
- Comment
- Dialog
- Extension
55. In Excel the drag and drop method of copying or moving
- Can be used between worksheets but not workbooks
- Can be used between workbooks but not worksheets
- Can be used between workbooks but not worksheets
- None
56. In Excel 3-D reference in a formula
- Cannot be modified
- Only appears on summary worksheets
- Limits the formatting options
- Spans worksheets
57. In Excel the auto calculate feature
- Can only add values in a range of cells
- Provides a quick way to view the results of an arithmetic operation on a range of cells
- Automatically creates formulas and adds them to a worksheet
- None of the above
58. In Excel to protect a worksheet, you can choose protection and the protect sheet from the ...................... menu.
- Edit
- Format
- Tools
- Data
59. In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the ..............menu.
- Edit
- Insert
- Format
- Tools
60. In Excel which of the following is not a worksheet design criterion
- Effciency
- Auditability
- Description
- Clarity Correct Answer.