Question

Julie is working on a spreadsheet with data about the company's profits. They will be sharing this data with customers. She checks her e-mail and reads a memo that certain data should be kept confidential. She looks over her spreadsheet and sees that she needs to eliminate row 2 and row 3. Julie should _____.
highlight row 2 and row 3 and use the delete command
select B2 and press Delete
highlight row 2 and use the clear command
highlight row 2 and row 3 and make the background black

Answer 1

Julie should highlight row 2 and row 3 and use the delete command.

Answer 2

Answer: Highlight row 2 and 3 and use the delete command.

Anything that is confidential should not be included in a document that will be released to the customers of a company.

Select B2 and press delete, would just remove the contents of the cell B2.

Highlight row 2 and use the clear command will only remove the contents of the selected rows and leave a blank space.

Highlight row 2 and row 3 and make the background black. This will be one of the worst things you can do, as the customers may have accessibility to edit the contents and simply remove the formatting to see the data hidden in the rows.