Creating a Simple Workbook
To create a simple workbook, you need to start with
a blank workbook.
Within the Excel window, close and do not
save the Workbook1
document.
Choose New from the File menu.
A new workbook should appear labeled
Workbook2.
Resize and position Workbook2 next to
the tutorial.
In this part of the tutorial you will be creating
a check register.
Starting in cell A1, build the following table:
To move through your worksheet, you can use the
arrow keys.
- The down arrow moves the active
cell down to the next row.
- The up arrow moves the active cell up to
the previous row.
- The right arrow moves the active cell right
to the adjacent column.
- The left arrow moves the active cell left to
the adjacent column.
- The return key moves the active cell to the
next row.
Remember to click on the Enter button or
press the Return key to enter each check number.
Select cell B1 and type in the text:Data.
Starting in cell C1, build the following table:
Select cell D1, and type the following text:
Payment Amount.
Observe that the text is too large for the cell.
You can change the width of the cell and as a result
the whole column to fit the text.
Changing Column Widths
Position the pointer between the column headings
for column D and column E.
The pointer should change shape to show a double
arrow as you position the pointer between the
two column headings.
When the pointer changes shape, you can change the
width of the column by dragging to the right or
left.
Press the mouse button and drag to the right until
the width of column D will fix the text.
Starting in cell D3, build the following table:
Starting in cell E1, build the following table:
Make sure you change the column width of column E.
Starting in cell F1, build the following table:
It is now time to save your worksheet.
Choose Save from the File
menu or click on the Save button and
call your worksheet "checks".
Before you add more to your "checks" worksheet,
you will need to learn how to write formulas
using arithmetic operators and functions.