Bis 155 Lab 3 of 7: Alice Barr Realty Analysis

BIS 155 Lab 3 of 7: Alice Barr Realty Analysis

Purchase here

http://devrycourse.com/bis-155-lab-3-of-7-alice-barr-realty-analysis

Product Description

Lab 3 of 7: Alice Barr Realty Analysis

You are an intern with the Regional Realty Association and are

analyzing the claim made by Alice Barr Realty that "we get your price." You have

prepared a spreadsheet that shows data relating to 3 months' sales by Alice Barr

Realty. You are going to determine the percent of asking price for each home

sold and analyze the sales data to determine the true track record of the

company in selling homes for the asking price.

STEP 1: Open, Save, and Document the

Workbook (5 points)

You must open a workbook that lists home sales for 3 months.

A. Download the file chap4_cap_barr from DocSharing, Lab

Materials.

B. Open the workbook in Excel, and save it as

Lab3_Yourlastname.xlsx.

C. Insert a documentation sheet that includes title, author,

date, and purpose. Format it appropriately, including changing the Sheet Name to

Documentation. At the end of this activity, you will be asked to

provide a conclusion as to whether this realty company "really gets your

price."

STEP 2: Add Calculations and Format

Sales Data Worksheet (10 points)

A formula is used to calculate the percent of asking price, and

this formula is applied to all listed sales. You will format the list in an

attractive and useful manner.

A. Calculate the percent of asking price for each sale (selling

price divided by asking price). Enter the formula in Column F. Format Column F

as a percentage with one decimal.

B. Format Columns D and E as currency, with no decimals. Format

Columns G and H as dates so just the day and month (for example, 5-May) are

visible. You will need to use the Number Format dropdown list, select More

Number Formats, and select the Date category.

C. Widen columns to make all data and headings visible. Format

titles as appropriate. Bold and center...