Excel Chapter 12

digital signature

A ____________ is an electronic, encrypted notation that stamps a document to authenticate the contents, confirms that a particular person authorized it, and marks the workbook as final.

signature line

A ________________ — enables a person to type or insert a visible digital signature to authenticate the workbook

General

The ______ tab displays the file name, file type, location, size, creation date, modification date, and last accessed date.

Contents

The ______ tab displays the worksheet names contained in the workbook.

Summary

The ________ tab displays properties the user can enter and change, such as title, subject, author, manager, company, category, keywords, and comments

Custom

The ________ tab enables the user to create and maintain custom properties for the current workbook, such as Department, Project, and Purpose.

Statistics

The _________ tab includes creation, modified, accessed, and printed dates

Mark as Final

The ___________ command communicates that it is a final version and makes the file read-only.

Document Panel

The _________________ enables you to enter the Author, Title, Subject, Keywords, Category, Status, and Comments properties while working on the workbook.

Help

Use the _______ feature to find 2013 features that are not supported by previous versions

Compare and Merge Workbooks command

Use the ____________________ . This combines the shared workbooks into one workbook so that you can compare the changes and decide which ones to keep.

Encrypt a workbook

You can protect a workbook by restricting its access to authorized people only. This requires a password

user name

You use this feature to identify who authored or edited this workbook.

Feedback

________ takes the form of: Error: Extremely difficult for disabled to view Warning: Difficult to understand Tip: Understandable, but can be presented or organized better

Comments

_____________ help document a worksheet by providing additional information or clarification of the data, formula results, or labels so that several months or years later you can understand what went on in the development of the workbook.

Collaboration tools

_______________ include: Share, Compare and Merge Comments Track Changes

Comment indicator

a colored triangle in the top-right corner of a cell to indicate that cell contains a comment

Comment

a notation attached to a cell to pose a question or provide commentary

Document property

an attribute that describes a file:

Read Only

can not save changes back to network drive

Compatibility Checker

detects data and features that are not compatible with previous versions of Excel

Document Inspector

detects hidden and personal data in a workbook for removal

Accessibility Checker

detects issues that could hinder a disabled person's ability to use a workbook

Network Permission

determines who has rights to open and modify files

Shared workbook

is a file that enables multiple users to make changes at the same time AND allows everyone to see the changes made.

Owner

is the person who created the workbook and designates it as shared controls user access and resolves conflicts

Collaboration

occurs when multiple people work together to achieve a common goal by using technology to edit the contents of a file

Non Shareable

only one person can work on the workbook at the same time

Excel Options dialogue box

permits you to change a variety of settings contained in the options category.

Metadata

pieces of data that describe other data