Microsoft Excel Questions and Answers

Practice Mode
Showing 10 of 255 questions
Q61
In Excel to copy cell contents using drag and drop, press the
  • A End key
  • B Shift key
  • C Esc key
  • D None of above
Answer: Option D
Q62
In Excel if you press.............the cell accepts your typing as its contents.
  • A Enter
  • B CTRL + Enter
  • C Tab
  • D Insert
Answer: Option A
Q63
In Excel the auto fill feature
  • A Extends a sequential series of data
  • B Automatially adds a range of cell values
  • C Applies a boarder around selected cells
  • D None of above
Answer: Option D
Q64
In Excel the keyboard shortcut (button or buttons to be press(D) for creating a chart from the selected cells
  • A F3
  • B F5
  • C F7
  • D F11
Answer: Option D
Q65
In Excel you can use the formula palette to
  • A Format cells containing numbers
  • B Create and edit formulas containing functions
  • C Entered assumptions data
  • D Copy a range of cells
Answer: Option B
Q66
What excel feature can you use if you want to work with one record at a time?
  • A Auto Complete
  • B Auto Filter
  • C Data Form
  • D Sub Totals
Answer: Option C
Q67
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 ?
  • A Category axiz
  • B Data marker
  • C Data point
  • D Gridline
Answer: Option D
Q68
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 ?
  • A Category axis
  • B Data marker
  • C Function
  • D Range
Answer: Option B
Q69
In Excel value used in a formula that does not change is called a
  • A Contents
  • B Objects
  • C Scenarios
  • D All of above
Answer: Option D
Q70
In Excel you can use the drag and drop method to
  • A Copy cell contents
  • B Move cell contents
  • C Add cell contents
  • D (A) and (B)
Answer: Option D
Questions and Answers for Competitive Exams Various Entrance Test