• Formulas and built-in functions

• At least one built-in function other than sum, average, minimum, and maximum.

• At least one Three-Dimensional Reference(s)

• Two charts

• One PivotTable and One PivotChart

• A macro -either one you code directly or one which you record

• On one of the worksheets, include a command button which when clicked will execute your macro.

• Make use of either the Scenario Manager or the Solver ...Be sure to document this clearly in your User Guide!

Microsoft excel. What types of spreadsheets should I do to complete these tasks? my theme is a gym with 5 different tiers of memberships for example tier 1= 60$ for a year tier 2= 100$ for 2 years.