Microsoft Office Tutorials and References

In Depth Information

**Finding the sum of a column**

3

Select Number from the drop-down menu. Notice that Excel adds decimal places to

the numbers.

4

Place the cursor in cell H5, select Currency from the drop-down menu, type
, then
12

press Enter. Excel adds a dollar sign to the number.

5

Now, place the cursor in cell H6, select Time from the drop-down menu, type
, then
12

press Enter. Excel formats the number for time.

6

Press the Save button on the Quick Access Toolbar to save your work.

Finding the sum of a column

You can use AutoSum to quickly sum a range of numbers in a column or row.

1

Click the i rst empty cell below the Calories column, or cell E24.

2

Select Home > Editing group > AutoSum.

The AutoSum command displays the sum of

the selected cells directly after the selected cells.

A formula appears in the cell that you selected, and Excel selects the column above it.

3

Click AutoSum again. Excel displays the total of the Calories column.

Now you will decrease the number of decimal places in the total sum.

4

With the total still selected, select Home > Number group > Decrease Decimal.

The Decrease Decimal command

shows fewer decimal places.

5

Click Decrease Decimal again, so that the total shows a whole number.

6

Select File > Save and then select File > Close.

Congratulations! You have completed the lesson.