Balancing A Checkbook

Open Excel by clicking on the Excel icon or by clicking start, programs, Excel.

1. Enter the following information into the spreadsheet. You will center and bold the labels later. Adjust the column width, when needed, by using Number 2 directions below.

2. Change Column width.

A. Click on the center of Column A heading. This will highlight the entire column.

B. Drag line between Column A and Column B until all the words fit.

C. Follow the instructions above to change the width of any columns that need to be adjusted.

3. Center the labels

A. Highlight cells A1 to G1.

B. On the formatting toolbar, click the Center button.

4. Bold Labels

A. Highlight Cells A1 to G1

B. On the formatting toolbar, click the Bold button

5. Change Number Format in Columns D to G.

A. Highlight the numbers in Columns D to G.

B. On the Format Menu, choose Cells, then click Number tab.

C. Under Category, choose Number.

D. Select 2 decimal places.

E. Click OK.

6. Save the spreadsheet.

A. On the File Menu, choose Save.

B. Enter the filename. (Filename: Checkbook[plus class period])

Checkbook2 (For second period)

C. Locate the Save in area at the top of the dialog box.

D. Click the drop down arrow.

E. Choose desktop.

F. Click Save.

7. Print the spreadsheet.

A. On the File Menu, choose Print.

B. Click OK.

8. Exit Microsoft Excel.

A. On the File Menu, choose Exit.

9. Click Start, Go to Programs, Click Calculator

Use calculator to balance checkbook. Write in your answer in the deposit column.