EXCEL EXERCISE #2: Sure Balance Checkbook



EXCEL EXERCISE #2: Sure Balance CheckbookCreate a new workbook, and save as “checkbook” in your student folder.Enter the text below in the cells indicated. Center (EXCEPT A1) and bold all titles.A1: Sure Balance CheckbookA3: Ck. #B3: DateC3: Item DescriptionD3: DebitE3: CreditF3: XG3: Balance D2-E2 (merge): TransactionsModify column widths for columns A through F. Instead of selecting the best fit option, indicate precisely the column width desired. Follow the steps below.Step 1: Click on FORMAT from the Cells group on the Home tab.Step 2: Select the COLUMN option.Step 3: Select the WIDTH option.Step 4: Type the desired width in the box labeled “Column Width".Step 5: Click on <OK>.Use the following widths for each column.Column A: 5Column B: 10Column C: 30Column D: 10Column E: 10Column F: 1Column G: 12Format the cells in columns D, E, and G to show dollars and cents for all entries. Step 1: Click on the letter at the top of the column to be formatted. (The entire column should turn dark.)Step 2: From the Home tab, choose FORMAT from the Cells section.Step 3: Select the Format Cells… option.Step 4: The NUMBER option automatically should be selected (if not, click on the tab labeled NUMBER).Step 5: Under the Category label, select the option CURRENCY.Step 6: Under the Negative Numbers label, select the format $1,234.10 which is the second choice.Step 7: Click on <OK>.Format column B to enter the date of transactions. Follow the steps above but select the DATE as the category option and M/D/YY as the format codes option.Enter formulas into G4 and G5 so that a total will be indicated in the “Balance” column. Use a formula to calculate the running total in G5 so that the balance column will automatically display the current amount of money in the checking account. Think about which transactions put money into the checking account and which take money out.Enter the information below in the rows indicated. (Do not copy the “Row” column or row.)TransactionsRowCheck Number DateItem DescriptionDebitCredit41/30/2009January Paycheck 1795.8651002/1/2009Shell Oil Co. 42.6461012/1/2009Chuck E. Cheeze 87.3472/4/2009Cash (ATM) 5081022/6/2009Dr. D. J. Houston 7591032/7/2009Rent 800102/10/2009Car Sales2500111042/11/2009Bail (Arrest) 500121052/12/2009Benny the Weasel 3200132/14/2009Rainy Day Quarter Fund 500Copy the formula from cell G5 to cells G6 through G13.You should end with a balance of $40.88Save the workbook. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download