My Excel Account  Calculate a Running Balance Part 4 A WebTask for Adult Learners

In this task, you will complete the following objectives (If you are new to Excel, complete Parts 1, 2, and 3 before this project):

• Open Excel and save your new file
• Enter data in each cell, following the model
• Create a balance formula and apply it to one cell
• Extend the formula to additional cells
• Create your own account with a running balance

You will evaluate yourself (compete rubrics) at the end. Click on the arrow to read the rubric (evaluation) items at the end.
(To come back here, click the BACK button on your browser.)

Open Excel and Create a blank spreadsheet or worksheet. Save your page as "yourinitialsbalance." For example, my name is Leecy Wise, so I would save my file as "lwbalance." ASK your instructor about how and where to save your file.

Activity 1

Copy the information below in the correct cells in your worksheet, as shown.

A B C \$1,000 \$625 =SUM(A2,-B2) 1000 740 =SUM(C2,A3,-B3)

After you copy the formulas in column C, you'll be able to watch them work.

-->>To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode. You can see the two views below.

Or, click anywhere outside cell C3 to see the calculated total.

Activity 2

To keep the running balance, add a row for each new entry (deposit or withdrawal).

1. Type amounts for more deposits (money you add to your account) and withdrawals (money you take from your account) into the empty rows. Type the amounts directly below the existing data (information). For instance, if you were using the example above, you would type the deposits into A4, A5, and so on. You would type the withdrawals into B4, B5, and so on.

2. Now, extend the running balance formula into the new rows. To do that, select the last cell in the balance column (C3, in this case) and then drag it to the last row with information (Row 7, in this case).

Notice that the formula extended to the last cell you wrote in. Press Control + `, and you'll see the running balance.