Comp Apps Midterm 1 Flashcards
How to get to VBA in Excel?
In excel>File>Options>Customize Ribbon>Select DEVELOPER
What does the PROJECT window contain?
The components of your project
What does the PROPERTIES window contain?
the properties of the components of your project
What is the VBA DEVELOPMENT AREA?
This is where you will compose your program, program code, and form layout
how do you start a COMMENT in VBA
start the line with a single apostrophe ‘ in the development area
What are MACROS?
short programs that carry out usually non-mathematical operations such as formatting and filling cells with values
what are SUBS?
-subroutines
-general purpose programs, can be written with or without parameters
-take more than one input parameter
-return more than one result
-cannot be used in an expression
What are FUNCTIONS?
-short programs that can carry out math and nonmath operations
-Functions usually require parameters, can be one or more
-all functions return only one result
Computer programs are organized in modules that are:
-INDEPENDANT and SELF-CONTAINED
-must be a SPECIFIC AND WELL-DEFINED FUNCTION
-should be FOCUSED and SHORT
What are the 3 basic types of DECISION STRUCTURES?
-If/Then/Else: structures
-If/Then/Else If: cascade structures
-Select Case:
What are the three major varieties of errors?
Syntax Error, Executive (or run-time) Errors, and Logic Errors
What is a syntax error?
violation of spelling conventions, placement of parentheses, number formatting, etc
What is an Executive (or run-time) error?
occur when a statement attempts an invalid operation (ie dividing by 0)
What is a logic error?
are due to faulty program logic (garbage in garbage out)`
What are two different approaches to terminating loops?
-Decision loops are terminated if a condition is true or false
-Count controlled loops are pre-set to repeat a fixed number of times
