Insert menu, Excel

The Excel function LINEST returns the slope and intercept and their uncertainties in a table (a matrix). As an example, enter x and y values in columns A and B. Then highlight the 3-row X 2-column region E3 F5 with your mouse. This block of cells is selected to contain the output of the LINEST function. Under the insert menu, select function. In the window... 

The default Excel 2000 workbook contains three worksheets, but you can add or remove sheets. Three Excel commands permit you to add or remove sheets from a workbook. The Delete Sheet command in the Edit menu permanently removes the active sheet from the workbook. To add a worksheet to a workbook, use the Worksheet command in the Insert menu (you can also insert a chart sheet). To move or copy sheets within a workbook, or from one workbook to another, use the Move or Copy Sheet... command (Figure 1-10) in the Edit menu. 

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. 

Because Excel provides such a wide range of functions, it is sometime difficult to remember them, or to enter their arguments correctly. You can use Excel s Insert Function to paste a function in a cell, or within a formula that you re typing in the formula bar. To access Paste Function, press the button or choose Function... from the Insert menu to display the Paste Function dialog box (Figure 3-18). 

Create a new worksheet using the INSERT menu, if the default in your version of EXCEL is one. 

Cell B14 gives the number of data points with the formula = COUNT(B4 B7). Cell B15 computes the mean value of y. Cell B16 computes the sum S(q — )2 that we need for Equation 4-27. This sum is common enough that Excel has a built in function called DEVSQ that you can find in the Statistics menu of the INSERT FUNCTION menu. 

There are a number of ways of creating macros. The most straightforward is via the Visual Basic Editor, which can be accessed via the Macro option of the Tools menu. Depending on your set-up and the history of the spreadsheet, you may then enter a blank screen. If this is so, insert a Module . This contains a series of user defined procedures (organised into Subroutines and Functions) diat can be run from Excel. 

The default Excel 2000 workbook contains three worksheets. If you want a workbook with more than three sheets, you can insert additional worksheets, or choose Options... from the Tools menu and choose the General tab, change the Sheets In New Workbook default, then create a new workbook. 

In Excel 2000 for Windows, the Worksheet Menu Bar has the following pulldown menus File, Edit, View, Insert, Format, Tools, Data, Window and Help. The File, Edit, Format and Window menus are discussed in this chapter. Commands in other menus will be discussed in later chapters. 

CHAR(10) is the line feed character, CHAR(13) is the carriage return (the ll symbol you see when you choose Show SI from the View menu in Microsoft Word). Use one of these characters to insert a line break in text within a formula CHAR(10) in Excel for Windows, CHAR(13) in Excel for the Macintosh. 

In Excel 97 or a more recent version, go with the mouse pointer to the menu bar, click on Insert, and in the resulting drop-down submenu click on Chart. Or achieve the same result with the keystrokes Alt + i, Alt + h. Either method will produce a dialog box labeled Chart Wizard - Step 1 of 4 - Chart Type. 

The shorthand instruction for using Trendline in Excel 95 might read Insert O Trendline, but if you look in the pull-down menu under Insert you may not find Trendline. The problem is that the Trendline option appears only after you have activated the graph (by double-clicking on an embedded chart, or by clicking on the tab of a separate chart). Even then, it shows but cannot be used for the latter, you must first select the particular data set in the graph to which you want it to apply. Only then can you select Trendline (or, for that matter, Error Bars). 

To make a module in Excel 5 or Excel 95, move the pointer to the tab at the bottom of your spreadsheet, and right-click on it. A small menu will pop up. Click on the first item, insert, which will give you several options. Highlight or double-click on Module, and click OK. You will now see a blank sheet, with a tab carrying the name Module 1 (or, if the spreadsheet already contains modules, Module Alwhere Nis a sequence number Excel assigns automatically). 

In Excel 97 and later versions, embedding a button in a toolbar can be done quite easily, by adding two small macros that operate automatically whenever a workbook is opened or closed. The following macros, when added to the macro Interpolate ), will insert a button labeled Interpolation in the Tools menu when a workbook is opened that contains this macro, and will remove the button again upon closing that workbook. 

---