Microsoft Excel 2021365 - Beginner to Advanced - Locking Workbooks but Not Slicers
Interactive Video
•
Information Technology (IT), Architecture
•
University
•
Practice Problem
•
Hard
Wayground Content
FREE Resource
The video tutorial explains how to share Excel workbooks while protecting pivot tables from unwanted changes. It covers setting passwords on worksheets, unlocking specific cells to keep filter buttons active, and configuring permissions to allow users to interact with slicers and pivot tables without altering the data. The tutorial also demonstrates how to finalize protection settings and remove protection when needed.
Read more
2 questions
Show all answers
1.
OPEN ENDED QUESTION
3 mins • 1 pt
What happens to locked cells when a worksheet is protected?
Evaluate responses using AI:
OFF
2.
OPEN ENDED QUESTION
3 mins • 1 pt
What should you do if you want to remove the protection from a worksheet?
Evaluate responses using AI:
OFF
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
