Question 19

Encrypt with a password

Microsoft Excel provides a feature to restrict access to a spreadsheet by allowing users to encrypt their files with a password. This ensures that only individuals with the correct password can open or edit the document.

A) Filters

Filters allow users to display specific data within a spreadsheet based on certain criteria, but they do not restrict access or editing capabilities. Filters are primarily used for data analysis and visualization rather than security.

B) Sharing menu

The Sharing menu in Excel facilitates collaboration by allowing users to share a document with others. While it enables sharing options, it does not inherently restrict access or editing unless paired with other security features, such as password protection.

C) Encrypt with a password

This feature directly addresses the question by providing a method for securing a spreadsheet. By encrypting a file with a password, users can control who has access to the document, making it the most effective option for restricting access and editing.

D) Vulnerability checker

The Vulnerability checker is a tool that helps identify potential security issues within a spreadsheet but does not provide a means to restrict access or editing. Its purpose is more about assessment rather than enforcing security measures.

Conclusion

Encrypting a spreadsheet with a password is the definitive method for restricting access and editing in Microsoft Excel. The other options, while useful for different purposes, do not provide the same level of security and access control as encryption does. This makes option C the correct choice for the question asked.