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. hide tab 5, then share the spreadsheet with the client. copy tabs 1-4 into a separate spreadsheet, then share the new file 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:

• Hiding tab 5 does not prevent access for shared spreadsheet viewers, so this tactic fails to keep tab 5 private.
• Copying only tabs 1-4 to a new file ensures the private tab 5 is excluded from the shared content, keeping it secure.
• Making a copy of the spreadsheet, deleting tab 5, then sharing removes the private tab entirely from the file sent to the client, protecting the data.
• Renaming tab 5 does not restrict access; the client can still view the tab's content, so this does not keep it private.

Answer:

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