Across Worksheets

To use the Across Worksheets option in the Fill submenu, you must have selected multiple sheets beforehand. Select adjacent or non-adjacent sheets in the same way you select cells. To select an adjacent range of worksheets click on the tab of the first sheet, then hold down the SHIFT key and click on the tab of the last sheet in the range. To select non-adjacent sheets, hold down the CONTROL key (Windows) or the COMMAND key (Macintosh) while selecting. When you choose Across Worksheets from the submenu, the Fill Across Worksheets dialog box (Figure 1-18) will appear you can choose to fill Contents, Formats or both. 

It follows these steps (1) select the design criteria from a worksheet [Table 7-18(a)] and check off only the major criteria across the worksheet, keeping it simple but realistic (2) refer to the selection chart [Table 7-18(b)] and transfer the bold-faced numerical rating in each selected criteria column to the worksheet, for example, if toughness is one criterion, list 6,4,1, 2, 4, and 2 on the worksheet from top to bottom in the toughness column (3) add up the numbers across the worksheet... 

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. 

The worksheet on page 52 lists the correct answers to the questions. Columns are provided for you to mark whether you chose the correct (C) answer or an incorrect (I) answer to each question. Draw a line across any question you omitted, because it is not... 

When one first opens Excel a window is displayed on the screen with a number of rectangular areas called cells arranged in rows and columns. This window is called a worksheet. The rows are labeled by numbers and the columns are labeled by letters. Any cell can be specified by giving its column and its row (its address). For example, the address of the cell in the third row of the second column is B3. A list of menu headings appears across the top of the screen and a double strip of small icons called a toolbar appears under the menu headings. 

Using an Excel worksheet, simulation of the orders received at the central warehouse generates an average demand across 100 periods oi = 101.07 and the standard deviation, crc = 141.57. With this mean and standard deviation, and using the same formulas as before, the corresponding values of reorder level and order quantity at the central warehouse are as follows ... 

This problem can be formulated using Solver in Excel, as shown in Figure 16-4 [see worksheet Example 16-3(dynamic price)]. Cells B5 B7 contain the price variables, cells C5 C7 contain the resulting demand from the respective demand curves, and cells D5 D7 contain the revenue in each period. The total demand across the three periods is in cell C8 and the total revenue is in cell D8. The quantity at the beginning of the season is in cell B3. 

---