Project 4/7: Banquet Rooms

You are the administrative assitant for a large hotel that rents out banquet rooms. The rooms rent year-round at different prices. You are preparing a pricing worksheet.

Add Open to the Quick Access Toolbar.

1. Above the ribbon, click the Customize Quick Access Toolbar down arrow. (If the Quick Access Toolbar is not visible, go to File > Options> Quick Access Toolbar and check the box to Show Quick Access Toolbar, and select the Toolbar Position as Above Ribbon.)

2. Click Open.

Add the value New Rates to the Title property of the document.

1. Click the File tab.

2. Locate the list of Properties on the right side of the Info page.

3. In the Title property field, type New Rates.

4. Click the return arrow in the upper-left corner of the Info window to return to the worksheet.

Set cells A1:F10 so that they will be the only cells that print.

1. Select cell range A1:F10.

2. On the Page Layout tab, in the Page Setup group, click Print Area and select Set Print Area.

(Hint: You can check your print area setting under the File tab by selecting Print and viewing it in the Preview pane.)

Save the Rooms worksheet as a webpage named Rent_Prices.htm to the Gmetrix Templates folder.

1. Select the File tab

2. In the left pane, select Save As, and browse to the GMetrixTemplates folder.

3. In the Save As pop-up window, configure the following:

File name: Rent_Prices

Save as type: Web Page (*.htm, *.html)

4. Under Save: select Publish.

5. In the Publish as Web Page dialog box, select All Contents of Rooms.

6. Click Publish

(Hint: If prompted to keep using the format, click Yes.)

On the Rooms worksheet, configure the heading row in the table (row 2) so that entries wider than the column wrap to multiple lines.

1. On the Rooms worksheet, select row 2.

1. On the Home tab, in the Alignment group, click Wrap Text.