FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
You can scale a worksheet so that it will fit on one page with an option on the ____ tab in the Page Setup dialog box.
A
Margins
B
Header/Footer
C
Page
D
Sheet
Explanation: 

Detailed explanation-1: -If your worksheet has a lot of columns, you can use the Scale to Fit options to reduce the size of the worksheet to better fit the printed page. Follow these steps: 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.

Detailed explanation-2: -The Page Setup dialog allows end-users to specify the page orientation, paper size, margins, printout options, and it allows them to add headers and footers to a worksheet.

Detailed explanation-3: -On the Page Layout tab, select Page Setup. Under Scaling, select Fit to, and type 1 in both the page(s) wide box and page(s) tall box. Select OK.

There is 1 question to complete.