MODULE

EX 4-2 (1).xlsx
Sheet1

Accounting Advertising Personnel Law Firm Medical Lab

Excel 37 16 5 11 38

Word 10 35 20 25 10

PowerPoint 17 15 15 7 3

Access 20 5 2 10 10

Publisher 2 15 22 15 25

CS_150_Excel Module 4 Assignment 1111 1Instructions x
CS 150

Excel Module 4 Assignment 11 Instructions

1. Download the data files for this assignment (EX 4-2.xlsx).
1. Download it by right clicking on it and then save it in your flash drive.
2. You start the assignment by opening this file and saving it with the name listed in one of the first steps.
1. Download the file EA 11 Instructions – Skills Review x.
· Follow the steps in the Skills Review exercise.

1.
After
finishing all steps, upload and submit for grading the resulting Excel file in Blackboard by clicking the link (EA 11) to this assignment. You have only 1 attempt, hence, make sure it is the right file name and correct file content you upload and submit.

EA 11 Instructions -Skills Review x
Module 4 Skills Review
1. Plan a chart.
a. Start Excel, open the Data File EX 4-2.xlsx from the location where you store your Data Files, then save it as EX 4-Software Usage Polling Results.
b. Describe the type of chart you would use to plot this data.
c. What chart type would you use to compare the number of Excel users in each type of business?
2. Create a chart.
a. In the worksheet, select the range containing all the data and headings.
b. Click the Quick Analysis tool.
c. Create a Clustered Column chart, then add the chart title Software Usage, by Business above the chart.
d. If necessary, click the Switch Row/Column button so the business type (Accounting, Advertising, etc.) appears as the x-axis.
e. Save your work.
3. Move and resize a chart.
a. Make sure the chart is still selected, and close any open panes if necessary.
b. Move the chart beneath the worksheet data.
c. Widen the chart so it extends to the right edge of column H.
d. Use the Quick Layout button in the Chart Tools Design tab to move the legend to the right of the charted data. (Hint: Use Layout 1.)
e. Resize the chart so its bottom edge is at the top of row 25.
f. Save your work.
4. Change the chart design.
a. Change the value in cell B3 to 8. Observe the change in the chart.
b. Select the chart.
c. Use the Quick Layout button in the Chart Layouts group on the Chart Tools Design tab to apply the Layout 10 layout to the chart, then undo the change.
d. Use the Change Chart Type button on the Chart Tools Design tab to change the chart to a Clustered Bar chart.
e. Change the chart to a 3-D Clustered Column chart, then change it back to a Clustered Column chart.
f. Save your work.
5. Change the chart layout.
a. Use the Chart Elements button to turn off the primary major horizontal gridlines in the chart.
b. Change the font used in the horizontal and vertical axis labels to Times New Roman.
c. Turn on the primary major gridlines for both the horizontal and vertical axes.
d. Change the chart title’s font to Times New Roman if necessary, with a font size of 20.
e. Insert Business as the primary horizontal axis title.
f. Insert Number of Users as the primary vertical axis title.
g. Change the font size of the horizontal and vertical axis titles to 10 and the font to Times New Roman, if necessary.
h. Change “Personnel” in the worksheet column heading to Human Resources, then AutoFit column D, and any other columns as necessary.
i. Change the font size of the legend to 14.
j. Add a solid line border in the default color and a (preset) Offset Diagonal Bottom Right shadow to the chart title.
k. Save your work.
6. Format a chart.
a. Make sure the chart is selected, then select the Chart Tools Format tab, if necessary.
b. Change the shape fill of the Excel data series to Dark Blue, Text 2.
c. Change the shape style of the Excel data series to Subtle Effect – Orange, Accent 6.
d. Save your work.
7. Annotate and draw on a chart.
a. Make sure the chart is selected, then create the text annotation Needs more users.
b. Position the text annotation so the word “Needs” is just below the word “Software” in the chart title.
c. Select the chart, then use the Chart Tools Format tab to create a 1½ pt weight dark blue arrow that points from the bottom center of the text box to the Excel users in the Human Resources category.
d. Deselect the chart.
e. Save your work.
8. Create a pie chart.
a. Select the range A1:F2, then create a 3-D Pie chart.
b. Drag the 3-D pie chart beneath the existing chart.
c. Change the chart title to Excel Users.
d. Apply the Style 7 chart style to the chart, then apply Layout 6 using the Quick Layout button.
e. Explode the Human Resources slice from the pie chart at 25%.
f. In Page Layout view, enter your name in the left section of the worksheet header.
g. Preview the worksheet and charts in Backstage view, make sure all the contents fit on one page, then submit your work to your instructor as directed. When printed, the worksheet should look like Figure 4-26. (Note that certain elements such as the title may look slightly different when printed.)
h. Save your work, close the workbook, then exit Excel.

Figure 4-26

2

EA 12 Instructions – Independent Challenge 4 x
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

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.

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 x
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 x.
· 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.