Office 2010 Simplified by Kate Shoup

Author:Kate Shoup
Language: eng
Format: epub
Publisher: Wiley
Published: 2011-01-14T16:00:00+00:00

The Function Arguments dialog box appears.

Select the cells for each argument required by the function.

If you select a cell or range of cells directly in the worksheet, Excel automatically adds the references to the argument.

You can also type a range or cell address (or range or cell name) into the various text boxes.

• The dialog box displays additional information about the function here.

When you finish constructing the arguments, click OK.

• Excel displays the function results in the cell.

• The function appears in the Formula bar.

Simplify It

Can I edit a function?

Yes. To edit a function, click the cell containing the function that you want to edit, click the Formulas tab, and click the Insert Function button. Excel displays the function’s Function Arguments dialog box, where you can change the cell references or values as needed.

How can I find help with a particular function?

Click the Help on this function link in either the Insert Function or Function Arguments dialog box to access Excel’s help files to find out more about the function. The function help includes an example of the function being used and tips about how to use the function.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.