AnswersGA-Business and TechnologyManaging Workbook Properties — Unit testQuestion 21
21
QuizMultiple Choice

Managing Workbook Properties — Unit test

Question 21 • GA-Business and Technology

When using the protection options in Excel 2016, what does the Protect Workbook function do?

Answer
A
It protects all the worksheets in a workbook from being reformatted or typed into.
B
It adds a password to access the worksheet.
C
It prevents worksheets from being inserted, deleted, or moved.
D
It saves a workbook in a way that will allow only a select group of people to access it.

Explanation

Protect Workbook can lock the workbook’s structure. This prevents actions such as inserting, deleting, or moving worksheets. It does not control what users can type into individual sheets or who can open the file.

AI-written and checked against the verified answer.

Previous
Next

More from this Course

Assignment
13 verified answers

Sharing and Protecting Worksheets

Assignment
10 verified answers

Sharing and Protecting Worksheets

Assignment
10 verified answers

Managing Workbook Properties