Advanced Spreadsheets Assignment

Advanced Spreadsheets Assignment - Student Edition Lab...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Student Edition Lab Assignment: Advanced Spreadsheets CASE: You are an administrative assistant for a local real estate developer. You use an Excel workbook to keep track of homes that are sold. Apply the skills you learned in the Lab to analyze the data stored in the workbook and respond to requests from your supervisor, Angela Pacheco, and the sales agents. TASK : 1. Open the Excel file Advanced Spreadsheets_Real Estate Sales.xls , save it as Dumont Sales.xls , and then enter your name in cell A1 in the Properties worksheet. 2. Angela wants to know how many homes have been sold in Dumont, sorted by price. Sort the Properties worksheet by Price in descending order and then by ZIP in ascending order. Use AutoFilter to filter for all homes sold in the ZIP code 07628. Save your changes. 3. Donna Randall asks you how many houses she has sold with a rating of 5. Clear the AutoFilter, and then use AutoFilter to show only homes with a House Rating of 5 sold by Agent DR16. Save the file as Randall Five Star Sales.xls
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/12/2012 for the course ISE 100 taught by Professor Clems during the Winter '11 term at Sullivan.

Page1 / 2

Advanced Spreadsheets Assignment - Student Edition Lab...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online