AnswersGA-Business and TechnologyManaging Workbook Properties

Sharing and Protecting Worksheets Answers

10 verified answers4 views
1
Free Preview

Which symbol indicates that a cell contains a comment?

A
a red square in the lower left corner
B
a green triangle in the upper left corner
C
a red triangle in the upper right corner
D
a green circle in the lower right corner
2
Free Preview

2. Click Track Changes and click .

A
Accept/Reject Changes
B
Accept or Reject
C
Highlight Changes
D
Turn on Tracking
3

Where is the Share button located for quick access?

A
top left corner of the ribbon
B
top right corner of the ribbon
C
bottom left corner of a worksheet
D
bottom right corner of a worksheet
4

1. Click the tab.

A
Home
B
File
C
Review
D
View
5

How can users open a shared worksheet if they do not have Excel installed on a computer?

A
visit Microsoft’s website
B
use Office365’s home page
C
open a PDF version for editing
D
use Excel Online through the 365 portal
6

In which dialog box can a user locate the Element Protection tab?

A
Edit Cells
B
Protection
C
Format Cells
D
Search & Locate
7

To ensure that unauthorized users do not edit your Excel files, what should you use?

A
lock sheet with password
B
protect sheet with password
C
lock windows and freeze panes
D
protect sheet and fixed windows
8

What is the purpose of the Share With People option?

A
to email a protected copy of a file to others
B
to email a read-only copy of a file to others
C
to allow others to edit your file via OneDrive
D
to allow users to create a joint file on OneDrive
9

When working with a shared worksheet, how do you know it’s shared?

A
The word “Shared” is saved in the name of the file.
B
The email in which you received the file says “Shared.”
C
The word “Shared” appears after the workbook title in the title bar.
D
The word “Shared” appears at the bottom next to the worksheet tabs.
10

What happens when a workbook’s structure is protected?

A
Users are required to add content to the workbook.
B
Users must enter a password to open the workbook.
C
Users must enter a password to view hidden content.
D
Users are unable to see that Protect Worksheet is activated.

Did you find these answers helpful?

Sharing and Protecting Worksheets Answers…