Lesson 14 – Collaborate With Colleagues

Workbook sharing works well for businesses where multiple users might require access to a file at the same time.

If you do want to share a workbook that contains an __________ table, convert the Excel table to a regular cell range.

The default setting is for the app to retain a __________ of all changes made in the past 30 days or any number of days you want.

What are two main ways to share a workbook with your colleagues?

Arrange how to send a workbook as an email attachment from within Excel by using Outlook.

You can create a read-only copy of a workbook for electronic distribution by saving it as a __________ or __________ Paper Specification (XPS) file.

When you add a comment to a cell, a exclamation mark appears in the upper-right corner of the cell.

When someone other than the original user edits a comment, that person’s __________ is marked with the new user’s name and is added to the original comment.

Whenever you __________ with your colleagues to produce or edit a document, you should consider tracking the changes each user makes.

What is the benefit of tracking changes?

You can use the commands in the Highlight Changes dialog box to choose which changes to track.

Most commonly you will have Excel track all changes, but you can also specify a time frame, users, or areas of the workbook to __________ which changes are highlighted.

Arrange how to turn off the change tracking.

You can use Excel to share your workbooks on the __________, on a __________, or by __________ for other users to take on business trips.

When you set a password for an Excel workbook, any users who want to __________ the protected workbook must enter the workbook’s password in a dialog box.