USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
When worksheet data will not fit on one page, Excel inserts automatic ____
|
|
page breaks
|
|
|
breaks
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -On more way of inserting page break in Excel is to go to the Page Layout tab, click Breaks in the Page Setup group and select the corresponding option from the drop-down list.
Detailed explanation-2: -Click on the Data tab in the menu bar. Click on the Subtotal button. In the “At each change in:” drop-down menu, select the item between which you would like to apply breaks. Click the checkbox for that item.
Detailed explanation-3: -In the Subtotal dialog, select the column you want to insert page break based on its value in At each change in drop down list, then choose the function you want to use from Use function list, then check Page break between groups checkbox and other options as you need. 3. Click OK.
There is 1 question to complete.