Microsoft Excel MCQ Question and Answer
Microsoft Excel MCQ Question and Answer
31. The AutoFill feature
- extends a sequential series of data
- automatically adds a range of cell values
- selects a range of cells
- none of the above
32. You can copy data or formulas
- with the copy, paste and cut commands on the edit menu
- with commands on a shortcut menu
- with buttons on the standard toolbar
- all of the above
33. To view a cell comment
- click the edit comment command on theinsert menu
- click the display comment command on the window menu
- position the mouse pointer over the cell
- click the comment command on the view menu
34. To hold row and column titles in place so that they do not scroll when you scroll when you scroll a worksheet, click the
- unfreeze panes command on the window menu
- freeze panes command on the window menu
- hold titles command on the edit menu
- split command on the window menu
35. In Excel default header for a worksheet is
- Your name
- The date and time
- None
- The sheet tab name
36. In Excel which of the following is not an option in the spelling dialog box
- Edit
- Ignore
- Ignore all
- Change
37. Excel uses the ............. Function when creating a data table
- Average
- Count
- Sum
- Table
38. In Excel you can copy cell formats from one cell to another by using the
- Backspace key
- Default font
- Format painter
- Formatting toolbar
39. In Excel accounting style shows negative numbers in
- Bold
- Brackets
- Parentheses
- Quotes
40. In Excel you can use drag and drop to embed excel worksheet data in a word document
- By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
- By dragging a range of excel data to the Word button on the taskbar while pressing Shift key
- 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
- (A) and (C)