Microsoft Excel MCQ Question and Answer
Microsoft Excel MCQ Question and Answer
121. In Excel you can select a single range of cells by
- Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
- Pressing the Ctrl key while dragging over the desired cells
- Pressing the Shift key and an arrow key
- Dragging over the desired cells
122. In excell to copy cell contents using drag and drop press the
- End key
- Shift key
- Ctrl key
- Esc key
123. In Excel when you copy a formula
- Excel erases the original copy of the formula
- excel edits cell references in the newly copied formula
- Excel adjusts absolute cell references
- Excel doesn't adjust relative cell references
124. In Excel autofill feature
- Extends a sequential series of data
- Automatically adds range of cell values
- Applies a boarder around the selected cells
- None of the above
125. In Excel which menu option can be sued to split windows into two
- Format > window
- View > window > split
- Window > split
- View > split
126. In Excel whch of the following special function keys allow the content in cell
- Esc
- Shift
- Return
- Tab
127. In Excel which is not an advantage of using computerized spreadsheets ?
- Flexibility of moving entries
- Speed of calculation
- Ability of generate tables
- Cost of initial setup
128. In Excel To hold row and column titles in place so that they do not 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
129. In excel the following will not cut information
- Pressing Ctrl + C
- Selecting Edit > Cut from the menu
- Clicking the Cut button on the standard
- Pressing Ctrl + X
130. In Excel which of the following is not a way to complete a cell entry ?
- Pressing enter
- Pressing any arrow key on the keyboard
- Clicking the Enter button on the Formula bar
- Pressing spacebar