Welcome Spreadsheet 1

1
Welcome!Spreadsheet 1

• Text by Jane Dickerson
• Graphics by Carl Hendrickson

2
2. Summary.

• 1. Type your name in a cell
• 2. Cntrl-End Home Keys Arrow Keys
• 3. Goto Command(Highlighting)
• 4. Double entry of data(Formula Bar)
• 5. Calculation point(Enter Key)
• 6. Column widths
• 7. Text Wrap of Cells Manual Adjustments of
  cell widths.

3
3.Start Spreadsheet in WORKS
4
4.Load File Activity 7-1
Step A-1
5
5.Put your Name in Cell C1

• Step A-2

6
6.Save As..Spreadsheet ..in your folder

• Step A-2B

7
7.Cntrl-End..Jumps to end-of-file

• Step A-3

8
8.Press Home..Moves to first column

• Step A-4

9
9. UP Arrow moves 1-cell up!

• Step A-5

10
10.Press F5 to get the GOTO Box

• Step A-6a

11
11.Type B4 in box Click OK

• Step A-6b

12
12..If you forget F5, Use Edit-Goto

• Step A-6c

13
13.Locate Cell B-4(1100)

• Step A-7a

14
14.Click-Drag to Cell D-4

• Step A-7b

Note B4D4
15
15.Press F5type B2D17

• Step A-8a-b

16
16.Result Goto (B2D17)

• B2

• A8c

D17
17
17.Goto A-12 Type ..Compact Disks
Cell Reflectedin FormulaBar Also...

• Step A-9a 10

18
18.Goto B12 .. Ans type the value 25
Note..Value of Total Expenses is
990..before Enter is Pressed.

• A11

19
19.After ENTER, The total is recalculated to 1015!

• A12

20
20.Type September in E2..What happeded to the
Word???

• A13

21
21.Can September fit into a 4-character
column??(Yes/No)

• A13-b

22
22.On the E-F border..Drag the column E to the
right until September Appears!

• A14 A15

23
23.September is 10 Charactersif the column is
only 9 characters wide..What happens to the Word?

• A15b

24
24.Locate Cell A1

• A16

25
25.Type Personal Budget for the Summer

• A17

Note text spills over into the next cell(B-1)
26
26.Note..Cell Text Over-run after leaving cell A1.

• A17B

27
27.Format / Text Alignment....is next..In Cell
A-1

• A18

28
28.Next..Check Text Wrap Box.

• A19

29
29.Note 2-Rows of text in A-1
Text Wrap in a cell..

• A19b

30
30. Choose Format/Column Width!

• A20a

31
31.Click on Best Fit!

• A20b

32
32.Result of Best-Fit!
Note..The A-Column is wide enough now to
accommodate the complete text in one cell.

• A20c

33
33.Go anywhere in column A and Find the Column
Width Handle.

• A21

34
34.If your Quick-Save Tool Bar is
invisible..Click View-Tool-Bar

• A22a

35
35.Click Quick-Save icon..Or Cntrl-S

• A22b

36
36.Final View of Spreadsheet-1

• A22c

37
37.Immediate Save Off as Spreadsheet-2..

• A23a

38
38. Summary.

• 1. Type your name in a cell
• 2. Cntrl-End Home Keys Arrow Keys
• 3. Goto Command(Highlighting)
• 4. Double entry of data(Formula Bar)
• 5. Calculation point(Enter Key)
• 6. Column widths
• 7. Text Wrap of Cells Manual Adjustments of
  cell widths.

39
The EndSpreadsheet 1

• Text by Jane Dickerson
• Graphics by Carl Hendrickson