Page 45 - BASIC COMPUTERS ILCC CONTINUING ED

ENTER THE FORMULAS BELOW IN THE APPROPRIATE CELLS
39. Click in Cell B8 Click ∑ on the Home Tab, Editing Section Select SUM

This Adds (SUMS) the Cell Range B4 through B7
40. Click in Cell C8 Click ∑ on the Home Tab, Editing Section Select SUM

This Adds (SUMS) the Range (C4 through C7) FIGURE 3

41. Click in Cell D4
42. Type =
43. Click in Cell C4
44. Enter the minus sign
45. Click in Cell B4
46. Click the Enter Key

This creates a Subtraction Formula =C4-B4

47. Using the Mouse Pointer, Select the small black box in the

Lower right corner of D4 (Fill Handle)

The mouse changes to a Plus Sign  FIGURE 4

Hold down the left mouse button and

Drag Down to D8

(This copies the formula in D4 to D5, D6, D7, and D8)

(Figure 5) AND (Figure 6)
48. Click in Cell B24 Click ∑ on the Home Tab, Editing Section Select SUM

This Adds (SUMS) the Range (B12 through B23)
49. Click in Cell C24 Click ∑ on the Home Tab, Editing Section Select SUM

This Adds (SUMS) the Range (C12 through C23)

FIGURE 5 - FORMULA VIEW

Household Budget Budget Actual Over/Under Notes
Income 2500 2550 =C4-B4
500 455.75 =C5-B5
Pension 150 150 =C6-B6
Salary 75 65 =C7-B7
Bank Interest =SUM(B4:B7) =SUM(C4:C7) =C8-B8
Share Dividend
Total Income

50. Click in Cell D12 FIGURE 6 – NORMAL VIEW
51. Type =
52. Click in Cell C12 Household Budget Actual Over/Under
53. Enter the minus (-) sign Budget 2500 2550 50
54. Click in Cell B12 Income 500
55. Click the Enter Key 150 455.75 -44.25
Pension 75 150 0
This creates a Subtraction Formula =C12-B12 Salary 3225 65
Bank Interest -10
Share Dividend 3220 75 -4 25
Total Income