BIS 155 iLab 3 : Luke Liberty Realty ( New ) For more course tutorials visit www . tutorialrank . com
E . Unlock the cells in which users will input data so that you may protect the sheet to keep users from changing other areas .
F . Create a Macro .
G . Use Insert Shapes to add a Macro button that will allow users to clear values and start over . Name the button Enter New Values .
H . Protect the worksheet , but do NOT require a password .
I . Format the worksheet so that it is easy to understand and use . The following is a sample of what your final worksheet might look like :
Save your file as an xlsm file and submit to the Dropbox . Make sure you post a comment about what you learned when submitting the file .
=========================================
BIS 155 iLab 3 : Luke Liberty Realty ( New ) For more course tutorials visit www . tutorialrank . com
You are an intern with the Regional Realty Association and are analyzing the claim made by Luke Liberty Realty that " we get your price ." You have prepared a spreadsheet that shows data relating to 3 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 .