Chapter Demonstrable Skills
After completing the Excel Chapter 11 portion of the Excel & Data Analysis unit, students will be able to:
| Demonstrable Skill | Learning Activities & Informal Assessments |
Formal Assessments (excluding Exams) |
|---|---|---|
| Insert comments in a workbook. |
|
|
Chapter Notes
Comments
A comment is a note or annotation that can be used to ask a question or provide a suggestion to another person about content in a worksheet cell [1]. Comments help document a worksheet by providing additional information or clarification of the data, formula results, or labels that appear in a cell. Comments are indicated by a red triangle located in the upper-right corner of a cell.
Tracking changes
More advanced collaboration tools include the ability to track changes. Track Changes records certain workbook changes [1]. It tracks changes to cell contents, row and column insertions and deletions, and copied and moved data. It does not track formatting changes such as changes to column widths or row heights. Changes can only be tracked in a shared workbook. To start or stop tracking, click Track Changes in the Changes group on the Review tab.
The following options are available in the Highlight Changes dialog box:
- Who
- When
- Where
When Track Changes is enabled, a small triangle appears in the top left corner when an edit is made. Positioning the mouse pointer on a commented cell, displays a message containing the name of the person who made the change, the date and time the change was made, and the type of change made. A log of changes can be created on a history worksheet. Using the Highlight Changes dialog box, click List changes on a new sheet, and a sheet is created.
References
- M. A. Poatsy, K. Mulberry, C. Krebs, L. Hogan, A. Rutledge, and E. Cameron, Exploring Microsoft Office 2013, 1st ed., vol. 2. Upper Saddle River, NJ: Pearson Education, 2013.