Excel 2007


Creating Complex Formulas
Challenge!
Use the Inventory or any Excel workbook you choose to complete this challenge.
- Create at least one complex formula that uses the addition and division operations.
- Create at least one complex formula that uses parentheses and a multiplication operation.
- Create a formula that uses an absolute reference.