Lesson#7 Variables and Data Types

Question 1

What is a variable?

Answer 1

A named storage location in your computer’s memory.

Question 2

What two fields can you specify when declaring a variable?

Answer 2

Variable Name and Type of Data

Question 3

After creating a variable how can you refer to it?

Answer 3

By using the specified variable name.

Question 4

What are the 2 ways you can declare a variable?

Answer 4

Explicitly and Implicitly

Question 5

What is the difference between Explicitly and Implicitly declared variables?

Answer 5

Explicitly declared variables are assigned a variable name prior to first use, Implicitly are not.

Question 6

What is meant by the term data type?

Answer 6

Refers to how a piece of data is stored.

Question 7

What happens if you do not declare the data type of a variable?

Answer 7

It is automatically given a Variant data type.

Question 8

What is the basic structure of a variable declaration?

Answer 8

A keyword(Dim, Private, Public or Static), variable name and the ‘As’ keyword followed by the data type.

Question 9

What are the 6 main data types you can work with?

Answer 9

Variant, String, Numeric, Date, Boolean and Object

Question 10

What does the Variant data type allow you to store?

Answer 10

Almost any kind of data apart from fixed-length strings.

Question 11

What does the String data type allow you to store?

Answer 11

Text

Question 12

What does the Numeric data type allow you to store?

Answer 12

Numbers

Question 13

What does the Date data type allow you to store?

Answer 13

Dates and Times

Question 14

What does the Boolean data type allow you to store?

Answer 14

True and False

Question 15

What does the Object data type allow you to store?

Answer 15

Object references and result in object variables.

Question 16

What 3 types of textual data can String data types contain?

Answer 16

Letters, Numbers and Special Characters

Question 17

What are the 2 types of String data type?

Answer 17

Variable-length and Fixed-length

Question 18

In a Fixed-length string how do you specify the number of characters?

Answer 18

*

Question 19

If the assigned data in a Fixed-length string is longer than the length given what happens?

Answer 19

VBA truncates the data.

Question 20

If the assigned data in a Fixed-length string is shorter than the length given what happens?

Answer 20

VBA pads the data with trailing spaces

Question 21

What are the 7 main numeric data types?

Answer 21

Byte, Integer, Long, Single, Double, Currency and Decimal.

Question 22

What is the statement for assigning data to a variable?

Answer 22

VariableName = AssignedExpression

Question 23

What is variable scope?

Answer 23

Refers to the parts of a VBA a project in which you can use a variable.

Question 24

What is the default scope of a variable?

Answer 24

The procedure in which it’s declared

Question 25

What is the default lifetime of a variable?

Answer 25

The time in which the procedure it’s declared in is running.

Question 26

What are the 3 scopes a variable can have?

Answer 26

Procedure-level (local), module level (private) and global scope.

Question 27

What 2 differences do static variables have to regular procedure-level variables?

Answer 27

Longer lifetimes and aren’t reset when the procedure ends.