The following concepts will be introduced in this lab:
- Data Table: A data table is a range of cells that is used to quickly calculate multiple what-if versions in one operation and to show the results of all together in the worksheet.
- Macro: A macro is a series of keystrokes and commands that are stored as instructions in a unit or module of Microsoft Visual Basic, a programming language.
- Control: Controls are graphic objects that are designed to help the user interact with the worksheet.
- Macro Recorder: The Macro Reader automatically creates a macro by recording a series of actions as macro commands.
- Form: A form is a formatted worksheet with blank spaces that can be filled in online on an individual computer or on a network, or printed and completed on paper.
- IF Function: The IF Function checks to see if certain conditions are met and then takes action based on the results of the check.
- Comment: Comments are notes attached to cells that can be used to clarify the meaning of the cell contents, provide documentation, or ask a question.