Microsoft Excel Questions and Answers

Practice Mode
Showing 10 of 255 questions
Q211
In Excel how do you change column width to fit the contents >
  • A Single-click the boundary to the left to the column heading
  • B Double click the boundary to the right of the column heading
  • C Press Alt and single click anywhere in the column
  • D All of above
Answer: Option B
Q212
In Excel when you work with large worksheets, you may need to
  • A Size the worksheet to fit on the specific number of pages
  • B Add and remove page breaks
  • C Specify only certain print areas
  • D All of above
Answer: Option D
Q213
In excel Hyperlinks cannot be
  • A Special shapes like stars and banners
  • B Drawing objects like rectangles ovals
  • C Pictures
  • D All can be hyperlink
Answer: Option D
Q214
In excel you can use the horizontal and vertica scroll bars to
  • A Split a worksheet into two panes
  • B View different rows and columns
  • C Edit the contents of a cell
  • D View different worksheets
Answer: Option B
Q215
What do we call a computer program that organizes data in rows and columns of cells ? you might use this type of program to keep a record of the money you earned moving lawns over the summer.
  • A Spreadsheet program
  • B Database program
  • C Wordprocessor program
  • D Desktop publisher program
Answer: Option A
Q216
In Excel you can add an image t template by cliking the Insert Picture from File button on the ......... Toolbar
  • A Standard
  • B Formatting
  • C Drawing
  • D Picture
Answer: Option D
Q217
In Excel to drag a selected range of data to another worksheet in the same workbook,l use the
  • A Tab key
  • B Alt key
  • C Shift key
  • D Ctrl key
Answer: Option D
Q218
In Excel when creating a vertical page break
  • A The active cell must be A1
  • B The active cell can be anywhere in the worksheet
  • C The active cell must be row 1
  • D The Active cell must be in column A
Answer: Option C
Q219
In Excel to activate the previous cell in preselected range, press
  • A The Alt Key
  • B the Tab key
  • C The Enter key
  • D None of above
Answer: Option D
Q220
In Excel when the formula bar is activated you can use
  • A The edit formula button
  • B the Cancel button
  • C the Enter button
  • D all of above
Answer: Option D
Questions and Answers for Competitive Exams Various Entrance Test