Independent Challenge 4: Explore This Independent Challenge requires an Internet connection. All the years of hard work and saving money have paid off, and you have decided to purchase a home. You know where youd like to live, and you decide to use the web to find out more about houses that are currently available. A worksheet would be a great place to compare the features and prices of potential homes.

a. Start Excel, then save a new, blank workbook as EX 4-My New House to the location where you save your Data Files.

b. Decide on where you would like to live, and use your favorite search engine to find information sources on homes for sale in that area. (Hint: Try using realtor.com or other realtor-sponsored sites.)

c. Determine a price range and features within the home. Find data for at least five homes that meet your location and price requirements, and enter them in the worksheet. See TABLE 4-4 for a suggested data layout.

d. Format the data so it looks attractive and professional.

e. Create any type of column chart using only the House and Asking Price data. Place it on the same worksheet as the data. Include a descriptive title.

f. Change the colors in the chart using the chart style of your choice.

g. Enter your name in a section of the header.

h. Create an additional chart: a combo chart that plots the asking price on one axis and the size of the home on the other axis. (Hint: Use the Tell me what you want to do text box above the Ribbon to get more guidance on creating a Combo Chart.)

i. Save the workbook. Preview the worksheet in Backstage view and make adjustments if necessary to fit all of the information on one page. See FIGURE 4-30 for an example of what your worksheet might look like.

j. Submit your work to your instructor as directed. k. Close the workbook, then exit Excel.