Question: You have a worksheet in Excel that will print as 10 pages. How can you ensure that the header row is printed at the top of each page?

  1. Use Print Titles on the Page Layout tab.
  2. Use Page Setup from the Backstage View.
  3. Use Freeze Panes on the View tab.
  4. Format your data as a table; the header prints automatically.

Answer: The correct answer of the above question is Option A:Use Print Titles on the Page Layout tab.