BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 25

STEP 1: Open, Save, and Document the Workbook
You must open a workbook that lists home sales for 3 months.
A.
Download the workbook
Week3_iLab_LibertyRealty_Student.xlsx
B.
Open the workbook in Excel, and save it according to the file
naming convention above.
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
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 (e.g., 5May) 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 the column headings.