CS88 Midterm 2

Date and Time (Ch 6)

1. Write a formula which will always evaluate to tomorrow's date. Put this in A1.

   In A2, calculate the date which is 2 years, 5 months, and 5 days after the date in A1.

2. In A3, put the current time. In A4, add 5 hours, 6 minutes and 3 seconds to that time,
 using time functions.

   In A5, calculate the same, based on A3. But use arithmetic rather than
date/time functions.

Counting and summing (Ch 7, 14)

3. Make up a bunch of data (text). Using an array formula, count up how many cells
contain precisely 2 words.

(Recall that you can count words by taking the len of the cell, substituting nothing for
 space, taking the len again, and if the difference is 1, then there was one space in
the cell, and thus two words.)

4. Make up a bunch of data (numbers). Sum the numbers which are in
the range of 10 to 20.

5. Separate the numbers into a group of bins, using either FREQUENCY or a bunch of array formulas.

Deliberate circular references (Ch 16)

6. Generate a bunch of test scores. Then, using the max function, calculate the
highest ever maximum (all time high).

7. Solve the recursive equation; x = cos(x)
8.