Microsoft Excel Questions and Answers

Practice Mode
Showing 10 of 255 questions
Q161
This tye of software contains rows and columns.
  • A Drawing
  • B Spreadsheet
  • C Database
  • D Word processing
Answer: Option B
Q162
In Excel to open an existing workbook, you can click the Open button on the.........toolbar
  • A drawing
  • B Formatting
  • C Forms
  • D Standard
Answer: Option D
Q163
In Excel you can activate  a cell by
  • A Pressing the Tab key
  • B Clicking the cell
  • C Pressing an arrow key
  • D All of above
Answer: Option D
Q164
In Excel  the following setup options cannot be set in the page setup dialog box ?
  • A Printer selection
  • B Vertical or horizontal placement
  • C Orientation
  • D Row and column titles
Answer: Option A
Q165
In Excel term refers to  a specific set of values saved with the workbook
  • A Range
  • B Scenario
  • C Trend line
  • D What-if analysis
Answer: Option B
Q166
In Excel got functions ? No ? You need the insert function dialog box. How do you get it ?
  • A Right click a cell and then click insert
  • B Click the insert menu and then click function
  • C Type = in a cell
  • D All of the above
Answer: Option B
Q167
In Excel the following describes how to select all the cells in a single column ?
  • A Right click on column and select Pick from list
  • B Use data - text to columns menu item
  • C Left click the gray column title button
  • D Pressing Ctrl + A on the key board
Answer: Option C
Q168
In Excel when you use the fill effects in the format data series dialog box, you cannot
  • A Rotate text on the chart
  • B Select a fore ground color
  • C Select a pattern
  • D Select a background colour
Answer: Option A
Q169
In Excel paper speradsheets can have all the same advantages as an electronic sperad sheet except which of the following ?
  • A Rows and columns
  • B Headlings
  • C Speed
  • D None
Answer: Option C
Q170
In Excel the following is not a basic step in creating a worksheet
  • A Save the workbook
  • B Modify the worksheet
  • C Enter text and data
  • D Copy the worksheet
Answer: Option D
Questions and Answers for Competitive Exams Various Entrance Test