CGS 2518 CHAPTER #8 EXAM
QUESTIONS AND ANSWERS
personal macro workbook - Answer-a hidden workbook named personal.xlsb that opens
whenever you start excel.
sub procedures - Answer-in VBA, macros are called THIS. each one begins with the
word SUB and then the name of the procedure followed by a pair of parentheses.
modules - Answer-sub procedures are organized into THIS.
Defined name/range name - Answer-a word or string of characters associated with a
single cell or a range.
name box - Answer-displays the cell reference or the defined name of the selected cell
excel application - Answer-a spreadsheet written or tailored to meet specific needs. it
typically includes reports and charts, a data entry area, a custom interface, as well as
interactions and documentation.
What does a red triangle indicate? - Answer-that the cell contains a comment. point to
the cell to display the comment box.
data validation - Answer-to create a set of rules that determine what users can enter in
a specific cell or range.
input message - Answer-appears when a cell becomes active and can be used to
specify the type of data the user should enter in that cell
error alert - Answer-appears when a user tries to enter a value in the cell that doesnt
meet the validation rule.
workbook protection - Answer-limits users ability to make changes to the workbook's
structure and windows
worksheet protection - Answer-limits users ability to modify the worksheet contents,
structure, or formatting.
comment - Answer-is a text box that is attached to a specific cell in a worksheet in
which you can enter notes.
locked property - Answer-determines whether changes can be made to that cell.
macro security settings - Answer-control what excel will do about macros in a workbook
when you open that workbook. you can set the level of macro security.
QUESTIONS AND ANSWERS
personal macro workbook - Answer-a hidden workbook named personal.xlsb that opens
whenever you start excel.
sub procedures - Answer-in VBA, macros are called THIS. each one begins with the
word SUB and then the name of the procedure followed by a pair of parentheses.
modules - Answer-sub procedures are organized into THIS.
Defined name/range name - Answer-a word or string of characters associated with a
single cell or a range.
name box - Answer-displays the cell reference or the defined name of the selected cell
excel application - Answer-a spreadsheet written or tailored to meet specific needs. it
typically includes reports and charts, a data entry area, a custom interface, as well as
interactions and documentation.
What does a red triangle indicate? - Answer-that the cell contains a comment. point to
the cell to display the comment box.
data validation - Answer-to create a set of rules that determine what users can enter in
a specific cell or range.
input message - Answer-appears when a cell becomes active and can be used to
specify the type of data the user should enter in that cell
error alert - Answer-appears when a user tries to enter a value in the cell that doesnt
meet the validation rule.
workbook protection - Answer-limits users ability to make changes to the workbook's
structure and windows
worksheet protection - Answer-limits users ability to modify the worksheet contents,
structure, or formatting.
comment - Answer-is a text box that is attached to a specific cell in a worksheet in
which you can enter notes.
locked property - Answer-determines whether changes can be made to that cell.
macro security settings - Answer-control what excel will do about macros in a workbook
when you open that workbook. you can set the level of macro security.
