Fill command

To keep the address of a cell fixed when you use the Fill commands, precede both its letter and number designation by a dollar sign (e.g., B 1). Thus the formula =A1+ B 1 in cell A2, when filled down, yields =A9+ B 1 in cell A10 (Figure 1-19). You will find this absolute cell addressing useful if you wish to use numerical constants in formulas. Occasionally it is useful to use mixed references. A relative reference in a formula, such as A1, becomes A2, A3, etc., as you Fill Down a formula into cells below the original formula. An absolute reference such as A 1 remains A 1 as you Fill Down. A mixed reference is a reference such as A 1 or A1 the row or the column designation, respectively, will remain constant when you Fill Down or Fill Right. 

Pick cells A5 and A6 and use the fill command with the + handle to copy the pattern into cells A7 to A15. 

Use die Edit menu and die Fill command to copy die fiinnula into cells B6 to B15. 

When creating formulas you have to be carefiil how you refer to the address of a cell, especially if you are planning to use the Fill command to copy the pattern of formulas, in the other cells. There are three ways that you can refer to a cell address in a formula absolute, relative, and mixed rrference. 

To better understand the diflFerences among the absolute, relative, and mixed reference, consider the examples shown in Figure 14.4. As the name implies, absolute reference is absolute, meaning it does not change when the Fill command is used to copy the formula into other cells. Absolute reference to a cell is made by column-letter row-number. For example, A 3 will always refer to the content of cell A3, regardless of how the formula is copied. In the example shown, cell A3 contains the value 1000, and if we were to input the formula =0.06 A 3 in cell B3, the result vrould be 60. Now if we were to use the Fill command and... 

On the other hand, if we were to make a relative reference to A3, that would chaise the formula when the Fill command is used to copy the formula into other cells. To make a relative reference to a cell, a special charaaer, such as, is not needed. You simply refer to the cell address. For example, if we were to input the formula =0.06 A3 in cell B3, the result would be 60 and if we use the Fill coimnand to copy the formula into cell B4, the A3 in the formula will automatically be substituted by A4, resulting in a value 75. Note that the formula in cell B4 now becomes =0.06 A4. The result of applying the Fill command to cells B4 through Bl 1 is shown in F re 14.4(b). 

In order to create the table for Example 14.2, using Excel we will first create the dollar amount column and the interest row, as shown in Figure 14.5. Next we will type into cell B3 the formula = A3 B 2. We can now use the Fill command to copy the formula in other cells, resultii in the table shown in Figure 14.5. Note that the dollar sign before A3 means... 

The solution to Example 14.5 is shown in Figure 14.9. The pressure readings were entered in column A. In cell B3, we type the formula =BF(A3 >= 20, OPEN , CLOSED ) and use the Fill command to copy the formula in cells B4 through BIO. Note that we made use of the relational operator >= and relative teforence in the IF function. 

The FILL command is used to assign the active buffer to a given transfer variable. The exact name of the transfer variable in parentheses must follow the command, e.g. FILL (name) indicates that the active buffer contains the name of the molecule. 

Group numbers are assigned to the added commands, and the user is prompted to fill in the required blanks. In this way, complex commands can be built up without modification to the software. 

In 1918, at the express command of Katherine Dreier, Duchamp executed his last oil painting (MD-114), which also happens to be his largest canvas (27.5 by 122.5 inches) (fig. 13). Called Turn . . . , this is a mural which was designed to complement Dreier s library, filled with numerous... 

The REVIEW command draws the chemical structure on one part of the screen, and then writes the associated information on the remainder. To obtain a full screen view of a chemical structure, the DRAW command is used. Options with the DRAW command include atom numbered structures, space-filled diagrams with or without imbedded stick diagrams, stero pairs, and a special box view where the top, side, and front view of the structure are shown at the same time (see Figure 1). The draw routine can use either... 

With 2D WIN-NMR zero filling is defined simply by setting SI for the F2 and Fl dimension in the Parameters dialog box opened with the General parameters setup command in the Process pull-down menu prior to Fourier transformation. 

Now comes the most magical property of a spreadsheet. Highlight cell C5 and the empty cells below it from C6 to C12. Then select the FILL DOWN command from the EDIT menu. This procedure copies the formula from C5 into the cells below it and evaluates the numbers in each of the selected cells. The density of water at each temperature now appears in column C in Figure 2-19d. 

The worksheet can be made easier to look at by adding lines that separate the column labels and numbers. To create a line under the labels one moves the cell pointer to cell C7, type then =. In LOTUS the backslash ( ) serves as a repeating label prefix. Whatever is typed after the backslash is repeated until it fills the cell. After pressing RETURN cell C7 now contains a row of equal signs ( = ). To continue the double line across the worksheet from cell C7 to cell 07 one can use the / Copy Command. 

---