Excel Formatting Assignment Tallest Structure– (IC3 steps 11-1)
With the tallest_structures open from Part 2, make the following formatting changes.
Formatting Requirements
1) Switch to the Building worksheet. Click in any cell in column A. Then click the Sort Ascending button on the Standard toolbar. The building names are arranged in ascending alphabetical order, and the data in the other columns moves with the building name.
2) Click the Sort Descending button on the Standard toolbar. The building names are now arranged in descending alphabetical order, and the building data again moves with the building name.
3) Open the Data menu and choose Sort. All the data in the worksheet (except the headings) is selected and a dialog box is shown. Select Height in feet in the list box under Sort by. If necessary, select Descending at the right of the Sort by option.
4) Click the down arrow in the list box under the first Then by option. Select Location and then, if necessary, select Ascending at the right of the Then by option. Click the down arrow in the list box under the second Then by option. Select Building and then, if necessary, select Ascending at the right of the Then by option. Click OK.
5)The worksheet data is rearranged from highest to lowest. If any two building are the same height, they are sorted in alphabetical order by the city. If the two buildings are in the same location they are sorted in alphabetical order by building name.
8) Save changes before continuing.
9) Switch to the Towers worksheet. Click the Print Preview button on the Standard toolbar. Notice that Height in Feet column displays on Page 2. Click the Close button in the toolbar at the top of the screen to close Print Preview.
10) Open the File menu and choose Page Setup. If necessary, click the Page tab to. Notice the Scaling is set at Adjust to 100% normal size by default. Remember when you did Print preview Height in Feet was on page 2. To fix this, under Scaling, select Fit to option and accept the default settings of 1 page wide by 1 page tall. Click OK. When you click Print preview you will see the whole spreadsheet is on one page.
11) Click the Setup button again. Under Orientation, select Landscape. Under Scaling, select Adjust to and change the percentage in the % normal size box to 100. Click the Margins tab and Under Center on page at the bottom of the dialog box, select Horizontally. Click OK. Notice that this time the preview of the worksheet shows the image in normal size. The page is turned sideways, and the columns are centered horizontally. Close the Print Preview screen.
12) Switch to the Buildings worksheet, change the page orientation to landscape, and center the worksheet horizontally on the page.
13) Save changes before continuing.
14) Open the File menu and choose Page Setup. Click the Header/Footer tab. Open the Footer drop-down list, scroll down, and select tallest structures.xls, Page 1 (if you don't see this filename, you will see what you named your file instead). Click the Custom Header button. The cursor should be in the Left section. Click the Sheet name icon (it is the 8th icon from the left), the &[Tab] formatting code appears. Click the Right section. Click the Date icon (it looks like a calendar), the &[Date] formatting code appears. Click OK. The Page Setup dialog box now shows examples of both the header and footer selected. Click Print Preview to make sure it is formatted correctly. Click the Close button.
15) Select cells A1 through E1. Open the Format menu and select Cells. In the Format Cells dialog box, click on the Border tab. Choose None in the Presets section if necessary. In the Line, Style section, select the double line and then select Blue from the drop-down color palette.
16) In the Border section, choose the bottom horizontal line. The double blue line will appear in the preview box. Click OK. This border separates the headings from the data. Select cells A2 through E11. Open the Format menu and select Cells. Click on the Pattern tab. Select the light blue color and click OK. This sets the top ten buildings in the list apart for the rest.
17) Save before continuing.
18) Open the File menu and select Page Setup. In the Page Setup dialog box, select the Sheet tab. In the Print section, select the Gridlines option. Click the Print Preview button.
19) Select A1. Open the Format menu and select Style. Type Column Heading in the Style name text box. Click the Modify button. This opens the Format Cells dialog box. On the Number tab, verify that General is selected.
20) Click the Alignment tab. Set the Horizontal position to Left, and the Vertical position to Bottom. In the Orientation section of the alignment tab, drag the text indicator to 45 degrees. In the Text control section of the Alignment tab, select Wrap text. Click the Font tab. Change the Size to 12 and the Color to Blue. Leave the Border, Pattern and Protection tabs unchagned. Click OK.
21) In the Style dialog box, click Add. Notice that the text in A1 has changed to the new settings, but you can't read it because the cell is not tall enough.
22) Open the Format menu, select Row and select Height in the submenu. Set the row height to 55.
23) Open the Format menu, select Column and select Width in the submenu. Set the column width to 10.
24) Select B1 through E1. Open the Format menu and select Style. Select Column Heading from the drop-down Style name list box. Click OK. The style you created is applied to each of the cells in your selection. Note how the text wrapping worked in the last column.
25) Select A12. Open the File menu and select Page Setup. Switch to the Sheet tab. In the Print titles section, select the Collapse Dialog button at the end of the text box next to Rows to repeat at top. This will temporary collapse the Page Setup dialog box so that you can select the rows to repeat from within the worksheet.
26) Select row 1. Note that the formula for row 1 is inserted into the dialog box. Click the Expand Dialog button to see the entire Page Setup dialog box and then click Print Preview. The first page of your worksheet appears just as it would have regardless of your settings for a repeated heading row. Click the Next button. Close the Print Preview screen.
27) Save changes to file and close.