MCQs on Integration and Collaboration | Excel MCQ Questions
In today’s data-driven world, effective integration and collaboration are crucial for teams and businesses. Excel offers powerful features to link data across workbooks, import/export data, integrate with Power BI, and collaborate in real-time. Additionally, advanced workbook security measures like encryption and passwords ensure your data stays protected while collaborating.
Integration and Collaboration MCQs
Linking Data Across Workbooks
- How do you link data from one workbook to another in Excel?
a) Use the VLOOKUP function
b) Use the=[Workbook]reference
c) Use PivotTables
d) Import the data into the new workbook - When linking workbooks, how can you ensure the link updates automatically?
a) By enabling auto-refresh options
b) By copying and pasting the data
c) By saving both workbooks in the same location
d) By using static data references - Which Excel function allows you to reference data from another workbook?
a) INDEX
b) VLOOKUP
c) SUMIF
d)=[Workbook] - What happens when a linked workbook is moved or renamed?
a) The link will be automatically updated
b) The link will break and show an error
c) The data will be automatically copied
d) The data will be deleted - To link data across multiple workbooks, which Excel feature is the most efficient?
a) Power Query
b) VLOOKUP
c) PivotTables
d) Conditional Formatting
Importing and Exporting Data (CSV, JSON, SQL)
- Which of the following file formats can you import directly into Excel?
a) PDF
b) JSON
c) XML
d) All of the above - What is the main advantage of importing CSV files into Excel?
a) It preserves all cell formats
b) It is a simple text format that can be easily parsed
c) It allows importing large amounts of data
d) It automatically fills missing data - What does SQL stand for in the context of importing data?
a) Structured Query Language
b) Simple Query Language
c) Standard Query Layout
d) Stored Query Language - Which method would you use to export Excel data to a CSV file?
a) File → Export → Save As
b) File → Save As → CSV
c) Data → Get External Data
d) File → Import → CSV - How can you import data from a JSON file into Excel?
a) Use Power Query
b) Manually copy the JSON data into a worksheet
c) Use the “Get Data” option under the Data tab
d) Use a formula to parse JSON
Using Excel with Power BI
- How does Excel integrate with Power BI?
a) By exporting Excel data as a .pbix file
b) By directly embedding Excel charts into Power BI reports
c) By importing Power BI data into Excel
d) All of the above - What is Power Query used for in Power BI and Excel?
a) To clean and transform data
b) To create interactive dashboards
c) To generate reports
d) To import data from external databases - Which Excel feature allows data to be automatically refreshed from Power BI?
a) Power Pivot
b) Power Query
c) Power BI Publisher for Excel
d) Data Model - In Power BI, which data source can you connect to directly from Excel?
a) Text and CSV files
b) SQL databases
c) Excel workbooks
d) All of the above - How can you publish an Excel workbook to Power BI?
a) Save it as a .pbix file
b) Use the “Publish” option from the Excel File menu
c) Export it as a Power BI dataset
d) Use Power BI Desktop
Real-Time Collaboration with OneDrive
- What is the primary benefit of using OneDrive for Excel collaboration?
a) It allows real-time updates and sharing
b) It automatically fixes broken formulas
c) It stores large Excel files without compression
d) It prevents data from being shared - How do you enable real-time collaboration in Excel with OneDrive?
a) Save the workbook to OneDrive and share it
b) Use Excel in offline mode
c) Use email attachments for collaboration
d) Open the file in Excel without sharing it - When multiple users are collaborating on a workbook, what happens to the changes they make?
a) Changes are tracked and updated in real-time
b) Only the last change is saved
c) Changes are saved locally, not on OneDrive
d) Users need to manually refresh to see updates - Which Excel feature allows you to track changes made by collaborators?
a) Excel History
b) Track Changes
c) Power Query
d) Share Workbook - How can you see who is currently editing a shared Excel workbook on OneDrive?
a) View the “Collaborators” tab in the Excel ribbon
b) Check the list of active users in OneDrive settings
c) See colored flags next to cells being edited
d) Enable user permissions in the “Share” tab
Advanced Workbook Security (Encryption, Passwords)
- How can you protect an Excel workbook with a password?
a) File → Protect Workbook → Set Password
b) Data → Encrypt Workbook
c) Review → Password Protection
d) View → Workbook Protection - What does encryption do for an Excel workbook?
a) It prevents unauthorized users from opening the workbook
b) It changes the color scheme of the workbook
c) It reduces the file size
d) It automatically tracks changes in the workbook - Which method is used to apply a password to a specific worksheet in Excel?
a) File → Protect Workbook → Password
b) Review → Protect Sheet
c) Data → Set Protection
d) View → Lock Sheet - What does Excel’s “Encrypt with Password” feature do?
a) It compresses the workbook for faster opening
b) It protects the workbook from being opened without the password
c) It tracks who made changes to the workbook
d) It allows users to modify the workbook - What is the benefit of setting a password for an Excel file?
a) It allows the file to be opened only by authorized users
b) It reduces the file size
c) It helps to organize the data
d) It allows data to be printed - How can you recover a forgotten password for an Excel workbook?
a) Use password recovery software
b) Recreate the workbook from scratch
c) Use Excel’s built-in recovery tool
d) Reset the workbook’s protection using a new password - Which of the following can Excel’s encryption feature protect?
a) The entire workbook
b) Individual worksheets
c) Specific data points
d) Only cell content - In which scenario is it best to use Excel’s password protection feature?
a) When sharing sensitive financial data
b) When collaborating on non-sensitive information
c) When printing a report
d) When creating a presentation - What is the main purpose of using workbook protection in Excel?
a) To prevent accidental or unauthorized changes to the workbook
b) To increase the file size
c) To store the workbook in cloud storage
d) To create an interactive dashboard - How can you restrict users from modifying a workbook in Excel?
a) Set read-only permissions
b) Use the password protection feature
c) Use a file sharing tool
d) Change the file extension to “.read”
Answers
| Qno | Answer |
|---|---|
| 1 | b) Use the =[Workbook] reference |
| 2 | a) By enabling auto-refresh options |
| 3 | d) =[Workbook] |
| 4 | b) The link will break and show an error |
| 5 | a) Power Query |
| 6 | d) All of the above |
| 7 | b) It is a simple text format that can be easily parsed |
| 8 | a) Structured Query Language |
| 9 | b) File → Save As → CSV |
| 10 | a) Use Power Query |
| 11 | d) All of the above |
| 12 | a) To clean and transform data |
| 13 | b) Power Query |
| 14 | d) All of the above |
| 15 | b) Use the “Publish” option from the Excel File menu |
| 16 | a) It allows real-time updates and sharing |
| 17 | a) Save the workbook to OneDrive and share it |
| 18 | a) Changes are tracked and updated in real-time |
| 19 | b) Track Changes |
| 20 | c) See colored flags next to cells being edited |
| 21 | a) File → Protect Workbook → Set Password |
| 22 | a) It prevents unauthorized users from opening the workbook |
| 23 | b) Review → Protect Sheet |
| 24 | b) It protects the workbook from being opened without the password |
| 25 | a) It allows the file to be opened only by authorized users |
| 26 | a) Use password recovery software |
| 27 | a) The entire workbook |
| 28 | a) When sharing sensitive financial data |
| 29 | a) To prevent accidental or unauthorized changes to the workbook |
| 30 | a) Set read-only permissions |