Quiz 2 Questions

1) In Visual Basic for Applications (that programming thing we did in Microsoft Word), give me an example of an assignment statement.

2) What is an example of a relative path?

a) <img src="http://apple.com/fruit.gif" />

b) <img src="../images/fruit.gif" />

c) <img src="fruit.gif" />

d) <htlnk src=""http://apple.com" />

3) If I am in cell C5, and I want to write an absolute R1C1 reference to cell A1, what would I type?

4) Selection sort runs in O(n^2) time. What does that practically mean, if I want to bubblesort a million numbers into ascending order? Explain.

5) If the person's state is Texas, then I want Mail Merge in word to greet them using Howdy! Otherwise, I want to greet them using the form of Dear FirstName LastName, but with FirstName and LastName replaced with the actual name. What would you type to accomplish this If in Mail Merge?

1) In Visual Basic for Applications (that programming thing we did in Microsoft Word), the dot operator is used as a possessive, like apostrophe s in English. Give me an example of this dot operator in use.

2) What is an example of a selector?

a) <img src="http://apple.com/fruit.gif" />

b) The p in p {font-family:"Times New Roman";}

c) The font-family in p {font-family:"Times New Roman";}

d) The "Times New Roman" in p {font-family:"Times New Roman";}

3) If I am in cell C5, and I want to write an absolute reference to cell A1, what would I type?

4) Explain the behavior of selection sort, in brief (a sentence or two).

5) Why would it make sense to make the reference, to the table in which you are looking up some value in a VLOOKUP, an absolute reference?

1) In Visual Basic for Applications (that programming thing we did in Microsoft Word), give me an example of a declaration.

2) What is an example of hotlinking?

a) <img src="http://apple.com/fruit.gif" />

b) <img src="../images/fruit.gif" />

c) <img src="fruit.gif" />

d) <htlnk src=""http://apple.com" />

3) If I am in cell C5, and I want to write a relative R1C1 reference to cell A1, what would I type?

4) Bubblesort runs in O(n^2) time. What does that practically mean, if I want to bubblesort a million numbers into ascending order? Explain.

5) If the first name is Conrad, then the student gets 100 on his semester grade. Otherwise, it depends on the student's last name. Namely, if the student's Last Name is Schiff, then he gets a 90. Otherwise (meaning the first name is not Conrad and the last name is not Schiff), then the student gets the average of his midterm and final grade. Write an Excel formula, using the IF function, which computes this.