Microsoft Excel MCQ Question and Answer
Microsoft Excel MCQ Question and Answer
61. In Excel to copy cell contents using drag and drop, press the
- End key
- Shift key
- Esc key
- None of above
62. In Excel if you press.............the cell accepts your typing as its contents.
- Enter
- CTRL + Enter
- Tab
- Insert
63. In Excel the auto fill feature
- Extends a sequential series of data
- Automatially adds a range of cell values
- Applies a boarder around selected cells
- None of above
64. In Excel the keyboard shortcut (button or buttons to be press(D) for creating a chart from the selected cells
- F3
- F5
- F7
- F11
65. In Excel you can use the formula palette to
- Format cells containing numbers
- Create and edit formulas containing functions
- Entered assumptions data
- Copy a range of cells
66. What excel feature can you use if you want to work with one record at a time?
- Auto Complete
- Auto Filter
- Data Form
- Sub Totals
67. 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 ?
- Category axiz
- Data marker
- Data point
- Gridline
68. In Excel what chart object is horizontal or vertical that extends across the plot area to make it easier to read and follow the values ?
- Category axis
- Data marker
- Function
- Range
69. In Excel value used in a formula that does not change is called a
- Contents
- Objects
- Scenarios
- All of above
70. In Excel you can use the drag and drop method to
- Copy cell contents
- Move cell contents
- Add cell contents
- (A) and (B)