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
1. You can convert existing Excel worksheet data and charts to an HTML document by using the
- FTP Wizard
- Internet assistant wizard
- Internet wizard
- Import wizard
2. When integrating word and excel, word is usually the
- server
- client
- destination
- 2 & 3
3. Hyperlinks cannot be
- special shapes like stars and banners
- drawing objects like rectangles or ovals
- pictures
- all can be hyperlinks.
4. To delete an embedded object, first
- double-click the object
- select the object by clicking it
- press the SHIFT+DELETE key
- select it and then press the DELETE key
5. When you want to insert a blank embedded excel object in a word document you can
- click the object command on the insert menu
- click the office links button on the standard toolbar
- click the create worksheet button on the formatting toolbar
- click the import excel command on the file menu
6. 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 the 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
- 1 & 3
7. When you link data maintained in an excel workbook to a word document
- the word-document cannot be edited
- the word document contains a reference to the original source application
- the word document must contain a hyperlink
- the word document contains a copy of the actual data
8. To edit data in an embedded excel worksheet object in a word document
- use the excel menu bar and toolbars inside the word application
- edit the hyperlink
- edit the data in a excel source application
- use the word menu bar and toolbars
9. When you insert an excel file into a word document, the data are
- hyperlinked
- placed in a word table
- linked
- embedded
10. 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