1. Write steps to Protect a Worksheet
2. Write steps to remove duplicates in Ms Excel.
Answers
Answered by
6
Answer:
here's ur answer dude
Explanation:
1) 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.
1) Follow these steps:
- Select the range of cells, or ensure that the active cell is in a table.
- On the Data tab, click Remove Duplicates (in the Data Tools group).
- Does one or more of the following: ...
- 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
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
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