Microsoft Excel Questions and Answers
Microsoft Excel questions with answers are frequently asked in campus placements and government exams to test candidates’ data-handling and analytical abilities. As part of programming questions and answers, Excel is not only a spreadsheet tool but a mini-programming environment through its formulas, macros, and data functions. Mastering Excel helps in automating tasks, analyzing large datasets, and building reports efficiently. This topic covers essential Excel MCQs focusing on functions like VLOOKUP, pivot tables, charts, conditional formatting, and data analysis tools. Whether you’re preparing for TCS, Infosys, or SSC exams, practicing Excel questions enhances your technical aptitude and boosts your problem-solving efficiency.
Microsoft Excel
Showing 10 of
255 questions
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