USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Print titles
|
|
|
b
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Click the [Page Layout] tab > In the “Page Setup” group, click [Print Titles]. Under the [Sheet] tab, in the “Rows to repeat at top” field, click the spreadsheet icon. Click and select the row you wish to appear at the top of every page. Press the [Enter] key, then click [OK].
Detailed explanation-2: -Click the Page Layout tab on the ribbon. In the Scale to Fit group, in the Width box, select 1 page, and in the Height box, select Automatic. Columns will now appear on one page, but the rows may extend to more than one page. To print your worksheet on a single page, choose 1 page in the Height box.
Detailed explanation-3: -Select a column, and then select Transform > Rename. You can also double-click the column header. Enter the new name.