FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which Excel feature or view lets you drag automatic page breaks converting them to manual page breaks, to achieve a more desirable printed document
A
Print Preview
B
Page Break Preview
C
Page Layout view
D
Normal view
Explanation: 

Detailed explanation-1: -Move a page break On the View menu, click Page Break Preview., and then drag the page break line to a new location. Note: When you move an automatic page break, it changes to a manual page break.

Detailed explanation-2: -Just click into the document at the place where you want the page break to occur. This should, of course, be before the automatic page break. Then press “Ctrl” + “Enter” on your keyboard. Alternatively, click the “Breaks” button in the “Page Setup” group on the “Layout” tab of the Ribbon.

Detailed explanation-3: -Page breaks divide worksheets into separate pages when you print. In Page Break Preview you can insert, move, or remove page breaks.

There is 1 question to complete.