Lump Sum/Basket Purchase

This assignment will provide you with the opportunity to practice assigning costs to multiple assets, when those assets are purchased in a combined transaction for one price. This is often called a "Lump Sum Purchase" or a "Basket Purchase."

Relevant Excel Functions

This assignment will require you to be able to use some or all of the following Excel functions. Click on the hyperlinked section number next to the relevant Excel skill to be directed to a page showing how to perform the assigned task in Excel:

• Cell References (1.5)

• SUM Function (1.14)

• Drop-Down Lists (1.10)

• Absolute Cell References (1.1)

• Basic Calculations (1.3)