Page 116 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

The Insert Function Command

While the Function Library is a great place to browse for functions, sometimes you may prefer
to search for one instead. You can do so using the Insert Function command.

To use the Insert Function command:

In the example below, we want to find a function that will calculate the number of business days it
took to receive items after they were ordered. We'll use the dates in columns E and F to calculate
the delivery time in column G.

1. Select the cell that will contain the function. In our example, we'll select cell G3.

2. Click the Formulas tab on the Ribbon, then click the Insert Function command.

3. The Insert Function dialog box will appear.

4. Type a few keywords describing the calculation you want the function to perform, then
click Go. In our example, we'll type count days, but you can also search by selecting
a category from the drop-down list.

107 | P a g e