Swati, a HR manager of "Reach Recruitment Company" has stored the candidates bio-
data in a spreadsheet. There are 15 candidates for the post of Junior Engineer. Four
rounds of interview were conducted for the candidates. The manager wants to store the
confidential comments from each round of the interview conducted in a spreadsheet.
Explain different ways to protect her workbook. In the subject data entry
Answers
Answer:
Explanation:
First of all you have to make sure the right cells are locked and unlocked.
Then, for locking to take effect, you have to individually protect each sheet of your workbook that contains at least one locked cell.
Finally, to prevent users invalidating your spreadsheet, for instance by deleting or moving whole sheets, you need to protect the structure of the overall workbook.
Before you consider locking the cells in your worksheet, you have to ensure their design is correct.
The dialog explains that locking has no effect until the sheet is protected using the Protect Sheet option on the Review ribbon tab.
We might also need to prevent people accessing a confidential spreadsheet at all.
✨We can set a workbook open password when saving a file. Use File ribbon tab > Save As and then click on the Tools button and choose General Options:
✨✨✨✨✨✨✨✨✨✨✨✨✨✨✨✨
HOPE IT HELPS YOU.