0 * In cell A2 enter the formula =A1+1>
4 / (you should see 2 in cell A2)
D ? Choose the Copy command to copy the formula down the list.
˙ T NTry entering a formula in cell A15 that will add 5 to the contents of cell E12 ,c 'You should see the value 12 in cell A15 The copy command " This is a very useful command The fill down command " To use the fill down command::` * %Practice using the fill down command: ' Absolute References 6( 0When the fill down command is used the cell used *) $for calculation changes in each row. :. 4If you want the cell to remain the same you must use / an absolute reference.@ L/ Fan absolute reference. This is done by putting $ sign in front of the F 00 +letter and the number in the cell address. 80 3letter and the number in the cell address: $A$7. (1 #Practice using absolute referencing rmula down the list.
˙
˙˙ " Put your cursor over cell A1
" Put your cursor over cell A2 ,l &Try entering a formula that will add 5& Hl BTry entering a form COLM ~Ŕ CHNK + D ¨ Â Ü ö:vD^ţF ` Hj˛ČŢô
ÂČ,t ŽČÎę *6 lĚÚđ 2 Ň Perimeter ˙˙ R ˙˙ R˙ü ˙˙ R˙ü ˙˙ R˙ü ˙˙ R˙ü ˙˙ R˙ü ˙˙ R˙ü ˙˙ R˙ü ˙˙ R˙ü g g g g g g g g g g g g g g g g g g g g : 5Notice the difference - cell A1 contains the number 1 ( #-cell A2 contains the formula =A1+1
-enter a number in cell E10 ; -highlight
-highlight
-E12 has the value 7 -enter the formula =E12+5 -highlight cell A16
˙˙
˙˙
˙˙
˙˙
˙˙
˙˙
˙˙
˙˙ The fill down command
! -enter a value in a cellÜ " -in the next cell 2" --in cell A35 enter a formula such as =3*A34+1=3*A34+1 ! -enter a value in cell A34đ @# :-highlight from cell A35 down 5 or 6 cells using the mouse
2$ ,-under the Calculate menu choose "fill down"$ ' Absolute References , -notice 2, ,-notice the contents of B26, B27 and so on. (1 #Practice using absolute referencing 3 -enter a value in cell 52 4 - 3 -enter a value in cell 52
˙˙
˙˙
˙˙
˙˙
˙˙ ecent Servers Scrapbook
SimpleSound
Stickies ŕ 0
y ŕ } ŕđ p i ¨}źŕ
Ť P 츚 @ ˙˙ ? H H 3| ŕ ` ŕ
@ ˙˙ COLM ~¸ CHNK Ô Ž ź Ę Ř ¨˛Ü ˘ ´şŔĆ ĚŇŢ ę g g g g g g g g g g g g g g g g g " Change the value in cell B23. : 4Notice how the other values in the list are updated. 4 /This is accomplished by the "fill down" command 3 -enter a value in cell 52 3 -enter a value in cell 52 .4 )-enter the formula =$A$52*B52 in cell C52 ˙ COLM ~° CHNK Ô B ź Â Î Ô Ú ŕ ř ţ
" ¸`ň g g g g g g g 3 -enter a value in cell 52 .4 )-enter the formula =$A$52*B52 in cell C52 3 -the value 4 is in cell A52 24 ,-the numbers 1 to 6 are in cells B52 to B57.4 6 -fill down to cell C57@ 27 ,Notice that each number was multiplied by 4.7 COLM }x CHNK
° Ş ˛ ¸ Ä Ę Đ ú ô î ˙ COLM }Ŕ CHNK âÜ ¤ Ş ˙ ˙˙ ˙˙ ˙ ˙ ˙˙ ˙˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙˙ ˙ ˙˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙˙ ˙ ˙ ˙ ˙˙ ˙˙˙ ˙˙ ˙˙ ˙˙ ˙˙˙ ˙˙ ˙ ˙ ˙˙˙ ˙˙˙ ˙˙ ˙˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙ ˙˙ ˙ ˙˙ ˙ ˙ ˙ ˙˙ ş Y ˙˙ " Y >DSET T ˙˙ . H ATE dat˙˙˙˙˙˙~¤ P S ~ ~g 6 ˙˙ * S g ˙˙ ¤C ˙˙ K FNTM CUTS DSUM steve HDNI STYL đ ˙˙ @ STYL~~` ~~~x~p~h~d T ˙˙˙˙ ˙˙
˙˙˙˙ ˙˙ ˙˙ ˙˙˙˙ ˙˙ ˙˙
˙˙ ˙˙
˙˙ ˙˙
˙˙ ˙˙ ˙˙ ˙˙˙˙ ˙˙ ˙˙˙˙ ˙˙ ˙˙ e ˙˙ ˙˙˙˙
˙˙ ˙˙˙˙ ˙˙ ˙˙˙˙ ˙˙ ˙˙˙˙
˙˙ ˙˙ ˙˙ ˙˙ ^
˙˙ HASH
$Ú
&
hšŃÚ j×a zŤáo }Bod ˘ ˙˙
CHAR~ Ö˙˙ ˙˙ ˙˙ ˙˙ ˙ú ˙˙ ˙ë ˙˙ " ˙ß ˙˙ ˙˙
4 ˙˙ HASH Ę ˙˙
CELL~|
˙˙ ˙ ˙˙ ˙ ˙˙ ˙˙ ˙˙ ˙˙ ˙˙ ˙˙ ˙˙ F ˙˙ HASH ˙ ^ ˙˙
GRPH~t R˙˙ ˙ ˙˙ ˙ ˙˙ " ˙˙ HASH Ć ˙˙ l
RULR~l ć˙˙ ˙ ˙˙ ˙ ˙˙ ý @ ˙˙ ( ˙˙ HASH ˙ ˙ @ý 0 LKUP
˙˙ Ä ˙˙ $ NAME Default
Default SS Header Body Footer ˙˙ D FNTM Helvetica Geneva ETBL @FNTM &^CUTS &fDSUM &nHDNI &STYL &ETBL /˙ţýüűúůřđńňóôőö÷