MODULE
Mommia
Module12.zipEA 12 Instructions - Independent Challenge 4.docx
Module 4 Independent Challenge 4
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 you’d 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
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.
Table 4-4
|
suggested data layout |
|
|
|
|
|
|
Location |
|
|
|
|
|
|
Price range |
|
|
|
|
|
|
|
House 1 |
House 2 |
House 3 |
House 4 |
House 5 |
|
Asking price |
|
|
|
|
|
|
Bedrooms |
|
|
|
|
|
|
Bathrooms |
|
|
|
|
|
|
Year built |
|
|
|
|
|
|
Size (in sq. ft.) |
|
|
|
|
|
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.
Figure 4-30
2
CS_150_Excel Module 4 Assignment 1211- IC_4 - Instructions.docx
CS 150
Excel Module 4 Assignment 12 (IC 4) Instructions
1. For this assignment, you do not download a data file from Blackboard as in the previous assignments; you start the spreadsheet from scratch, i.e., you start by opening a blank Excel file.
2. Download the file EA 12 Instructions - Independent Challenge 4.docx.
· Follow the steps in the Independent Challenge 4 (IC 4) exercise
3. After finishing all steps, upload the resulting Excel file in Blackboard (under the link of this assignment) and submit it for grading by the due date. You have only 1 attempt, hence, make sure it is the right file name and correct file content you upload and submit.
