Interview Questions And Answers Forum

hamidoon123

Moderator

Registered: 2017-09-21

Posts: 50,766

In Excel suppose you have columns of datathat span more than one ...

Computer Info and Shortcut Keys Exams Quizzes MCQs Quizzes MS Excel Test 3

Question:
In Excel suppose you have columns of datathat span more than one printed page. Howcan you automatically print the columnheadings on each page?

Option A):
All these
Option B):
Click page setup on the final menu, click the sheet tab, and make a selection under the print heading.
Option C):
Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings underprint titles.
Option D):
Click page setup on the file menu, click the page tab, click the options button, then enter your choices.

Correct Answer is Option C):
Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings underprint titles.