Putting it all together

Car Data

  • Download the 'Car Data' from above into Excel
  • Filter the data first for the state of California
  • Next apply a second filter for the Make of 'Toyota'
  • Sort the data by Last Name
  • Create a new worksheet titled "Sorted & Filtered' and copy and paste your sorted and filtered data into this worksheet
  • Creating a pie chart
  • Create a new worksheet titled 'Sales' in the same Excel workbook
  • Enter the following data into the new worksheet
  • Create a pie chart using the data below
  • Leave the pie chart on the 'Sales' worksheet

                               A         B
                            1  Make      Sales
                            2  Ford      4267
                            3  BMW       2512
                            4  Mazda     1164
                            5  Hyundai   3097
                    
    Calculating the future value of monthly deposits
  • Review Week 8 for directions
  • Create a third worksheet titled 'Future Value'
  • Enter the following data
  •                             A                   B
                            1   Monthly Deposite    1000
                            2   Interest Rate       5%
                            3   Current Balance     0
                            4   Number of years     10
                            
  • Using the Excel function 'Future Value' calculate the future value using the data above
  • Freezing Panes
  • On your own look up how to 'Freeze Panes' on the internet and using the 'Cars' data from above freeze the panes at row 6

Save the Excel document as 'hw14.xlsx' in the 'Excel' format (it should be default). Send hw14.xlsx as an email attachment to your instructor.

In the subject line for your email, include the assignment number, your name and the last 4 digits of your RunnerID in this form:

Homework 14, 1234, Samantha Spade

(Replace Samantha Spade with your name and 1234 with the last four digits of your student ID). The subject line must be exactly in this format (including capital letters and commas) in order for my grading script to download your assignment correctly, so please follow these instructions carefully.

Errors in your homework grade must be worked out with your instructor within one week of grades being posted. You will be asked to show the assignment in the sent email box with the attachment as proof that you submitted your work on time.

Remove your USB drive and take the drive with you when you leave. This should be the last action when you leave the lab every time. The lab computers are wiped clean every night and all data stored on them is deleted. USB drives left plugged into the computer usually find a new owner.