Cis Chapter 8

Front 1

Data validation

Back 1

enables you to define a set of rules that guide data entry for a cell or a specific range of cells

Front 2

Digital certificate

Back 2

A password-protected file that includes a variety of information that can be used for online identification and enables the recipient of documents containing macros to be more confident that the document is genuine

Front 3

Digital signature

Back 3

Electronic signature used to identify the identity of the sender of a message and to confirm that the macro or document created by the signer has not been altered since the digital certificate was created.

Front 4

Locked property

Back 4

In every cell in a workbook, the property that determines whether or not changes can be made to that cell once protection is activated.

Front 5

Macro

Back 5

A series of VBA commands that are stored in a workbook and can be run whenever you need to perform a specific task.

Front 6

Module

Back 6

Collection of VBA macros, or one or more sub procedures stored within a module.

Front 7

Name

Back 7

A word or string of characters associated with a cell or range of cells.

Front 8

Personal macro workbook

Back 8

A hidden workbook, named Personal.xls, which opens whenever you start Excel and makes the macro available anytime.

Front 9

Protecting

Back 9

Controls the ability users have to make changes to a worksheet, such as changing a value in a cell, deleting worksheets, or inserting new ones.

Front 10

Security level

Back 10

Excel supports three levels of security—high, medium, and low.

Front 11

Sub procedure

Back 11

Type of procedure in Visual Basic for Applications (VBA) that performs an action on your project or workbook, such as formatting a cell or displaying a chart. A sub procedure begins with the keyword “Sub” followed by the name of the sub procedure and a set of parentheses and ends with the keyword.

Front 12

Visual Basic for Applications (VBA)

Back 12

Programming language in which Excel macros are written.