Calculate a Running Balance
A WebTask for Adult
In this task, you will complete the
following objectives (If you are new to Excel, complete Parts 1, 2, and 3 before
- Open Excel and save your new file
- Enter data in each cell, following the
- Create a balance formula and apply it to
- Extend the formula to additional cells
- Create your own account with a running
- Complete a reading challenge.
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.)
Follow the Instructions and Ask for
Help if You Need It
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.
Copy the information below in the correct cells in your
worksheet, as shown.
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
then click Formula Auditing Mode.
You can see the two views below.
Or, click anywhere outside cell C3 to see the calculated
-->> Save your
To keep the running balance, add a row for each new entry
(deposit or withdrawal).
Type amounts for more deposits (money you
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.
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.
3: Click on the arrow to complete the
reading challenge. When you finish the exercise, complete the project below.
YOUR EXCEL PROJECT:
a balance sheet for a checking or other account. Insert at least 4 deposits and 8 withdrawals in that
account. Create a running balance for each entry.
When you finish, print your work, sign it, and place it in
your portfolio. Note that if you take out more that you have in your
account, the balance will show in parenthesis and in red. In that
case, you will also owe the bank extra money for overdrawing! Not a