As in earlier software we learned, New works same. Choose Blank Workbook to create one. This command saves current workbook as Web Page so that it can be published on the web. You have options to choose which sheet you want to publish, Add interactivity, etc.
Whenever clicked this option, save as dialogue box appears with some modification. Such as Change Title and other option.
This option is used to search Files or File Contents. Select the array array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.
In a selected row, select the cells that don't match the formula or static value in the active cell. In a selected column, select the cells that don't match the formula or static value in the active cell. Select all cells directly or indirectly referenced by formulas in the selection.
Select cells that contain formulas that directly reference the active cell. Select cells that contain formulas that directly or indirectly reference the active cell. Turn extend mode on or off. In extend mode, EXT appears in the status line, and the arrow keys extend the selection. Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range. Extend the selection to the last nonblank cell in the same column or row as the active cell.
Extend the selection to the last used cell on the worksheet lower-right corner. Extend the selection to the last cell in the current row. This key sequence does not work if you have turned on transition navigation keys Tools menu, Options command, Transition tab. Extend the selection to the cell in the upper-left corner of the window. Extend the selection to the cell in the lower-right corner of the window.
Create names name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales! Insert a hyperlink hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet.
Display a drop-down list of the values in the current column of a range. Move the insertion point into the Formula Bar when editing in a cell is turned off. Enter a formula as an array formula array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box. When the insertion point is to the right of a function name in a formula, insert the argument names and parentheses.
Paste a defined name name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Copy the value from the cell above the active cell into the cell or the Formula Bar. Removes a border. Unhide rows. Unhide columns. Selects the array containing the active cell. Selects all cells referenced by formulas in the highlighted section. Selects cells that contain formulas that reference the active cell.
Selects all cells directly or indirectly referenced by formulas in the highlighted section. Selects cells that contain formulas that directly or indirectly reference the active cell. Fills the selected cells with the current entry. Selects the entire column.
Selects the entire worksheet. Move to cell A1. Move to the last cell on a worksheet. Move between Two or more open Excel files. Activates the previous workbook. Inserts argument names into a formula. Opens the drop-down menu for fonts. Selects all of the cells that contain comments. Opens the drop-down menu for the point size. Pastes what is stored on the clipboard. In a single column, highlights all cells above that which are selected. Highlights all text to the left of the cursor. Highlights all text to the right of the cursor.
Extends the highlighted area up to one cell. Extends the highlighted area down one cell. Extends the highlighted area left one character. Extends the highlighted area right one character. Cycles through applications.
Opens the system menu. It creates a formula to sum all of the above cells. Allows formatting on a dialog box.
Opens the Help menu. Edits the selected cell. After a name has been created, F3 will paste names. Repeats the last action. Goes to a specific cell. Move to the next pane. Spell check selected text or document. Automatically fits selected continuous probability distributions to multiple data series. Loads data from spreadsheets directly into Crystal Ball forecast charts.
Evaluates the effects of alternate decisions in a simulation model. Individually analyzes the impact of each model variable on a target outcome.
Independently addresses uncertainty and variability using a two-dimensional simulation. If available, opens the Strategic Finance Setup wizard for setting up a workbook that allows Crystal Ball to run with Strategic Finance data.
Opens the Run Preferences dialog for setting trials, sampling, and other run preferences. Opens the Assumption Charts dialog so you can display or manage assumption charts. Opens the Forecast Charts dialog so you can display or manage forecast charts.
Opens the Overlay Charts dialog so you can display existing or create new overlay charts. Opens the Trend Charts dialog so you can display existing or create new trend charts. Opens the Sensitivity Charts dialog so you can display existing or create new sensitivity charts. Opens the Scatter Charts dialog so you can display existing or create new scatter charts.
If OptQuest is available, displays OptQuest charts following an optimization.
0コメント