Module 7 Assignments

Create a spreadsheet to record the banking information below and to keep track of the account balance. You can see an example of what the spreadsheet might look like here. Arrange the information in chronological order, with the earliest date first and so on. (You can pick whatever year you like.) Use appropriate formats for the dates and the dollar amounts. Use formulas to add or subtract values from the bank balance so that you can see how it changes.
The balance in the bank account (called the Balance Forward) at the start is $1317.48. Don’t forget to ask for help at any stage if you need it.

Debit card withdrawals, cash withdrawals and cheques (cheques are numbered):

Date	Cheque	Description	Amount
4 Oct		Grocery store	$253.38
7 Oct	320	Soccer registration	$75.00
1 Oct	319	Bank mortgage	$1575.00
17 Oct		Men’s clothing store	$124.32
8 Oct	321	Internet/cablevision	$75.00
14 Oct		Withdrew cash	$100.00
11 Oct		Grocery store	$230.12

Deposits:

Date	Description	Amount
30 Sep	Pay deposit	$1353.47
15 Oct	Pay deposit	$1357.23

When you have finished, save a copy of your spreadsheet in your Comp 040 folder (if you have one). Ask your instructor/instructional assistant how they would like you to submit your results.

In this assignment, you will add some formulas to a large data set. Start by downloading the workbook at this link and saving it on your computer. When you open the workbook, you will see that it contains several columns of numbers. These numbers represent the daily maximum and minimum temperatures and the daily precipitation for the year 2018.
Use formulas to find

1. the total precipitation
2. the average daily maximum temperature
3. the average daily minimum temperature
4. the maximum temperature for the year
5. the minimum temperature for the year

Add rows above the data for these calculations, so that the results can be seen when the workbook is opened. Make sure to label the information appropriately.
If you are feeling keen, you can add another column to the data and calculate the maximum daily temperature in degrees Fahrenheit. The formula to do the conversion is F = 1.8*C + 32, where F is a Fahrenheit temperature and C is a Celsius temperature. How could you copy the formula into all the rows in the table? Ask your instructor or instructional assistant for help with this exercise.
When you have completed the spreadsheet, save it in your Comp 040 folder (if you have one). Ask your instructor/instructional assistant how they would like you to submit it.