Midterm 1 Terms from Tutorials

Question 1

what is the “integer” data type?

Answer 1

-integer, whole number used for counting
-2 bytes (16 bits) each
limited to a range of -32,768 to 32,768

Question 2

what is the “long” data type?

Answer 2

-integer, whole number used for counting
-4 bytes (32 bits), ranges from -2,147,483,648 to 2,147,483,648

Question 3

which two data types are for integer numbers?

Answer 3

Integer and long

Question 4

Which two data types are for real numbers?

Answer 4

Single and Double

Question 5

What is the “single” data type?

Answer 5

-Decimal (or floating-point) number used for measuring
-4 bytes (32 bits)
-approx 7 sig fig of precision

ranges:
-3.40282310^38 to -1.40129810^-45 for negative numbers
1.40129810^-45 to 3.40282310^38 for positive numbers

Question 6

What is the “double” data type?

Answer 6

-Decimal (or floating-point) number used for measuring
-8 bytes (64 bits)
-approx 15 sig fig of precision

ranges:
-1.7976931348623110^308 to -4.9406564584124710^324 for negative numbers
4.9406564584124710^-324 to 1.7976931348623110^308 for positive numbers

Question 7

What is character (String) Data?

Answer 7

sequences of characters that can be letters, numbers, punctuation marks, and spaces, all treated as text

-Fixed Length, known upper limit of characters, up to 65,000 characters

-Variable Length, unkown number of characters, up to 2 billion characters

Question 8

What is logical (boolean) data?

Answer 8

-data that has only two values (True or False, 1 or 0)
-used in IF statements

Question 9

What is the “Variant” data type?

Answer 9

-assigned automatically by VBA when a variable’s data type is not declared
-VBA reads the data and chooses a type depending on the context
-if the variable is later used to store a different type of data, the variable type is automatically changed by VBA

Question 10

What are the downsides of the “variant” data type?

Answer 10

-Variant data uses more memory than declared variables
-When VBA encounters Variant data, it slows down to figure out what type it is
-a misspelled variable name is difficult to spot

Question 11

what is the “Byte” Data type?

Answer 11

smallest numeric data type, 0 to 255, no negative values

Question 12

what is the “Currency” Data Type?

Answer 12

monetary values from –922,337,203,477.5808 to
922,337,203,685,477.5807

Question 13

what is the “Date” Data Type?

Answer 13

stores a specially formatted numeric value that represents both the date and
time.