Single

Integer

Date

Long

Flexibility

Reliability

Disposable

Portability

Copies

the range to another worksheet

Removes the contents but keeps formatting

Removes

formulas and formatting only

Deletes

the entire worksheet

“A

variable is something that changes up or down with business activities”

“A

variable is as an edible part of a plant, such as roots, stems, leaves,

flowers, seeds, or fruits, that is consumed as food”

“A variable

is a symbol, typically a letter like 'x' or 'y', that represents an unknown or unspecified

numerical value in an equation, expression, or formula”

“A variable is a named storage

location in your computer’s memory that’s used by a program”

Indentations

Variable name conventions

Debugging

Sub helloworld()

Cells(3, 2).Value = "Hello World"

End Sub

Sub helloworld()

Cells(2, 3).Value = "Hello World"

End Sub

Sub helloworld()

Cells(3, 2).Value = "Hello World"

End Sub

Sub helloworld()

Cells(2, 3).Value = "Hello World"

End Sub

Writing step-by-step procedures to complete a task for example a bank reconciliation

Ignoring financial data

Breaking down complex problems into smaller, manageable tasks

Avoiding problem-solving strategies

Using only automated tools

Python

VBA

Microsoft PowerPoint

Java

Disable all macros except digitally signed macros

Disable all macros without notification

Disable all macros with notification

Enable all macros

Time-consuming

Accuracy

Errors

Human factors