Back to lesson
1. How difficult is it to break Excel’s worksheet protection?
Extremely difficult as it is based on 128bit encryption
Super easy. There are free step by step methods published on the internet to do so
Easy, you just have to buy a program on the internet to do it
2. If you wanted to hide the logic in the formula in H22, but still need to show the workbook to someone, how would you best do this?
Change the font on cell H22 to the same color as the cell’s fill
Modify the protection properties on H22 to Hide Formula, then protect the worksheet
Create another formula that reads =H22, then hide row 22 and protect the worksheet
3. By default, all Excel cells are:
Locked and hidden, but unprotected
Locked, but unprotected
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement