Create a spreadsheet for three of the top realtors

Assignment Help Management Information Sys

Reference no: EM132263572

Capstone Project

Instructions

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:

?Lousiville - 738,000

? Broomfield - 123,800

? Aurora - 342,000

? Thornton - 569,000

Reference no: EM132263572

Questions Cloud

What security technologies should be built into a system : What phase of designing an IT system should security be addressed? What security technologies should be built into a system?

What arguments can be presented in Damore defence : Case 1 question 4: What other measures could Xiamen fake to reward and recognise pilots? Case 4 question 2: What arguments can be presented in Damore's defence

Provide the same elements and metadata that the ansi edi : Choose a sample file that uses ANSI EDI structure and copy it into a Microsoft Excel spreadsheet or similar program.

Estimate the likelihood and cost of each risk : The cost and time associated with the risk, and the overall impact to the organization are some of the factors that must be considered as well.

Create a spreadsheet for three of the top realtors : Ms. Chavez has asked you to create a spreadsheet for three of the top Realtors for the past month.

Find the probability of drawing an ace and a nine : Find the probability of drawing an ace and a nine in either order. (Enter your answer as a fraction.) anyone help me with the steps?

Reposition a current brand or industry in the marketplace : reposition a current brand or industry in the marketplace. The brand and industry selected are ones which illustrate the need for repositioning

Calculate the sample variance for Y : STAT 5680 Homework - Calculate the sample variance for Y (i.e. SY2). What is the fundamental difference between parts c and d

Mean of 180 and a standard deviation : A distribution of values is normal with a mean of 180 and a standard deviation of 24. From this distribution, you are drawing samples of size 30.

User Account

All Pages