Question

Assume that the data on a worksheet consume a whole printed page and two columns on a second page. You can do all of the following except what to force the data to print all on one page?
1. Decrease the Sale value
2. Increase the left and right margins
3. Decrease column widths if possible
4. Select the smaller range as a print area

Answer 1

Answer:

Option (2) is the correct answer of this question.

Explanation:

We will increase the left and right margins of the data on a worksheet that will consume a whole printed page  and columns on second page then the data will print all in one page.

Following are the steps to print the Data all in on page:-

Step 1.  Choose the Ribbon Page Design button

Step2.  select 1 page in the Scale to Fit category, and in the Width box, we  will automatic choose the height box.                

Step 3 .Finally we will  choose 1 page in the Height box to print your worksheet to a single page.

 "Other options are incorrect because they are not related to the given    question.i.e, to print the data in on page in the worksheet".