Starting
with Cell A3: 100,
Description: Office Supplies
Check: $78.50
In Cell A4: 101
Description: The Phone Store
Check:
$180.98
In Cell A5: 102
Description: The
Electric Co
Check: $160.00
You can use today's date in the sample check book.
Working With a Ledger
3. Try This: Enter some sample data
Select Cell F2 and
type 500 for the Opening Balance. Since Column F was formatted for currency, Excel will add
the dollar sign and decimals.
Say you bought some office supplies, a phone, and paid the
electric
company a deposit to start the service.