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. rename tab 5 to include the word “private” 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. hide tab 5, then share the spreadsheet with the client.

Explanation:

• Option A: Renaming tab 5 does not prevent the client from accessing its private content, so this is not a valid tactic.
• Option B: Copying only the relevant tabs 1-4 to a new file ensures the private tab 5 is never shared with the client, keeping it secure.
• Option C: Making a copy, deleting tab 5, and sharing the new file removes the private content entirely before sharing, so it stays private.
• Option D: Hiding a tab does not make it truly private; clients can still unhide and access tab 5, so this is not a valid tactic.

Answer:

B. 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.