Discuss the following:
Open the Project Data file linked below. Press the Enable Editing button, if necessary.
Project Data
Instructions are as follows:
a. Formulas and Charts: follow the instructions on the sheet
b. Functions: Find the house payment using the PMT function.
c. Goal Seek: Using Goal Seek, how many months will it take to save 5,500?
d. Sort: Sort the data on Topic and within Topic, sort on Sub Topic.
e. Filter: Filter the data on Social Statistics.
f. Pivot Tables: Make a Pivot Table for Artist, Location, and Value. Let Excel decide where these fields will go.