click below
click below
Normal Size Small Size show me how
Spreadsheets Un 7
Unit 7 Spreadsheets vocabulary
Question | Answer |
---|---|
Comment | A text box that is attached to a specific cell in a worksheet; used for documentation or notes |
Defined name | A word or string of characters associated with a single cell or range |
Error alert message | A message that appears if a user tries to enter a value in a cell that does not meet its validation rule |
Locked property | A setting that determines whether changes can be made to a cell |
Macro security | A setting that control how macros will be used when opening a workbook |
Module | In VBA a collection of sub procedures |
Protect worksheet | To limit user access to certain parts of a workbook and the ability to make changes in the workbook to reduce data entry errors |
Trust center | A central location for all the security settings |
Validation rule | A statement that defines criteria for the data that can be stored in a cell or range |
Visual basic editor | A separate program that works with the products to edit and manage VBA code |