Free Professional Development

Or

Author:
Marie E. Arriaga

To understand how to create simple formulas in an Excel 2010 spreadsheet.

Keeping track of information is much simpler using Excel 2010 spreadsheets. Simple formulas that help you add, subtract, multiply and divide are easy to learn if you know the simple steps to create them.

Once you have that down, try your hand at other common formulas such as averages, maximums and minimums.

Tutorial

Using the downloaded Travel Expense Practice file above, follow the next steps to complete the worksheet equations.

1) Use an auto sum calculation to add the total hotel expense column

2) Using the auto fill handle, copy the formula from cell C15 through the entertainment column

3) Complete an auto sum formula for cell H16 being sure not to include the blank cell on H15

4) In cell C18 calculate the average meal expense

5) Calculate the maximum cost for each column covering all four trips

6) Calculate the total for airfare and transport expenses for both the 1st and 2nd quarter trips

**Compare your spreadsheet with the final to see how it matches.**

Source: Marie E. Arriaga

Source: Marie E. Arriaga