excelformulas

Here is a brief tutorial from Microsoft on the basic use of formulas in Excel.

Use this pdf file with the Excel file posted here.


 * 1) Create a complex formula that uses the addition and subtraction operations.
 * 2) Create a complex formula that uses the multiplication and division operations.
 * 3) Create a formula that uses an absolute reference. If you are using the example, calculate the sales tax in E4:E20. Use cell C23 as your absolute reference to the price of sales tax.
 * 4) Create a formula that uses a relative reference. If you are using the example, create a formula that adds the price of each item (in column D) and the sales tax for each item (in column E), and then multiplies the result by the quantity of each item (in column F). Enter your results in the totals column (column G).