Microsoft Excel Questions and Answers

Practice Mode
Showing 10 of 255 questions
Q121
In Excel you can select a single range of cells by
  • A 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
  • B Pressing the Ctrl key while dragging over the desired cells
  • C Pressing the Shift key and an arrow key
  • D Dragging over the desired cells
Answer: Option D
Q122
In excell to copy cell contents using drag and drop press the
  • A End key
  • B Shift key
  • C Ctrl key
  • D Esc key
Answer: Option D
Q123
In Excel when you copy a formula
  • A Excel erases the original copy of the formula
  • B excel edits cell references in the newly copied formula
  • C Excel adjusts absolute cell references
  • D Excel doesn't adjust relative cell references
Answer: Option B
Q124
In Excel autofill feature
  • A Extends a sequential series of data
  • B Automatically adds range of cell values
  • C Applies a boarder around the selected cells
  • D None of the above
Answer: Option B
Q125
In Excel which menu option can be sued to split windows into two
  • A Format > window
  • B View > window > split
  • C Window > split
  • D View > split
Answer: Option C
Q126
In Excel whch of the following special function keys allow the content in cell
  • A Esc
  • B Shift
  • C Return
  • D Tab
Answer: Option C
Q127
In Excel which is not an advantage of using computerized spreadsheets ?
  • A Flexibility of moving entries
  • B Speed of calculation
  • C Ability of generate tables
  • D Cost of initial setup
Answer: Option D
Q128
In Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
  • A Unfreeze panes command on the window menu
  • B Freeze panes command on the window menu
  • C Hold titles command on the edit menu
  • D Split command on the window menu
Answer: Option B
Q129
In excel the following will not cut information
  • A Pressing Ctrl + C
  • B Selecting Edit > Cut from the menu
  • C Clicking the Cut button on the standard
  • D Pressing Ctrl + X
Answer: Option A
Q130
In Excel which of the following is not a way to complete a cell entry ?
  • A Pressing enter
  • B Pressing any arrow key on the keyboard
  • C Clicking the Enter button on the Formula bar
  • D Pressing spacebar
Answer: Option D

📚 More from Computer Science & Engineering(CSE)

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Computer Science & Engineering(CSE)
Back to Computer Science & Engineering(CSE)
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test