How to Create a Budget Exercise

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...