Objectives
1. Create, edit, save and print an Excel Workbook
2. Enter data and apply basic formatting to a Worksheet
3. Create, modify and format charts to display information
4. Create, sort and filter an Excel Table
5. Create, modify and use formulas and functions to return information
Overview
Ms. Chavez has asked you to create a spreadsheet for three of the top Realtors for the past month. In
the spreadsheet, she would like to be able to see the total sales by city and by realtor as well as the
income to the Realtor and to Move NOW! at 4% each commission on each selling price. Sales are as
fol lows:
Murray - Sold 8 houses in the cities shown at the prices below:
٠ Denver - 1٥5,٥٥٥
٠ Brighton - 352,٥٥٥
٠ Louisville - 647,000
٠ Aurora - 529,000
٠ Lakewood - 272,000
٠ Lafayette - 785,000
٠ lone Tree - 674,000
٠ Broomfield - 426,000
Guled - Sold 4 houses at the following prices:
٠ Lousivi lle - 738,000
٠ Broomfield - 123,800
٠ Aurora - 342,000
٠ Thornton - 569,000
Capstone32019.docx
0
