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:

HW #3

1. Put the text Josh Horatio Waxman into cell A1. Use the MID function to extract the first letters of the first name, middle name and last name. Put them together again to form J. H. W.

2. In column A, put the letters A through Z, a through z, and the numbers 0 through 9. In column B, use the CODE function to find the corresponding ASCII code. In column C, use the CHAR function to covert the ASCII codes in column B back into symbols.

If You Need Tutoring For This Class

It seems that the Computer Science Department offers free tutoring. Stop by the CS Departmental office and ask them about it, in terms of what the hours are.

Video Review of Homework #1

Here is a link to homework #1, which is a gradebook. The video below shows a walk-through of this homework:

HW #2

Note: A partial solution to the previous assignment, which we worked on in the lab, is now up on Blackboard, within "Course Documents."

1. Put values in cell A1 within Sheet1 and Sheet2. In cell A1 on Sheet3, find the sum of the A1 cells of Sheets 1 and 2.

2. Type in the following formulas in one Excel referencing convention and change to the other convention. Type them in while in cel A1.

R4c[-2]
c32 (while in z9 and in A1)
C$92
R5C5