Using Create Names

Create names in -P ltop/owl Left column r ] Bottom row Right column 

---

Use Create Names to assign the name to the cell or range in the range of selected sheets. This procedure will assign a global name in the workbook but will "overwrite" this global name with a local name in all of the selected sheets except the active sheet... 

First, use Create Names to assign the names Name, YOG, Major and Grade to the values in columns A, B, C and D, respectively. 

Let s create the formula in a stepwise fashion. To simplify the formulas, we ll use Define Name to create named formulas (see "Using Create Names" in Chapter 3). These formulas will be located in the Define Name dialog box, not in worksheet cells. 

To average or plot a structural quantity, the structural quantity must first be selected and named by the normal process for creating named selections (select the atoms and then use the menu item Select/Name Selection to give the selected atoms a name). Erom then on the Molecular Dynamics Averages dialog box will show these named selections as possible candidates to be averaged or plotted in addition to energetic quantities described above. 

The position on the periodic chart under lead would be filled by an element of atomic number 114. No such element is yet known, but scientists theorize that this would be a very stable element if it could be found or created, and it might have some very important uses. This much-sought element is referred to as i eka-lead, using the naming system Mendeleyev used for undiscovered elements in the original periodic chart. 

Alphabetical order for citation of detachable prefixes. Prefixes are used to name substituents, as discussed above. Such prefixes are called detachable prefixes. There is a further class of prefix described as non-detachable. An example is cyclo-, as in cyclohexyl, which is different in stoichiometry from the unmodified hexyl. Non-detachable prefixes are used to modify permanently the name of a parent hydride and thus to create a new parent hydride (see also section 4.5.3.4, p. 78). 

This name, used throughout this article, is justified mainly by its similarity to calixarenes which indicates the cup-like shape (calix) and the aromatic units (arenes) of the macrocycle. In the line with newly created names such as calixpyrroles, calixfuranes, calixindoles, etc. it would be reasonable to distinguish between calixphenols (I) and calixresorcinols (II) or calixpyrogallols etc. and to use calixarenes as the general name for the whole class of [l ]-metacyclophanes (or -cyclophanes). 

The Name submenu of the Insert menu contains several commands for working with names Define..., Paste..., Create..., Apply. and Label. You will probably find Define... and Create... most useful. Use Define... to assign a single name to a cell or range use Create... to create names for several cells or ranges, based on row and/or column titles. 

You ll find Create Names very useful if you have worksheets with constants or other values arranged in a table format, as in Figure 3-3. This command allows... 

To assign names to cells, select the cells to be named and the adjacent cells containing the names. Choose Name from the Insert menu and choose Create... from the submenu. Excel displays the Create Names box in Figure 3-4 the Left Column check box is checked, indicating that Excel proposes to use text in the cells in the left column for names. Press the OK button. The names will be assigned to the appropriate cells. 

If the data table is a two-dimensional one, as in Figure 3-7, cells are referenced both by row and by column. Excel proposes the row and column titles as names, as shown in the Create Names dialog box of Figure 3-8. Excel will apply the name max to the range F5 I5, the name band1 to the range F5 F7, etc. The intersection operator (the space character) can then be used to identify the named variables. For example, bands A 0 refers to cell H6. 

You can also define a name by using the Name box (the cell reference area in the formula bar). Simply select the cell or range on the sheet (the range will be displayed in the Name box), click the cursor in the Name box (the typing area will be highlighted), type the name, then press ENTER. (Excel does not propose a name based on a text label above or to the left of the selected range, as it does when you use Define Name or Create Names you have to type in the name yourself.)... 

Use Apply Names (Figure 3-10) if you have created a spreadsheet with formulas using cell references and now want to replace the cell references with names. First, use Define Name or Create Names to assign names to the references. Then choose Apply Names. The names that you have assigned will be shown in the list box. The Ignore Relative/Absolute box should usually be checked. Select a name from the list and press OK. All cells containing the reference will be replaced by the name. 

The Create Names dialog box lists all names that have been assigned in the workbook, even if they are no longer used or valid. If you have removed an unwanted name by deleting the cell, row or column in which it was located, the reference to that name in the Refers To box will be REF . Use the Delete button to delete unwanted or invalid names from the list. 

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. 

In an Excel worksheet, you have to use Define Name or Create Name to assign a name to a variable, but variable names in VBA are automatically assigned as you type the VBA code in a module. There are just a few rules for naming variables or arguments ... 

The constants table from the spreadsheet is shown in Figure 22-2. The names applied to the cell references are shown in column F of the data table Create Names was used to assign names to the references. 

The spreadsheet header table is shown in Figure 22-8. Create Names was used to assign the names in cells D3 D9 to cells C3 C9. Figure 22-9 shows a small portion of the data (entered in columns A and C) and the corrected volume and pH values. Vcorr is obtained by multiplying the nominal volume by the buret calibration factor, and pHcorr by adding the correction factor C to the measured pH. Columns of intermediate calculations are illustrated in Figure 22-10. 

Unfortunately the fact that the same label, electronegativity, is used for both scales creates ample opportunity for confusion and misunderstanding. Since the Pauling scale has the advantage of seniority and long-established usage, a solution may be to find another term for the absolute scale. One alternative is to use the name electronic chemical potential , //. 

---