Page 109 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

To create a function using the AutoSum command:

The AutoSum command allows you to automatically insert the most common functions into your
formula, including SUM, AVERAGE, COUNT, MIN, and MAX. In the example below, we'll use
the SUM function to calculate the total cost for a list of recently ordered items.

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

2. In the Editing group on the Home tab, click the arrow next to the AutoSum command.
Next, choose the desired function from the drop-down menu. In our example, we'll
select Sum.

3. Excel will place the function in the cell and automatically select a cell range for the
argument. In our example, cells D3:D12 were selected automatically; their values will
be added to calculate the total cost. If Excel selects the wrong cell range, you can
manually enter the desired cells into the argument.

100 | P a g e