Microsoft Excel Questions and Answers

Practice Mode
Showing 10 of 255 questions
Q111
In Excell cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is
  • A B1-G10
  • B B1:G10
  • C B1;G10
  • D B1:G10
Answer: Option D
Q112
In Excel advantage of using a spreadsheet is
  • A Calculations can be done automatically.
  • B Changing data automatically updates calculations
  • C More flexibility
  • D All of the above
Answer: Option D
Q113
In Excel intersection of a row and column is called:
  • A Cata
  • B A field
  • C A cell
  • D An equation.
Answer: Option C
Q114
There are three types of data found in a sperad sheet
  • A data, words, numbers
  • B Equations, data, numbers
  • C words, numbers, labels
  • D numbers formulas, labels
Answer: Option D
Q115
In Excel to select a column the easiest method is to
  • A Double click any cell in the column
  • B Drag from the top cell in the colum to the last cell in the column
  • C Click the column heading
  • D Click the column label
Answer: Option C
Q116
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
Q117
In Excel to view a cell comment
  • A Click the edit comment command 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
Q118
In Excel when you want to insert a black imbedded excel object in a word document you can
  • A Click the object command on the insert menu
  • B Click the office links button on the standard toolbar
  • C Click the create worksheet button on the formatting toolbar
  • D Click the import excel command on the file menu
Answer: Option A
Q119
In Excel to save a workbook, you
  • A Click the save button on the standard toolbar from the menu
  • B Press Ctrl + F5
  • C Click Save on the Windows Start button
  • D Select Edit>Save
Answer: Option A
Q120
In Excel you can edit a cell by
  • A Clicking the formula button
  • B Double clicking the cell to edit it in-place
  • C Selecting Edit>Edit Cell from the menu
  • D None of above
Answer: Option B
Questions and Answers for Competitive Exams Various Entrance Test