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 |