Microsoft Excel MCQ Question and Answer

Microsoft Excel MCQ Question and Answer
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
Show Answer
2. When integrating word and excel, word is usually the
  • server
  • client
  • destination
  • 2 & 3
Show Answer
3. Hyperlinks cannot be
  • special shapes like stars and banners
  • drawing objects like rectangles or ovals
  • pictures
  • all can be hyperlinks.
Show Answer
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
Show Answer
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
Show Answer
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
Show Answer
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
Show Answer
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
Show Answer
9. When you insert an excel file into a word document, the data are
  • hyperlinked
  • placed in a word table
  • linked
  • embedded
Show Answer
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
Show Answer
Questions and Answers for Competitive Exams Various Entrance Test