Rick works as an Office Executive for Perfect Wear Inc. He uses Microsoft Excel 2010 to maintain
sales record of each day. He needs to print the daily sales report. The management of the company
wants to ensure that each crucial report printed, must print a picture named conf.gif as a watermark
showing the confidential message.
Which of the following options should he use to accomplish the task?

A.
Use Page Layout > Page Setup > Background.

B.
Use Insert > Text > Headers & Footers.

C.
Use Insert > Illustrations > Picture.

D.
Use Page Layout > Page Setup > Print Titles.

Explanation:
Excel does not provide a facility to use image as a watermark. However, a user can mimic this facility
by using the Header & Footer option.

If Rick wants to display an image on every printed page, he can insert the image in a header or
footer. This configuration will enable the image to appear behind the text, at the top or bottom of
every page. He can also resize or scale the graphic to fill the page.
Answer D is incorrect. Print Titles option is used to configure printing options of a worksheet.
Answer C is incorrect. Through the Picture option in Illustrations, pictures can be inserted into the
sheet. But this cannot be used as watermark.
Answer A is incorrect. The Background option in the Page Setup group, on the Page Layout tab is
used to add background in a worksheet. However, this background does not get printed while
printing the sheet.