Excel Take-home Exam #2

Available here:
http://docs.google.com/Doc?id=ajbqhgmq9qdz_80cqnrngds

HW:
Write an Absolute formula.

Takehome test #1

Available here:

Homework

The Choose function in Excel uses its first argument to look up into a list formed by the rest of the arguments. Thus, Choose(1, 6, 7) will give 6, while Choose(2, 6, 7) will give 7. You can use Choose with the first argument being the month number (1 through 12) and the next twelve arguments being the number of days in the month. Remember, 30 days has September, April, June, and November. All the rest have 31. Except for February, which in a leap year has 29, but otherwise has 28. Don't worry about leap years. Pretend that this year is not a leap year.

Thus, you can write a formula which will look up a month and give you the number of days in that month.

Next, instead of specifying manually what the month number is, use the Excel MONTH function to extract the month number from some date.

Now, know that if you add the number of days in the month to a date within that month, you will arrive at the same day of the month, but in the next month.

So, put a date into A1. In A2, write a formula using the above information, which will be the same day of the month, but the next month. 1/6/08 will become 2/6/08. And 7/7/08 will become 8/7/08. This is different than just adding the number 30 to the previous date.

The Book For The Class

The book is Excel 2003 Formulas, by John Walkenbach.

Regular expressions in Microsoft Word, Excel

Here are some interesting articles on wildcards and regular expression matching. We might cover some of this. Don't worry if you can't understand this just yet. We will discuss it in class, at some point. For now, just some interesting reading.

1. Add Power to Word Searches with regular expressions
• this is somewhat powerful, but it is fairly easy to encounter limitations to its power.
2. Putting Regular Expressions to Work in Word
• A follow up article. We might try going through these examples.
3. Regular Expressions in Excel
   

HW

Go to this article/web site and do exercises 1 and 2.