Submitted by: Submitted by Castillo71
Views: 10
Words: 1474
Pages: 6
Category: Other Topics
Date Submitted: 08/19/2015 06:50 AM
Creating a Budget Exercise
Follow the directions below to create a budget using Excel. Read through each
individual direction before performing it, like you are following recipe
instructions.
Remember that text is entered (typed in) or pasted wherever the black box is
positioned. Always make sure the black box is on the cell you want text to be
entered. To move the location of the black box, move the mouse pointer and
click. When using Excel, to move between different cells, you can use the arrow
keys (up, down, left, right) or you can use the Tab key to move across and the
Enter key to move down.
Remember, too, that there is usually more than one way to do something. If a
different way to do it occurs to you, go ahead and try it! If it doesn’t work, you
can always click on the Undo button on the Quick Access Toolbar. If you can’t
remember what a command does, move the mouse pointer over it and pause. A
ToolTip appears describing the button’s function.
In the instructions, the following terms will be used:
Click- a single left mouse click.
Command- a button displayed on a tab on the Ribbon.
Key – on the keyboard.
Drag Cursor – a black line with black arrows on both sides
Select Cursor – a black arrow pointing down or across
Part One: Enter Information
1. Type Personal Budget 2013 in A1. Press ‘Enter’ twice.
2. Type Income in A3, press tab once
3. Type Jan in B3. Use the copy cursor to drag across and fill in the months all
the way to Dec. Click in the Dec cell and press tab once. Type the word
Year.
4. Type Salary in A4. Press Enter once
5. Type Income Totals in A5. Press Enter twice
6. Type Expenses in A7. Press Enter Once
7. Type Mortgage/Rent in A8. Press Enter Once
8. Type Utilities in A9. Press Enter Once
9. Type Cell Phone in A10. Press Enter Once
10.Type Groceries in A11. Press Enter Once
11.Type Gas in A12. Press Enter Once
12.Type Entertainment in A13. Press Enter Once
13.Type Savings in A14. Press Enter Once
14.Type Expense Totals in A15. Press Enter...