BIS 155 Entire Course (Devry)
For more course tutorials visit
www.bis155.com
BIS 155 Week 6 Course Project Excel Project
BIS 155 Lab 1 of 7 Saddle River Marching Band
BIS 155 Lab 2 of 7 Excel's Advanced Formulas & Functions
BIS 155 Lab 3 of 7 Alice Barr Realty Analysis
BIS 155 Lab 5 of 7 Bruno's Pizza Analysis
BIS 155 Lab 6 of 7 Day Care Center
BIS 155 Lab 7 of 7 Access Database
BIS 155 Week 1 Quiz (Excel Fundamentals and Charting)
BIS 155 Week 2 Quiz (Excel s Advanced Formulas & Functions)
BIS 155 Week 3 Quiz (Data Analysis Functions)
BIS 155 Week 4 Quiz (Office Integration and Mail Merge)
BIS 155 Week 5 Quiz (Consolidating Data and What-If Analysis)
BIS 155 Week 8 Final Exam
.........................................................................
BIS 155 Lab 3 of 7: Alice Barr Realty Analysis (Devry)
For more course tutorials visit
www.bis155.com
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...