CE En 270 - Final Exam KEY

Winter Semester, April 18-21, 2008

[Page 1]
Page 2
Page 3
Page 4
Page 5
Page 6
Page 7

1. (1 pt each) True or False:

a. T F  (8.2.3) Subs generated by recording macros are always Public by default.

b. T F  (8.2.3) MsgBox can be used as either a function or a sub.

c. T F  (8.2.3) Combo boxes are similar to option groups since they allow the user to select one item from a set of choices.

d. T F  (8.2.2) FTP stands for "File Transfer Protocol"

e. T F  (8.2.1) The numbers 073, 346, and 678 are examples of octal numbers

f. T F  (8.2.3) InputBox is similar to MsgBox but it allows the user to enter a single value.

g. T F  (8.2.3) Subs associated with change events for controls on a worksheet are always of type public by default.

h. T F  (8.2.3) The attributes associated with an object are called methods.

i. T F  (8.2.1) You should only refer to a cell in a formula using the cell name (rather than the cell address) if the reference is absolute (as opposed to relative).

j. T F  (8.2.3) When dimensioning an array using the Dim statement, the array dimensions must be declared using constants (not variables)

k. T F  (8.2.3) In an If...Then...Else statement, the Else clause is optional

l. T F  (8.2.3) The change event for a worksheet is initiated whenever the contents of ANY of the cells in the worksheet have been modified.

m. T F  (8.2.3) The default property for a range object is the "Formula" property.

n. T F  (8.2.4) The statements in a "Do ... Loop While" Style of loop will always be executed at least once.

o. T F  (8.2.3) The Mod operator returns the remainder after division of two double values.