Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Intermediate
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
Don’t know
2
Intermediate
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
Don’t know
3
Intermediate
When it comes to security in Excel, by default all cells are...
Locked and hidden, but unprotected
Locked, but unprotected
Unlocked
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement