HW

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

Video Review of HW $ 4

Some clarification about the homework.
In this Excel homework, we record our first Excel macro. We also use CHAR and CODE to make a character uppercase, and use IF with those two built-in-functions to make the lowercase work even for characters which are already lowercase. We explain what was intended by the portion of the assignment about entering in REPT formulas.

Video Review of HW#3

Part 1:
In which we use the MID function in Excel to extract certain substrings, and then concatenate them together using the ampersand operator.


Part 2:
We play a bit with the CODE and CHAR function, and the LOWER function for good measure. All this to get a firmer sense of how characters, the building blocks of strings, work.

HW #5

Write A UDF

1. Take in X and Y, evaluate to X times Y

2. Takes in X, evaluates to yes if negative, no if >=0

3. Also, Write a formula using IF and And to evaluate to yes or no

depending on whether or not then # is between 20 and 80

4. Do the same using OR function and IF function

HW # 4:

Read Chapter 22, record the macro as specified on the second to last page of the chapter.

pg 116
1. Convert lowercase to uppercase
2. Convert uppercase and lowercase to lowercase
pg 121
3. type in REPT formulas

No Class Today

No class today -- Lincoln's birthday

Video Review of Homework #2

Here is a link to homework #2, which was practice in using Sheet references and of the correspondence between A1 and R1C1 reference style, in Excel.

This video is a walkthrough: