Thursday, October 11, 2012

Thurs 10-11: There's no place like home!

Greetings one and all,

Today you will be working, not in the "Wheels" section of your Calc spreadsheet, but in the "Home" section. You will be looking at places to live anywhere in America that you'd like to be.  (Let's just START with America...if you wanna go international on me, you can do that later on)

 However, even though its a different sheet tab, you will be doing something very similar: inserting website addresses, using those websites to look up stuff, then creating links back to what you have found.

What To Do:

A) in the Home section, go to the cell at the top right corner, and type in this address:
http://www.apartments.com/

B) directly beneath that address, put the next two addresses, one under the other:
http://www.apartmentguide.com/
http://www.forrent.com/

C) just beneath those addresses, type in a column that looks like this:
home1
home2
home3
home4
home5
home6
home7
home8

home9
home10
home11
home12
home13


D) now, do what we did the other day: use one of the websites to find not a CAR, but an APARTMENT. Or a  HOUSE...whatever you can get. Just so long as it's not "in a van down by the river"

E) find a place that you like, and copy the EXACT website address for that apartment -- its in the address bar at the top of the screen

F) go back into your spreadsheet, click on "home1" and then click on the INSERT command at the top, then goto HYPERLINK

G) in the "INSERT HYPERLINK" popup,  paste in the website address, then type in the city where "Home 1" located 

H) Click OK

I) lather-rinse-repeat this process for "home2" to "home13"

J) Make sure all those links actually work,

K) Next to each apartment, type in the RENT PER MONTH (eg, $950, $870, $1565 etc etc)

When you are done, save your file and then upload it to your shared folder on Box.com. Make sure its INSIDE the folder named after you!!!

cheers,
Mr. L

PS WE do have other things going on in this spreadsheet, so as they say in TVland "Dont Touch That Dial"!

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.