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 ., 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 the column headings .