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

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.