Microsoft Excel Questions and Answers

Practice Mode
Showing 10 of 255 questions
Q41
In Excel you can use drag and drop to embed excel worksheet data in a word document
  • A By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
  • B By dragging a range of excel data to the Word button on the taskbar while pressing shift key
  • C By displaying both applications side-by-side and dragging a selected range of Excel data into the word application window while pressing the Ctrl key
  • D (A) and (C)
Answer: Option D
Q42
In Excel the chart wizard
  • A Can place a chart on a new chart sheet or on any sheet in the workbook
  • B Can only place a chart on new chart sheet
  • C Can only place a chart on a new black worksheed
  • D Can only be used to create embeded charts
Answer: Option B
Q43
In Excel which functionw will calculate the number of workdays between 6/9/2004 and 8/12/2004
  • A Workday
  • B Date
  • C Networkdays
  • D All of the above
Answer: Option D
Q44
In Excel data marker on a chart are linked to data points in a worksheet, thereore,
  • A You can automatically apply formatting to a data series
  • B you can change the position of data marker and automatically change the data point value in the worksheet
  • C You can change a data print value and automatically are draw the chart
  • D (A) and (B)
Answer: Option B
Q45
In Excel when you group worksheets
  • A You can enter variable data on multiple worksheets at one time
  • B you can print more than one worksheet at a time
  • C You can enter common data, formats, and formulas on multiple worksheets at one time
  • D (B) and (C)
Answer: Option D
Q46
In Excel you can zoom a worksheet
  • A With the mouse pointer in Print Preview
  • B With the zoom button on the Print Preview toolbar
  • C With the Zoom command on the view menu
  • D All of the above
Answer: Option D
Q47
You cannot link Excel worksheet data to a word document
  • A With the right drag method
  • B With a hyperlink
  • C With the copy and paste special commands
  • D With the copy and paste buttons on the standard toolbar
Answer: Option D
Q48
In Excel this type of a software is similar to an accountant's worksheet
  • A Word processing
  • B Database
  • C Spreadsheets
  • D Graphics
Answer: Option C
Q49
In Excel you can use the format painter multiple times before you turn it off by
  • A You can use the format painter button only one time when you click it
  • B Double clicking the formatj painter button
  • C Pressing the Ctrl key and clicking the format painter button
  • D Pressing Alt key and clicking the format painter button
Answer: Option B
Q50
In Excel default header for a worksheet is
  • A Your name
  • B The date and time
  • C None
  • D None the sheet tab name
Answer: Option C
Questions and Answers for Competitive Exams Various Entrance Test