University of Illinois, Chicago

IDS 331

Question 1
Assume that newPrice, oldPrice, and changePrice variables have been declared
appropriately. Which of the following is a valid assignment statement?
4.55 = newPrice
newPrice = newPrice + 2.5
newPrice - oldPrice =
changePrice
(newPrice - oldPrice) =
changePrice
Question 2
What is the meaning of the code displayed below?
changePrice = priceThisPeriod - pricePrevPeriod
The value of changePrice is between the value of priceThisPeriod and the value of
pricePrevPeriod
Evaluate the expression on the right hand side of the = sign and then store the result in
changePrice
Evaluate the expression on the left hand side of the = sign and then store the result in
priceThisPeriod - pricePrevPeriod
Evaluate the expression on the left hand side of the negative (-) sign and then store the
result in pricePrevPeriod
Question 3
Suppose that "January" is the name of a worksheet in the current workbook and we have
declared a variable in a macro as follow:
Dim wsThisMonth As Worksheet
Which one of the following statements is valid in that macro?
wsThisMonth = Worksheets("January")
Set wsThisMonth = ActiveWorkbook.Worksheet("January")