Zones and reading from zone to zone.

1.  Open Excel.  In Excel 2013 hit the Escape or Enter key one time to open a blank spread sheet.
2.  In cell a1 type “Snickers.”
3.  Tap enter.
4.  In cell a2 type “Payday.”
5.  Tap enter.
6.  In cell a3 type “Zero.”
7.  Tap enter two times to go to cell a5.
8.  Type “Lay's”
9.  Tap enter.
10.  Type “Frito's” in cell a6.
11.  Tap enter.
12.  Type “Jay's” in cell a7.
13.  Tap enter.
14.  Go to cell c1.
15.  Type Pepsi.
16.  Tap enter.
17.  Type Coke in cell c2.
18.  Tap enter.
19.  Type Sprite in cell c3.
20.  Tap enter two times to go to cell c5.
21.  Type “Taffy.”
22.  Tap enter.
23.  Type “Gum” in cell c6.
24.  Tap enter.
25.  Type “Breath Mints” in cell c7.
26.  Go to cell a1.
27.  Press and hold down the control key and tap the down arrow key.  You will be taken to cell a3 where the word “Zero.” is located.
28.  Release these keys.
29.  Press and hold down the control key and tap the down arrow key.  You will be taken to the top of the next zone down, which is cell a5, and contains the word “Zero.
30.  Release these keys.
31.  Press and hold down the control key and tap the down arrow key.  You will be taken to the bottom of this zone, and will be in cell a7 which contains the word “Jay's.”
32.  Release these keys.
33.  Press and hold down the control key and tap the down arrow key.  You will be surprised to hear that you are in cell a10482576.  Do not be frightened.  Press and hold down the control key and tap the up arrow key and you will be back in cell a7 where the word “Jay's” is located.
34.  Go to cell a1.
35.  Press control right arrow to go to cell c1, where the word “Pepsi” is located.
36.  Release both keys.
37.  Press control and tap down arrow to go to cell c3, where the word “Sprite” is located.
38.  Release both keys.
39.  Press control down arrow to go to the top of the next zone, cell c5, where the word “Taffy” is located.
40.  Release both keys.
41.  Press control down arrow to go to the bottom of this zone, cell c7, where the words “Breath Mints” are located.
42.  Go to cell a1.
43.  Save this file as Excel Lesson 11.
44.  Close Excel.
 
Assignment:  Open Excel.  Put your name in cell a1, the date in cell a2, and the time in cell a3.  Starting in cell a5, make a zone of three items, going down.  Then make a second zone of three items starting in cell a9.  Make a third zone of three items starting in cell c5.  Make a fourth zone of three times starting in cell c9.  Practice using the control down and control right arrow to move from zone to zone.  Save the file as Excel Assignment 11.  Print two copies.  Give one copy to the teacher, and keep one copy for yourself.  Close Excel.

BACK