Back to lesson
1. How difficult is it to break Excel’s worksheet protection?
Easy, but you need to buy a program on the internet to do it.
Extremely difficult, as Excel's protection is based on 128-bit encryption.
Very easy! Step-by-step methods are freely available on the internet and can be used with very little prior knowledge.
2. Suppose you want to hide the logic of the formula contained in cell H22. But you still need to show the workbook to other users. Which method is the best?
Create another formula that reads =H22, and then hide row 22 and protect the worksheet.
Modify the protection properties for H22 to Hide Formula, and then protect the worksheet.
Change the font for H22 to the same color as the cell’s fill.
3. When it comes to security in Excel, by default all cells are ...
Locked and hidden, but unprotected.
Locked, but unprotected.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement