Question: create a step by step guide on Please create a small Checkbook register using Excel from your Office 365 Start with a blank workbook Increase

create a step by step guide on

Please create a small Checkbook register using Excel from your Office 365

Start with a blank workbook

Increase Row height for rows 1-6 to 30

Merge Cells ABC

In these merged cells type your name, and middle align and center

Title the rows using all lower case, and increase column width so that all titles are visible.

A2 date

B2 paid to

D2 deposit

E2 withdrawal

F2 balance

Please Top align and Align Right these titles

In F3 put a starting balance of $2,000.

In E4 put a withdrawal of $200

In D5 put in a deposit of $1000

In E6 put in a withdrawal of $700

Write an equation in the balance column that will show you the "running" balance of your checkbook.

Now copy the equation so that you have a running balance in the F column through row 8

Now make sure that all numbers show a $

Now you must increase all numbers to show 4 decimal places.

create a step by step guide on Please create a small Checkbook

Start with a blank workbook Increase Row height for rows 1-6 to 30 Merge Cells ABC In these merged cells type your name, and middle align and center Title the rows using all lower case, and increase column width so that all tittes are visible. A2 date B2 paid to D2 deposit E2 withdrawal F2 balance Please Top align and Align Right these titles In F3 put a starting balance of \$2,000. In E4 put a withdrawal of $200 In D5 put in a deposit of $1000 In E6 put in a withdrawal of $700 Write an equation in the balance column that will show you the "running" balance of your checkbook Now copy the equation so that you have a running balance in the F column through row 8 . Now make sure that all numbers show a $. Now you must increase all numbers to show 4 decimal places

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!