AnswersGA-Business and TechnologyManaging Workbook Properties

Sharing and Protecting Worksheets Answers

13 verified answers3 views
2
Free Preview

✔ Format CellsLock Worksheet Protect Workbook Protect Cells

A
✔ Format Cells
B
Lock Worksheet
C
Protect Workbook
D
Protect Cells
3

Hidden ✔ LockedUnlockedVisible

A
Hidden
B
✔ Locked
C
Unlocked
D
Visible
149569

What steps can be used to run the Accessibility Checker?

Answers:
1 Click the tab.:File
2. Go to the group.:Info
3. Click and then Check Accessibility.:Check for Issues
149570

✔ InfoExportPrintPublish

A
✔ Info
B
Export
C
Print
D
Publish
149571

Browser View Options✔ Check for IssuesManage WorkbookProtect Workbook

A
Browser View Options
B
✔ Check for Issues
C
Manage Workbook
D
Protect Workbook
149578

What steps can be used to password-protect a worksheet?

Answers:
1. Click the tab.:Review
2. Go to the group.:Changes
3. Click . Type a password and click OK.:Protect Sheet
149579

✔ ChangesComments Insights Proofing

A
✔ Changes
B
Comments
C
Insights
D
Proofing
149580

Authorize UsersLock Worksheet✔ Protect SheetSet Password

A
Authorize Users
B
Lock Worksheet
C
✔ Protect Sheet
D
Set Password
149581

What are two options available for highlighting changes in the Highlight Changes dialog box?

A
for a specific website or by a specific user
B
by a specific user or in a specific file format
C
in a specific file format or for a specific website
D
within a specific time period or by a specific user
149582

What is the most likely reason for protecting a worksheet?

A
to track all changes made by editors to a worksheet
B
to stamp the worksheet with an individual’s information
C
to prevent email programs from sending the worksheet
D
to prevent unauthorized users from modifying the worksheet
149583

What steps can be used to unlock part of a worksheet?

Answers:
1. Select the .:range for users to modify
2. Right-click and choose .:Format Cells
4. Clear the checkbox and click OK.:Locked
149584

What steps can be used to password-protect a worksheet?

Answers:
2. Go to the group.:Changes
3. Click . Type a password and click OK.:Protect Sheet

Did you find these answers helpful?