Computer Science, asked by Atharvadhamale, 5 months ago

1. Write steps to Protect a Worksheet
2. Write steps to remove duplicates in Ms Excel.

Answers

Answered by Anonymous
6

Answer:

here's ur answer dude

Explanation:

1) Protect Sheet

  1. Right click a worksheet tab.
  2. Click Protect Sheet.
  3. Enter a password.
  4. Check the actions you allow the users of your worksheet to perform.
  5. Click OK. Note: if you don't check any action, users can only view the Excel file!
  6. Confirm the password and click OK.

1) Follow these steps:

  1. Select the range of cells, or ensure that the active cell is in a table.
  2. On the Data tab, click Remove Duplicates (in the Data Tools group).
  3. Does one or more of the following: ...
  4. Click OK, and a message will appear to indicate how many duplicate values were removed, or how many unique values remain.

hope it helps

Answered by KaMaBy
3
Protect Sheet

Right click a worksheet tab.

Click Protect Sheet.

Enter a password.

Check the actions you allow the users of your worksheet to perform.

Click OK. Note: if you don't check any action, users can only view the Excel file!
Confirm the password and click OK.

2. Remove duplicate values

Select the range of cells, or ensure that the
active cell is in a table.

On the Data tab, click Remove Duplicates .
In the Remove Duplicates dialog box, unselect any columns where you don't want to remove duplicate values.

Click OK, and a message will appear to indicate how many duplicate values were removed.
Plz mark as brainliest
Similar questions