Multiple choice technology

Suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page?

  1. Click Page Setup on the File menu, click the Sheet tab, and enter the row that contains these column headings under Print titles.

  2. Click Page Setup on the File menu, click the Page tab, click the Options button, then enter your choices.

  3. Click Page Setup on the File menu, click the Sheet tab, and make a selection under the Print heading.

  4. Noneofthese
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

To print column headings on each page, use Page Setup from the File menu, click the Sheet tab, and specify the row containing column headings under 'Print titles'. This repeats the specified rows on every printed page. Option B refers to the Page tab which doesn't handle this feature. Option C mentions 'Print heading' which doesn't exist.

Keep practicing — related questions