Sunday, February 22, 2015

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. 

No comments:

Post a Comment