months ' sales by Luke Liberty 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 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 . Your Sales Data worksheet will look something like this . STEP 3 : Sort Data and Create Summary Report and Chart A . Before analyzing data , it is a good idea to copy the data to a new worksheet so that you have a back-up copy of the original data . Right click on the Sales Data sheet tab and select Move or Copy . Create a copy of the current spreadsheet and move it to the end . Name the sheet Sorted Data . B . In order to sort the data , you may want to convert them to a data table . Format the data table to look attractive .