Skip to content

Practice Exam 1 - Project 1

Bicycles

The bicycle sales and rental store Bellows Bicycle Barn has asked you to update their summer sales flier to help attract new customers.

Task 1

On page 2 between the sections Affordable Pricing and Contact Us, Insert the file Bicycle_Pricing.xlsx located in the Gmetrix Templates folder. (Accept all defaults)

Hint
  1. On Page 2, place your cursor in the empty space between the sections Affordable Pricing and Contact Us.

  2. Click the Insert tab.

  3. In the Text group, click Object and select Object....

    Image title

  4. In the Object pop-up window, click the Create from File tab.

  5. On the Create from File tab, click the Browse button.

  6. Browse to the Gmetrix Templates folder and select Bicycle_Pricing.xlsx and click Insert.

  7. In the Object pop-up window, Click OK.

    Image title

Task 2

Hyperlink the header Bicycle Advantages on page 1 to the web page http://wikipedia.org/wiki/Bicycle.

Hint
  1. In the middle of page 1, select the header text "Bicycle Advantages".

  2. In the Insert tab, in the Links group, click Hyperlink.

    Image title

  3. In the Insert Hyperlink pop-up box, change the following: Link to: Existing File or Web Page Address: http://wikipedia.org/wiki/Bicycle.

  4. Click OK.

    (Hint: If you have an Internet connection, you can test your link by holding your CTRL key while clicking your mouse to follow the link.)

    Image title

    Image title

Task 3

Insert a Continuous Section Break on page 2 just before the heading Affordable Pricing.

Hint
  1. On page 2, place your cursor to the left the the heading Affordable Pricing.

    Image title

  2. Click the Layout tab.

  3. In the Page Setup group, click Breaks.

  4. Below Section Breaks, click Continuous.

    Image title

Task 4

In the first list, replace the bullets for all of the points below the Bicycle Advantages heading with the graphic Bike Rider.png located in the Gmetrix Templates folder.

Hint
  1. Select all of the text below the heading Bicycle Advantages, beginning with the text Low maintenance... and ending with store.

  2. On the Home tab, in the Paragraph group, click the Bullets down-arrow and select Define New Bullet....

    Image title

  3. In the Define New Bullet pop-up box, under Bullet character, click Picture....

  4. In the Insert Pictures pop-up box, to the right of From a file, click Browse and locate the Gmetrix Templates folder. Select the file, Bike Rider.png and click Insert. Notice the sample of the new bullet displayed in the Preview window.

  5. On the Define New Bullet pop-up box, Click OK.

    Image title

    Image title

    Image title

Task 5

Apply the Soft Edge Rectangle style to the photo at the bottom of page 1.

Hint
  1. At the bottom of Page 1, click on the photo to select it.

  2. Select the Picture tools format tab.

  3. In the Picture Styles group, select Soft Edge Rectangle.

    Image title

    Image title