[Solved] In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page?

McqMate

Q.	In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page?
A.	Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles.
B.	Click page setup on the file menu, click the page tab, click the options button, then enter your choices.
C.	Click page setup on the finle menu, click the sheet tab, and make a selection under the print heading.
D.	All of above
Answer» A. Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles.

3.6k

0

Do you find this helpful?

54

View all MCQs in

Microsoft Excel (MS Excel)

Discussion

No comments yet

Related MCQs

In Excel A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button
In Excel the view that puts a blue a blue line around each page that would be printed is the
If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?
How should you print a selected area of a worksheet, if you’ll want to print a different area next time?
In Excel say that you want to paste a formula result – but not the underlying formula – to another cell. In excel 2002, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to what next?
In Excel you can use drag and drop to embed excel worksheet data in a word document
In Excel you can use drag-and-drop to embed excel worksheet data in a word document
In Excel you can convert existing excel worksheet data an charts to an HTML document by using
In Excel when you want to insert a blank imbedded excel object in a word document you can
In Excel you can print