Microsoft Excel Questions and Answers

Practice Mode
Showing 10 of 255 questions
Q151
In Excel AutoCalculate will quickly add selected cells if you
  • A right click on the status bar and select Sum
  • B Click the Auto Calculate button on the toolbar
  • C use the key combination Ctrl + $
  • D double click the selection
Answer: Option B
Q152
In Excel the cell labeled F5 refers to
  • A row F column 5
  • B Column F row 5
  • C Function available in cells
  • D function key F4
Answer: Option B
Q153
In Excel when you are typing an equation into a cell the first thing that must be entered is
  • A The first cell referenced
  • B Parenthesis
  • C Quotation marks
  • D an equal sign
Answer: Option D
Q154
In Excel using the Auto Sum button will replace in the selected cell
  • A the sum of values in the cell's column
  • B nothing until you select a range of cells
  • C the sum of the cell's row unless you change the range
  • D a formula which will add values in the range Excel guesses you want to add
Answer: Option D
Q155
In Excel book 1 is an example of how .......are numbered and named during each work session
  • A Active cell
  • B Formula bar
  • C Menu bar
  • D Name box
Answer: Option D
Q156
In Excel the following displays the contents of the active cell
  • A Active cell
  • B Formula bar
  • C Menu bar
  • D Name box
Answer: Option B
Q157
In Excel Graphics objects on a chart are used to
  • A Add emphasis to chart data
  • B Add interest to a chart
  • C Help explain the chart data
  • D All the above
Answer: Option D
Q158
In Excel to select a column the easiest method is to
  • A Doube click any cell in the column
  • B Drag from the top cell in the column to the last cell in the column
  • C Click the column heading
  • D Click the column label
Answer: Option C
Q159
In Excel to select an individual data marker or data label, you must
  • A Double clik the data series
  • B Right click selected marker
  • C Click once to select the series markers r labels and click the desired marker or label again
  • D Double click the marker or label
Answer: Option D
Q160
In Excel to delete and embedded object, first
  • A Double click the object
  • B Select the object by clicking it
  • C Press the Shift + Delete keys
  • D Select it and then press Delete key
Answer: Option D
Questions and Answers for Competitive Exams Various Entrance Test