You work as an Office Assistant for Media Perfect Inc. Your responsibility includes creating sales
reports for the Sales department. You use Microsoft Excel 2010 to create these reports. You have
created an yearly sales report. The fragment of the report is shown below:
As the report is quite wide, printing this report involves three A4 size pages. You want the first
column (column A) to repeat in every printed page. Mark the option that you will choose to
accomplish the task.
Answer: 
Explanation:
The question states that the report is quite wide and takes three pages to print. You are
required to repeat column A in each printed page. In order to repeat the column in every printed
page, you will have to take the following steps:
Choose the Print Titles option in the Page Setup group on the Page Layout tab. This will open the
Page Setup window.In the Columns to repeat at left option, provide the required column value.
These steps will enforce Excel to repeat column A at the left side of each printed page.
