Page 44 - BASIC COMPUTERS ILCC CONTINUING ED

EXCEL SPREADSHEET

PRACTICE EXERCISE

1. Click on Start
2. All Programs
3. Microsoft Excel
4. Click on Blank Document
5. The Computer Selects the First Cell (Column A Row 1) (A1)

ENTER THE FOLLOWING INFORMATION IN THE APPROPRIATE CELLS

FIGURE 1

6. Cell A1 type Household Budget Household
7. Cell A2 type Income Budget

8. Cell B3 type Budget Income

9. Cell C3 type Actual Budget Actual Over/Under Notes

10. Cell D3 type Over/Under Pension 2500 2550

11. Cell E3 type Notes Salary 500 455.75
12. Cell A4 type Pension Bank Interest 150 150
13. Cell A5 type Bank Interest Share Dividend 75 65
14. Cell A6 type Share Dividend Total Income

15. Cell A7 type Total Income

16. Cells B4 through B7 Enter the Amounts shown in Figure 1

17. Cells C4 through C7 Enter the Amounts shown in Figure 1

18. Cell A8 type Expenses

19. Cell B9 type Budget FIGURE 2
20. Cell C9 type Actual
21. Cell D9 type Over/Under Expenses Budget Actual Over/Under Notes
22. Cell E9 type Notes 500 510
23. Cell A10 type Tax Tax 275 285
24. Cell A11 type Medical Medical 50 60
25. Cell A12 type House Insurance House Insurance 30 40
26. Cell A13 type Car Insurance Car Insurance 30 30
27. Cell A14 type Cable TV Cable TV 20 25
28. Cell A15 type Telephone Telephone 30 35
29. Cell A16 type Mobile Cellphone Mobile Cellphone 35 35
30. Cell A17 type Water Water 45 45
31. Cell A18 type Electricity Electricity 600 550
32. Cell A19 type Groceries Groceries 300 200
33. Cell A20 type Vacation Vacation 100 150
34. Cell A21 type Travel Travel
35. Cell A22 type Total Expenses Total Expenses
36. Cell A23 type Net Income Net Income

37. Cells B10 through B21 Enter the Amounts shown in Figure 2

38. Cells C10 through C21 Enter the Amounts shown in Figure 2