Excel Practice 5

This is also an Excel practice exercise from Professor Houston. The object in this exercise is to make a spreadsheet that displays social science data. The learning points are converting the data into several charts that you then move to new sheets. The first time I tried to do this exercise, I was able to make the first chart, but then somehow I lost the sheet with the original spreadsheet on it! So I had to make it again. 

The first image is the initial spreadsheet. The following images are the charts derived from it:

Excel Practice 3

This is a practice checkbook exercise for Excel from Professor Houston. It has some funny humor thrown in about some imaginary criminal activity. 

This exercise uses two formulas. The formula in the G cell in the very first line (line 4) is simply the sum of the debit cell and the credit cell in that line. However, all the G cells below that are the sum of the new line's debit and credit cells and the previous line's G cell (the previous balance). This is common sense, of course, but it's worth articulating. 

This exercise also teaches two kinds of automatic numbers that are available with Excel. In the date column, there are a variety of date formats that you can choose from (month/day/year or year/month/day, etc.). In the numbers column, there are a variety of money formats you can choose from.