5.4 Chapter Scored
Roofing Companies
Download Data File: SC5 Data
- Open the data file SC5 Data and save the file to your computer as SC5 Roofing Companies.
- Delete Columns D & E
- Expand Column A to a 40 pt. width
- Format Columns B to a 15 pt. width.
- Format Column C to a 18 pt. width
- Create a Table by clicking anywhere in the worksheet, then click on the Insert tab. then Table. Make sure to check the box “My table has headers” and then click OK.
- Choose Blue, Table Style Medium 2
- Select “Remove Duplicates” within Table Design ribbon.
- When the menu box opens, Unselect all Columns except Company.
- Confirm you receive a text ox that says, “52 duplicate values found and removed; 87 unique values remain.” Hit OK.
- Copy/Paste this worksheet to create a new worksheet; rename this newly created worksheet as State Missing.
- Filter column E to display just “Blank” and hit OK. This will show you only companies that do not have a state listed with their information.
- Copy/Paste A.S.R. worksheet to create a new worksheet; rename this newly created worksheet as Last Name Missing.
- Filter column C to display just “Blank” and hit OK. This will show you only companies that do not have a a Last Name entered with their information.
- Copy/Paste A.S.R. worksheet to create a new worksheet; rename this newly created worksheet as OR Roofing Companies with Tag
- Format Column D Best Fit.
- Center the text for A1:F1 so that column headings are centered over each column.
- Format Column F to 87 pts.
- Use Filter by Text, then use a “custom filter” to display/filter companies that contain companies that are ‘Minority Business Enterprise (MBE)’ or ‘Women Business Enterprise (WBE)’. Hint: you need to select “contain” for both rows in the custom filter.
- Filter companies only located in Oregon.
- Sort by Last Name, A to Z.
- Save the file; submit as directed.