Using Excel with other Office applications Excel MCQs

  1. How can you insert an Excel chart into a Word document?
    a) Copy the chart from Excel and paste it into Word
    b) Use the Insert > Object option in Word
    c) Use the Excel Data tab to export to Word
    d) Link the chart directly from Excel to Word
    Answer: a) Copy the chart from Excel and paste it into Word
  2. What does the ‘Paste Special’ feature in Excel allow you to do when copying data to another Office application?
    a) Change the format of the pasted data
    b) Paste data with or without formatting and formulas
    c) Automatically update the source data
    d) Link the data to the original Excel workbook
    Answer: b) Paste data with or without formatting and formulas
  3. How can you link data from an Excel workbook to a PowerPoint presentation?
    a) Copy and paste the data directly into PowerPoint
    b) Use the Insert > Object > Create from File option
    c) Use the Insert > Chart option
    d) Use the Excel Export option in PowerPoint
    Answer: b) Use the Insert > Object > Create from File option
  4. Which Excel feature allows you to create a live link to data in an Access database?
    a) Import Data Wizard
    b) Data Connection Wizard
    c) Get & Transform Data
    d) Power Query
    Answer: d) Power Query
  5. How can you embed an Excel worksheet into a PowerPoint slide so that it can be edited from PowerPoint?
    a) Copy and paste the worksheet as an Excel Worksheet Object
    b) Use Insert > Object > Create from File
    c) Link the worksheet using the Hyperlink feature
    d) Paste the worksheet as a static image
    Answer: a) Copy and paste the worksheet as an Excel Worksheet Object
  6. Which feature in Excel allows you to analyze data from an Outlook email?
    a) Excel Add-ins
    b) Power Query
    c) Data Import Wizard
    d) Outlook Integration
    Answer: b) Power Query
  7. How do you export Excel data to an Access database?
    a) Use the Export Wizard in Excel
    b) Copy the data and paste it into Access
    c) Use the Access Import Wizard
    d) Save the Excel file as an Access database file
    Answer: a) Use the Export Wizard in Excel
  8. What is the primary method to synchronize data between Excel and Outlook?
    a) Use VBA to automate the process
    b) Export data from Excel and import it into Outlook
    c) Use Excel Add-ins designed for Outlook integration
    d) Manually copy and paste data between Excel and Outlook
    Answer: c) Use Excel Add-ins designed for Outlook integration
  9. How can you import a Word table into an Excel worksheet?
    a) Copy the table in Word and paste it into Excel
    b) Use the Excel Import Wizard
    c) Use the Word Export feature
    d) Use the Data tab in Excel to import from Word
    Answer: a) Copy the table in Word and paste it into Excel
  10. Which Excel feature allows you to create a chart that updates automatically when the underlying data in Word is updated?
    a) Dynamic Chart
    b) Embedded Chart
    c) Linked Chart
    d) Auto-refresh Chart
    Answer: c) Linked Chart

Related Posts: