The Label... Command

The Label... command was introduced in Excel 97. It also allows you to use names (except that they re called labels) in formulas. It is intended primarily to label rows and column headings of tables. The Label... command doesn t provide any features that are not available by using Define Name or Create Name, and in fact is much less versatile than using names. 

To use the Label... command, you select the range that contains the text labels, not the cells containing values, then choose Label... from the submenu. Excel 

To Assign the Same Worksheet Level Name to the Same Cell or Range in Several Sheets 

Group the worksheets (select the first sheet in the range, then hold down the SHIFT key and select the last sheet in the range), 

Select the cell that you want to contain the name, and type the name. The text will be entered in that cell in all of the grouped sheets. 

---

Even with an edited model, it is still easy for viewers to lose their bearings. Label commands attach labels to specified atoms, signifying element, residue number, or name. Labels like the one for PHE-58 in Plate 16 float with the atom during subsequent viewing, making it easy to find landmarks in the model. 

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. 

Points in a graph can be labelled using the text command. The basic syntax is text (A, B, name), where the A and B are arrays with the same number of elements, and it is recommended that name is an array of names or characters likewise with the... 

For example, the 5Hu command button on the keypad leads to the display. Figure 1.26, of the 5 copy of five polynomial functions, which, on the unit sphere, are mutually orthonormal to one another and to the 20 other polynomial functions of this irreducible symmetry forming the F , 2", and 4 sets of functions also of this symmetry, displayed when the other buttons on the keypad labelled with this symmetry are selected by a mouse click. The third function of 5hu irreducible symmetry in Figure 1.26 has leading polynomial terms... 

In contrast to a ID experiment, at the beginning of a 2D experiment a serial file containing a fixed number of blank FID data files is generated in persistent memory. The two dimensional matrix consists of tdl files, with a size of TD with each file corresponding to one time increment in the 2D matrix. A pointer is used to instruct the computer to transfer the accumulated data for each time increment from temporary memory to the correct persistent file. The pointer is then incremented for the next element. This whole procedure is executed by the pointer command if 0. The zd command occurs after the if 0 command and deletes the buffer contents. The 2D loop is closed by the command lo to label. In this instance label is a number or a string that is entered in the first position of the line where the next time increment in the 2D matrix will be started. 

You can label spectral features using the Add Annotation command. After activating the command, a click on a point of the spectrum will insert an arrow at the position of the cursor. The wavenumber of this data point will be inserted by default. Right-click on the label opens a further pop-up menu. If you click Properties, the dialog box Annotation properties appears (see Fig. 3.1 Id) where you can edit the label, e.g. add a text instead of the wave-... 

In cells B4..D6, introduce appropriate labels (luunely, desired tenqierature °C, MFI input in g per 10 min, and ASTM condition nuihber). In cells B7.32S as well as C7..C2S, introduce values that rqnesent usa-iiqmt data. This is done by putting a value sudi as 1 in cell C7 and then using the Oqiy command QC) to diq>licate this into the remaining cells of the column by spedfying the required range. 

The atoms on which the MODSMI transformations are to be applied are identified by a GENIE search that recognises atoms or bonds from their substructural environment. They are highlighted for ALADDIN processing with the GCL command PRINT /BOLDID/ . Because the hit atoms from an ALADDIN geometric test are labelled with the geometric object to which they correspond, MODSMI transformations can be applied to all atoms that are in a particular substructural environment or to only such atoms with a particular... 

The graph title and x- and y-labels can be assigned using the following commands ... 

Let us say that we would like to magnify the x-label to be a font size of 18, red color, and boldface. The following command should do the job ... 

The actuator shifts applied to the first four drive cycles labeled "A", "B", "C" and "D" decreased the EGR flow rate and increased the fresh air flow rate. The resulting effects on the in-cylinder oxygen concentration are shown in Figure 9. The ideal case tested previously is labeled as case "E". For the remaining four tests labeled "F", "G", "H" and "I," the shifts applied to the actuator commands caused a relative increase in the EGR flow rate. Figure 10 depicts the in-cylinder oxygen concentrations resulting from these shifts. The types of uniform bias errors simulated in these tests are not meant to represent typical air path errors rather, they were selected to help identify the robustness of each controller. 

The NOD command also determines generic nodes and groups. The word generic means that atoms and groups are awarded different values (atoms or groups). During the first step the atom is labelled Gk, in a second step the atom is evaluated by the command VARIABLE (VAR) (Fig. 109). 

Wines may be imported for reasons at either of two extremes because they are relatively inexpensive, or because they are in high demand, and thus command a higher price. Those exported from the United States tend to be the former, and those imported, the latter, based on the data shown in Table 5. There is some market, even in countries that are overproducing wine, for wines with exotic labels. This tendency illustrates another way in which wines differ from other products. Information on and cuisine from foreign countries associated with their wines serve as the vehicles for a form of a cultural exchange, besides the stricdy commercial one. 

---