Question

1. a data analyst creates a spreadsheet with five tabs. they want to share the data in tabs 1 - 4 with a client. tab 5 contains private information about other clients. which of the following tactics will enable them to keep tab 5 private? select all that apply. □ copy tabs 1 - 4 into a separate spreadsheet, then share the new file with the client. □ hide tab 5, then share the spreadsheet with the client. □ make a copy of the spreadsheet, delete tab 5, then share the new file with the client. □ rename tab 5 to include the word “private” then share the spreadsheet with the client.

Explanation:

• Copying tabs 1-4 to a separate spreadsheet ensures only non-private data is shared, keeping tab 5 private.
• Hiding tab 5 is not sufficient because hidden tabs can be unhidden by the client, risking exposure of private data.
• Making a copy of the full spreadsheet and deleting tab 5 removes the private data entirely before sharing, keeping it secure.
• Renaming tab 5 does not prevent the client from accessing its private content.

Answer:

A. Copy tabs 1-4 into a separate spreadsheet, then share the new file with the client.
C. Make a copy of the spreadsheet, delete tab 5, then share the new file with the client.