Microsoft Excel MCQ Question and Answer
Microsoft Excel MCQ Question and Answer
41. In Excel you can use drag and drop to embed excel worksheet data in a word document
- By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
- By dragging a range of excel data to the Word button on the taskbar while pressing shift key
- 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
- (A) and (C)
42. In Excel the chart wizard
- Can place a chart on a new chart sheet or on any sheet in the workbook
- Can only place a chart on new chart sheet
- Can only place a chart on a new black worksheed
- Can only be used to create embeded charts
43. In Excel which functionw will calculate the number of workdays between 6/9/2004 and 8/12/2004
- Workday
- Date
- Networkdays
- All of the above
44. In Excel data marker on a chart are linked to data points in a worksheet, thereore,
- You can automatically apply formatting to a data series
- you can change the position of data marker and automatically change the data point value in the worksheet
- You can change a data print value and automatically are draw the chart
- (A) and (B)
45. In Excel when you group worksheets
- You can enter variable data on multiple worksheets at one time
- you can print more than one worksheet at a time
- You can enter common data, formats, and formulas on multiple worksheets at one time
- (B) and (C)
46. In Excel you can zoom a worksheet
- With the mouse pointer in Print Preview
- With the zoom button on the Print Preview toolbar
- With the Zoom command on the view menu
- All of the above
47. You cannot link Excel worksheet data to a word document
- With the right drag method
- With a hyperlink
- With the copy and paste special commands
- With the copy and paste buttons on the standard toolbar
48. In Excel this type of a software is similar to an accountant's worksheet
- Word processing
- Database
- Spreadsheets
- Graphics
49. In Excel you can use the format painter multiple times before you turn it off by
- You can use the format painter button only one time when you click it
- Double clicking the formatj painter button
- Pressing the Ctrl key and clicking the format painter button
- Pressing Alt key and clicking the format painter button
50. In Excel default header for a worksheet is
- Your name
- The date and time
- None
- None the sheet tab name