Exercise 10 Creating Your Own Spreadsheet

EXERCISE 10 CREATING YOUR OWN SPREADSHEET You are to create a spreadsheet that will keep track of withdrawals and deposits in your bank account. Deposits will increase your bank balance and withdrawals will decrease your bank balance. The spreadsheet must keep a running balance of the daily balance. Include the following column headings in your spreadsheet: o Date o Description o Deposit Amount o Withdrawal Amount o Daily Balance Add an appropriate spreadsheet title and column and row headings to describe the spreadsheet content. Enter the information provided under the appropriate column headings (Date, Description, etc.) Feb 27 Feb 28 Feb 28 Mar 2 Mar 4 Mar 5 Mar 6 Mar 8 Mar 8 Mar 10 Mar 10 Mar 12

Balance.............................................................................800.00 Deposited bi-weekly salary................................................650.00 Withdrew cash...................................................................100.00 Deposited a cash refund......................................................25.00 Paid rent for the month......................................................500.00 Paid monthly phone bill........................................................50.00 Used debit card for purchase of a new jacket......................40.00 Deposited my birthday money...........................................150.00 Used debit card for purchase of groceries.........................105.00 Deposited bi-weekly salary................................................650.00 Withdrew cash.....................................................................80.00 Paid monthly VISA bill.......................................................245.00

Create one formula to calculate the daily balance so that it works whether the transaction is a deposit or a withdrawal. The daily balance equals previous days balance + deposits – withdrawals. Use the formula to calculate the February 28 daily balance and copy the formula down the column. Add a variety of Excel formatting features. Save the spreadsheet file as ex10. Add a footer.