摘要 |
A method and system for assisting a user in constructing a formula in a cell of a spreadsheet operating on a computer system. A function dialog box is displayed that lists various functions that may be selected by the user to be entered into the formula. By selecting a button in the function dialog box, an insert function dialog box is displayed that lists additional functions by category. When the user selects a function, a parameter dialog box associated with the selected function is displayed. Parameters may include cell addresses as well as numerical or other data entered directly by the user. The parameter dialog box displays the formula as it is being constructed. After the parameters have been entered, a result dialog box is displayed that allows the user to select the result cell in which to place the formula. The user selects the result cell and the result dialog box is removed from the display screen, the formula is entered in the result cell, and the result of the formula is displayed in the result cell.
|