Microsoft Excel Questions and Answers

Practice Mode
Showing 10 of 255 questions
Q91
In Excel Chart Wizard term data categories refers to
  • A A chart plot area
  • B A horizontal axis
  • C The organization of individual values with a chart's data series
  • D The data range that supply chart data
Answer: Option B
Q92
In Excel worksheet range is a
  • A A command used for data modeling
  • B A range of values sucha as from 23 to 234
  • C A group of cells
  • D A group of worksheets
Answer: Option C
Q93
In Excel getting data from a cell located in a different sheet is called
  • A Accessing
  • B Referencing
  • C Updating
  • D Functioning
Answer: Option B
Q94
In Excel Tab scrolling button
  • A Allow you to view a different worksheet
  • B Allow you to view additional worksheet rows down
  • C Allow you to view additional worksheet Columns to the right
  • D Allow you to view additional sheets tabs
Answer: Option D
Q95
In Excel numeric value can be treated as a label value if it preceds with
  • A apostrophe(')
  • B Exclamation(!)
  • C hash(#)
  • D Ampresand(&)
Answer: Option A
Q96
In Excel numeric value can be treated as a label value if it preceds with
  • A Apostrophe(')
  • B Exclamation(!)
  • C hash(#)
  • D Ampersand(&)
Answer: Option D
Q97
In Excel to view a cell comment
  • A Click the edit comment commands on the insert menu
  • B Click the Display comment command on the window menu
  • C Position the mouse pointer over the cell
  • D Click the comment command on the view menu
Answer: Option C
Q98
In Excel say that you want to paste a formula result - but not the underlying formula - to another cell . In excel 2002. you would copy the cell with the formula. then place the insertion point in the cell yu want to copy to what next ?
  • A Click the Paste button on the Standard toolbar
  • B Click the arrow on the paste button on the standard toolbar, then click formulas
  • C Click the arrow on the paste button on the standard toolbar, then click values.
  • D All of above.
Answer: Option C
Q99
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
Q100
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 Shft 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
Questions and Answers for Competitive Exams Various Entrance Test