Excel - Chapter 12 (2022/2023) with Verified Solutions
Excel - Chapter 12 (2022/2023) with Verified Solutions Background An image that appears behind the worksheet data onscreen; it does not print Cell style A set of formatting options applied to worksheet cells to produce a consistent appearance for similar cells within a worksheet Comment Documents programming code, starts with an apostrophe, and appears in green in the VBA editor Keyword A special programming syntax used for a specific purpose that appears in blue in the VBA editor Locked Cell A cell that prevents users from making changes to that cell in a protected worksheet Macro A set of instructions that tells Excel which commands to execute Macro Recorder A tool that records a series of commands in the sequence performed by a user and converts the commands into programming syntax Module A VBA module is a file that stores Sub procedures and Functions. Modules can be created and viewed in the VBA Editor Object A variable that contains both data and code and represents an element of Excel Personal Macro Workbook A hidden workbook stored in the XL Start folder that contains macros and opens automatically when you start excel Procedure A named sequence of statements that execute as one unit Run Time Error A software or hardware problem that prevents a program from working correctly Sub Procedure Command lines written in the VBA Editor that have the ability to perform actions in Excel Template A special workbook file used as a model to create similarly structured workbooks Theme A collection of colors, fonts, and special effects Visual Basic for Applications (VBA) The Office application used to create, edit, execute, and debug macros using programming language Visual Basic Editor The Office application used to create, edit, execute, and debug macros using programming language.
Document information
- Uploaded on
- March 27, 2023
- Number of pages
- 3
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers